DWDataWorxGet DataWorx ↗

DATAWORX / DATABASES

Your databases,
at home.

DataWorx speaks the databases you already use, from the classic relational engines to cloud warehouses, NoSQL stores, graph and time series. Each gets a connection built around its own catalog, types, plans and sign-in, and the list keeps growing with every release.

LEVELS OF SUPPORT

Release 1

In the first release: a connection built around the database’s own catalog, types, plans and sign-in, or the connection of the database it’s compatible with. Anything a database doesn’t support is listed beside it.

Via ODBC

Any database with an ODBC driver: browse, query and export.

On the release roadmap

Planned for an upcoming release.

EVERY DATABASE

DatabaseKindSupportWhat you getNot supported
PostgreSQLRelationalRelease 1Including Amazon RDS and Aurora (with IAM sign-in), Google Cloud SQL and AlloyDB, Azure Database for PostgreSQL (with Entra ID sign-in), PostGIS, and the PL/pgSQL debugger.Supports everything
MySQLRelationalRelease 1Including Amazon RDS and Aurora (with IAM sign-in), Google Cloud SQL, and Azure Database for MySQL (with Entra ID sign-in); option files and login paths.Supports everything
MariaDBRelationalRelease 1Its own connection with MySQL’s options.Supports everything
Microsoft SQL ServerRelationalRelease 1Including Azure SQL Database, Managed Instance and Synapse, with SQL logins or Microsoft Entra ID sign-in; GO batches.Supports everything
OracleRelationalRelease 1A direct client with no Instant Client to install; service names, SIDs and tnsnames.ora aliases; PL/SQL blocks and packages.Supports everything
SQLiteEmbeddedRelease 1Open or create a file; attached databases show as schemas.Database does not supportExplain Analyze, Server Activity, Users and Roles
DuckDBEmbedded / analyticsRelease 1Built into DataWorx: query CSV, Parquet and JSON files, and join results from other connections.Database does not supportServer Activity, Users and Roles
PGliteEmbeddedRelease 1Real PostgreSQL running inside DataWorx, kept in a folder or in memory, with no server to install.Database does not supportServer Activity, Cancel
CockroachDBDistributed SQLRelease 1Self-hosted or CockroachDB Cloud, with its own plans in Explain.Supports everything
SnowflakeCloud data warehouseRelease 1Password, token, key-pair or OAuth sign-in, and connections.toml profiles.Supports everything
Google BigQueryCloud data warehouseRelease 1Datasets, tables, views and routines; cost shown before and after each query, with a maximum bytes billed per connection.Database does not supportUsers and Roles
DatabricksLakehouseRelease 1SQL warehouses with Unity Catalog, physical plans in Explain, and the warehouse’s queries in Server Activity.Database does not supportDry Run, Explain Analyze
Amazon RedshiftCloud data warehouseRelease 1Serverless and provisioned, with AWS IAM sign-in, distribution and sort keys, and Redshift’s plans.Database does not supportExplain Analyze
ClickHouseAnalyticsRelease 1Self-hosted or ClickHouse Cloud over HTTP or HTTPS, with ClickHouse’s own types.Database does not supportDry Run
StarRocksAnalyticsRelease 1Key models, distribution and partitioning; results from primary-key tables are editable.Database does not supportDry Run
Apache DorisAnalyticsRelease 1Key models, distribution, partitioning and plans.Database does not supportDry Run, Explain Analyze
MaterializeStreaming SQLRelease 1Sources, materialized views and clusters, with its plans in Explain.Database does not supportDry Run, Explain Analyze, table designer
RisingWaveStreaming SQLRelease 1Tables, sources and materialized views from its own catalog.Database does not supportDry Run, Explain Analyze
CrateDBDistributed SQLRelease 1Sharding in table details and shard sizes in Table Statistics.Database does not supportDry Run
Apache Spark SQLBig dataRelease 1Through Spark’s Thrift Server: databases, tables, views and partitions, paged results, and Spark’s plans.Database does not supportDry Run, Explain Analyze, Server Activity, Users and Roles
Apache HiveBig dataRelease 1Through HiveServer2: databases, tables, views and partitions, paged results, and Hive’s plans.Database does not supportDry Run, Explain Analyze, Server Activity
Trino and PrestoDistributed SQLRelease 1Every catalog over HTTP or HTTPS, with password or JWT sign-in, Trino’s plans, and editing wherever the catalog’s connector allows it.Database does not supportDry Run
SAP HANARelationalRelease 1HANA, HANA Express or HANA Cloud: row and column tables, calculation views, PlanViz’s measured plans, and sessions in Server Activity.Supports everything
Amazon AthenaServerless SQLRelease 1Workgroups found with Add from Cloud, AWS profile or key sign-in, the data each query scanned and about what it cost, and editing Iceberg tables.Database does not supportDry Run, Users and Roles
FirebirdRelationalRelease 1Firebird 3, 4 and 5 with SRP sign-in and wire encryption, PSQL with or without SET TERM, the profiler’s measured plans, and gbak dumps.Supports everything
SurrealDBMulti-modelRelease 1SurrealDB 1, 2 and 3 over WebSocket or HTTP, SurrealQL with each statement’s rows as a table, graph tables, and records edited by their IDs.Supports everything
MongoDBDocumentRelease 1Including MongoDB Atlas and Azure Cosmos DB for MongoDB: native query consoles, document panels, and editable documents.Database does not supportTable designer, ER diagrams, schema comparison
Apache CassandraWide-columnRelease 1Keyspaces, tables and their keys, CQL consoles, and consistency levels.Database does not supportDry Run, Explain Analyze
Amazon DynamoDBKey-value / documentRelease 1Tables and indexes, PartiQL, and sign-in with your AWS profile; DynamoDB Local too.Database does not supportExplain, Dry Run, table designer, Server Activity, Users and Roles
RedisKey-valueRelease 1Including Valkey: keys by type, values, commands with replies as tables, and clients in Server Activity.Database does not supportExplain, Dry Run, table designer, Compare
ElasticsearchSearchRelease 1Indices, aliases and data streams; SQL or Kibana-style requests, and the query DSL in Explain.Database does not supportDry Run, table designer
OpenSearchSearchRelease 1Self-hosted or a managed domain, with everything Elasticsearch connections do.Database does not supportDry Run, table designer
Neo4jGraphRelease 1Neo4j or Aura: labels and relationship types, Cypher consoles, plans and profiles, and the graph of labels in the ER diagram.Database does not supportTable designer
InfluxDB 3Time seriesRelease 1Tags, fields and time; SQL or InfluxQL; plans; and importing data as points.Database does not supportDry Run, table designer, Users and Roles
YugabyteDBDistributed SQLRelease 1As PostgreSQL: everything works.Supports everything
TimescaleDBTime seriesRelease 1As PostgreSQL: everything works.Supports everything
AlloyDB OmniRelationalRelease 1As PostgreSQL: everything works.Supports everything
openGaussRelationalRelease 1As PostgreSQL: everything works.Supports everything
TiDBDistributed SQLRelease 1As MySQL: everything works.Supports everything
OceanBaseDistributed SQLRelease 1As MySQL: everything works, with its own plans in Explain.Supports everything
GreptimeDBTime seriesRelease 1As MySQL: results edited by writing rows again (it has no UPDATE).Database does not supportDry Run
Microsoft FabricCloud data warehouseRelease 1As SQL Server, with Entra ID sign-in.Database does not supportExplain
Babelfish for PostgreSQLRelationalRelease 1As SQL Server.Supports everything
FerretDBDocumentRelease 1As MongoDB: everything MongoDB connections do.Database does not supportDry Run, table designer, ER diagrams, schema comparison
Microsoft DocumentDBDocumentRelease 1As MongoDB: everything MongoDB connections do.Database does not supportTable designer, ER diagrams, schema comparison
ODBC data sourcesAnyVia ODBCDSNs, drivers or connection strings; installed drivers are found for you. Other features depend on the driver.Database does not supportExplain
Google Cloud SpannerDistributed SQLOn the release roadmapPlanned for an upcoming release.—
SAP SQL AnywhereRelationalOn the release roadmapPlanned for an upcoming release.—
Teradata VantageCloud data warehouseOn the release roadmapPlanned for an upcoming release.—
VerticaAnalyticsOn the release roadmapPlanned for an upcoming release.—
SingleStoreDistributed SQLOn the release roadmapPlanned for an upcoming release.—
GreengageDB (Greenplum)AnalyticsOn the release roadmapPlanned for an upcoming release.—
YellowbrickCloud data warehouseOn the release roadmapPlanned for an upcoming release.—
VeloDBAnalyticsOn the release roadmapPlanned for an upcoming release.—
Oracle Autonomous DatabaseRelationalOn the release roadmapPlanned for an upcoming release.—
Amazon Aurora DSQLDistributed SQLOn the release roadmapPlanned for an upcoming release.—
LibSQL and TursoEmbeddedOn the release roadmapPlanned for an upcoming release.—
chDBEmbedded / analyticsOn the release roadmapPlanned for an upcoming release.—

Database does not support marks what the database itself doesn’t have, so no tool can offer it there.

Databases that speak PostgreSQL’s, MySQL’s, SQL Server’s or MongoDB’s protocol often work as those, beyond the ones tested above. Don’t see yours? Tell us which database you use.