MotionQL

More databases

Supported databases

All 66 databases and cloud services MotionQL connects to, how each is recognised and its default port.

MotionQL 1.7.1 connects to 66 databases and services. Each one is recognised when you connect (from the host name or what the server reports), and the connection's Server type setting overrides that.

Depth: Deep means the most complete support, with every MotionQL tool. Good means a complete everyday client: browse, query, edit, import and export, and Ask AI.

MongoDB and compatible services

DatabaseDepthDefault portRecognised by
MongoDBDeep27017Default for MongoDB connections.
MongoDB AtlasDeep27017Host *.mongodb.net.
Azure Cosmos DB for MongoDB (RU)Good10255Host *.mongo.cosmos.azure.com or *.documents.azure.com, or server markers.
Azure DocumentDBGood10260Host *.mongocluster.cosmos.azure.com, or server markers.
Amazon DocumentDBGood27017Host *.docdb.amazonaws.com, or server markers.
Amazon DocumentDB elastic clusterGood27017Host *.docdb-elastic.amazonaws.com.
FerretDBGood27017buildInfo reports ferretdb.

PostgreSQL and PostgreSQL-protocol servers

DatabaseDepthDefault portRecognised by
PostgreSQLDeep5432Default for PostgreSQL connections.
SupabaseGood5432Host *.supabase.co or *.pooler.supabase.com, or the auth and storage schemas plus the anon and authenticated roles.
NeonGood5432Host *.neon.tech, or neon.* settings.
TimescaleDBGood5432The timescaledb extension, or host *.tsdb.cloud.timescale.com.
CitusGood5432The citus extension, or host *.postgres.cosmos.azure.com.
Azure Database for PostgreSQLGood5432Host *.postgres.database.azure.com, or azure.* settings or the azure_pg_admin role.
Amazon RDS for PostgreSQLGood5432Host *.rds.amazonaws.com, or rds.* settings or the rdsadmin role.
Amazon Aurora PostgreSQLGood5432The aurora_version() function, or an Aurora cluster host.
Amazon RedshiftGood5439version() contains Redshift.
CockroachDBGood26257version() contains CockroachDB.
YugabyteDBGood5433version() contains -YB-.
QuestDBGood8812version() contains QuestDB.
RisingWaveGood4566version() contains RisingWave.
MaterializeGood6875version() contains Materialize, or the mz_version() function.
CrateDBGood5432version() contains CrateDB.

MySQL and MariaDB

DatabaseDepthDefault portRecognised by
MySQLDeep3306Default for MySQL connections.
Amazon RDS for MySQLGood3306Host *.rds.amazonaws.com, or a /rdsdbbin/ base directory.
Amazon Aurora MySQLGood3306VERSION() contains mysql_aurora, or @@aurora_version.
MariaDBDeep3306VERSION() contains MariaDB.
Amazon RDS for MariaDBGood3306A MariaDB server with host *.rds.amazonaws.com or a /rdsdbbin/ base directory.
Percona Server for MySQLGood3306@@version_comment names Percona.
TiDBGood4000VERSION() contains TiDB.

SQL Server

DatabaseDepthDefault portRecognised by
SQL ServerDeep1433Default for SQL Server connections.
Azure SQLGood1433SERVERPROPERTY('EngineEdition') is 5 (Database) or 8 (Managed Instance), or host *.database.windows.net.

Oracle

DatabaseDepthDefault portRecognised by
OracleGood1521Default for Oracle connections.
Oracle Autonomous DatabaseGood1522SYS_CONTEXT('USERENV', 'CLOUD_SERVICE') or v$pdbs.cloud_identity, or host *.oraclecloud.com.

SQLite

DatabaseDepthDefault portRecognised by
SQLiteGood—Default for SQLite files.

DuckDB

DatabaseDepthDefault portRecognised by
DuckDBGood—Default for DuckDB files.

JDBC databases

DatabaseDepthDefault portRecognised by
IBM Db2Good50000Default for Db2 connections (JDBC bridge, IBM jcc driver).
FirebirdGood3050Default for Firebird connections (JDBC bridge, Jaybird driver).
H2Good9092Default for H2 connections (JDBC bridge, or H2's PostgreSQL server without Java).
HSQLDBGood9001Default for HSQLDB connections (JDBC bridge).
Apache DerbyGood1527Default for Derby connections (JDBC bridge).

Redis and Valkey

DatabaseDepthDefault portRecognised by
RedisGood6379INFO server redis_version (also Dragonfly, KeyDB, ElastiCache, MemoryDB, Azure, Upstash and Redis Cloud by version fields or host).
ValkeyGood6379INFO server valkey_version or server_name:valkey.

ClickHouse

DatabaseDepthDefault portRecognised by
ClickHouseGood8123Default for ClickHouse connections (HTTP interface; HTTPS when TLS is on).

Snowflake

DatabaseDepthDefault portRecognised by
SnowflakeGood443Default for Snowflake connections.

Google BigQuery

DatabaseDepthDefault portRecognised by
Google BigQueryGood443Default for BigQuery connections; an emulator endpoint (goccy/bigquery-emulator) is recognised by its host.

Trino, PrestoDB and Starburst

DatabaseDepthDefault portRecognised by
TrinoGood8080Default for Trino connections (GET /v1/info).
PrestoDBGood8080The server refuses X-Trino-* headers and answers with X-Presto-* (or the connection is set to PrestoDB).
StarburstGood443Host *.galaxy.starburst.io, or a Starburst Enterprise version (e.g. 453-e.5).

Databricks SQL

DatabaseDepthDefault portRecognised by
Databricks SQLGood443Default for Databricks connections (AWS *.cloud.databricks.com, Azure *.azuredatabricks.net, GCP *.gcp.databricks.com).

Google Cloud Spanner

DatabaseDepthDefault portRecognised by
Google Cloud SpannerGood443Default for Spanner connections (a GoogleSQL database); an emulator endpoint is recognised by its host.
Cloud Spanner (PostgreSQL)Good443The database's databaseDialect is POSTGRESQL (read with the database on connect).

Elasticsearch and OpenSearch

DatabaseDepthDefault portRecognised by
ElasticsearchGood9200GET / version.number with no version.distribution (and the X-Elastic-Product header).
OpenSearchGood9200GET / version.distribution "opensearch".
Elastic CloudGood443A Cloud ID, or a host under *.elastic-cloud.com / *.found.io.
Amazon OpenSearch ServiceGood443A host under *.es.amazonaws.com or *.aoss.amazonaws.com (Serverless); AWS SigV4 sign-in.

Amazon DynamoDB

DatabaseDepthDefault portRecognised by
Amazon DynamoDBGood443The AWS regional endpoint; an endpoint URL on localhost:8000 is DynamoDB Local, :4566 LocalStack.

Apache Cassandra and ScyllaDB

DatabaseDepthDefault portRecognised by
Apache CassandraGood9042Default for CQL connections; system.local release_version (DataStax Enterprise when it has dse_version; Astra with a secure connect bundle).
ScyllaDBGood9042The system.versions table, which only ScyllaDB has.

InfluxDB

DatabaseDepthDefault portRecognised by
InfluxDBGood8086Default for "InfluxDB 2.x / Cloud" connections: /ping X-Influxdb-Version 2.x with X-Influxdb-Build OSS (Flux, and InfluxQL through the v1 compatibility API).
InfluxDB CloudGood443A URL under *.cloud2.influxdata.com, or X-Influxdb-Build Cloud. Untested against a live account (mocked in the unit tests).
InfluxDB 3Good8181Default for "InfluxDB 3" connections: /ping product_name InfluxDB 3 Core or Enterprise, version 3.x (SQL and InfluxQL over /api/v3/query_sql and /api/v3/query_influxql).

Neo4j and Memgraph (graph)

DatabaseDepthDefault portRecognised by
Neo4jGood7687Default for Bolt connections; dbms.components() gives the version and edition (Community or Enterprise).
Neo4j AuraGood7687A host under *.databases.neo4j.io (always neo4j+s://).
MemgraphGood7687The Bolt server agent "Memgraph/…" (or SHOW STORAGE INFO answering where dbms.components() does not).

Cloud Firestore (Firebase)

DatabaseDepthDefault portRecognised by
Cloud FirestoreGood443Firestore connections (Firebase projects): Native mode databases, the default one or a named one; Datastore mode is refused on connect.
Firestore emulatorGood8080A Firestore connection with an emulator address (Firebase Local Emulator Suite, owner token).

Planned: the open-source DocumentDB engine. Missing a database you use? Tell us on the support page.

Something unclear or out of date? Write to support@motionql.com.