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
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.
Any database with an ODBC driver: browse, query and export.
Planned for an upcoming release.
EVERY DATABASE
| Database | Kind | Support | What you get | Not supported |
|---|---|---|---|---|
| PostgreSQL | Relational | Release 1 | Including 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 |
| MySQL | Relational | Release 1 | Including 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 |
| MariaDB | Relational | Release 1 | Its own connection with MySQL’s options. | Supports everything |
| Microsoft SQL Server | Relational | Release 1 | Including Azure SQL Database, Managed Instance and Synapse, with SQL logins or Microsoft Entra ID sign-in; GO batches. | Supports everything |
| Oracle | Relational | Release 1 | A direct client with no Instant Client to install; service names, SIDs and tnsnames.ora aliases; PL/SQL blocks and packages. | Supports everything |
| SQLite | Embedded | Release 1 | Open or create a file; attached databases show as schemas. | Database does not supportExplain Analyze, Server Activity, Users and Roles |
| DuckDB | Embedded / analytics | Release 1 | Built into DataWorx: query CSV, Parquet and JSON files, and join results from other connections. | Database does not supportServer Activity, Users and Roles |
| PGlite | Embedded | Release 1 | Real PostgreSQL running inside DataWorx, kept in a folder or in memory, with no server to install. | Database does not supportServer Activity, Cancel |
| CockroachDB | Distributed SQL | Release 1 | Self-hosted or CockroachDB Cloud, with its own plans in Explain. | Supports everything |
| Snowflake | Cloud data warehouse | Release 1 | Password, token, key-pair or OAuth sign-in, and connections.toml profiles. | Supports everything |
| Google BigQuery | Cloud data warehouse | Release 1 | Datasets, tables, views and routines; cost shown before and after each query, with a maximum bytes billed per connection. | Database does not supportUsers and Roles |
| Databricks | Lakehouse | Release 1 | SQL warehouses with Unity Catalog, physical plans in Explain, and the warehouse’s queries in Server Activity. | Database does not supportDry Run, Explain Analyze |
| Amazon Redshift | Cloud data warehouse | Release 1 | Serverless and provisioned, with AWS IAM sign-in, distribution and sort keys, and Redshift’s plans. | Database does not supportExplain Analyze |
| ClickHouse | Analytics | Release 1 | Self-hosted or ClickHouse Cloud over HTTP or HTTPS, with ClickHouse’s own types. | Database does not supportDry Run |
| StarRocks | Analytics | Release 1 | Key models, distribution and partitioning; results from primary-key tables are editable. | Database does not supportDry Run |
| Apache Doris | Analytics | Release 1 | Key models, distribution, partitioning and plans. | Database does not supportDry Run, Explain Analyze |
| Materialize | Streaming SQL | Release 1 | Sources, materialized views and clusters, with its plans in Explain. | Database does not supportDry Run, Explain Analyze, table designer |
| RisingWave | Streaming SQL | Release 1 | Tables, sources and materialized views from its own catalog. | Database does not supportDry Run, Explain Analyze |
| CrateDB | Distributed SQL | Release 1 | Sharding in table details and shard sizes in Table Statistics. | Database does not supportDry Run |
| Apache Spark SQL | Big data | Release 1 | Through 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 Hive | Big data | Release 1 | Through HiveServer2: databases, tables, views and partitions, paged results, and Hive’s plans. | Database does not supportDry Run, Explain Analyze, Server Activity |
| Trino and Presto | Distributed SQL | Release 1 | Every 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 HANA | Relational | Release 1 | HANA, HANA Express or HANA Cloud: row and column tables, calculation views, PlanViz’s measured plans, and sessions in Server Activity. | Supports everything |
| Amazon Athena | Serverless SQL | Release 1 | Workgroups 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 |
| Firebird | Relational | Release 1 | Firebird 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 |
| SurrealDB | Multi-model | Release 1 | SurrealDB 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 |
| MongoDB | Document | Release 1 | Including 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 Cassandra | Wide-column | Release 1 | Keyspaces, tables and their keys, CQL consoles, and consistency levels. | Database does not supportDry Run, Explain Analyze |
| Amazon DynamoDB | Key-value / document | Release 1 | Tables 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 |
| Redis | Key-value | Release 1 | Including Valkey: keys by type, values, commands with replies as tables, and clients in Server Activity. | Database does not supportExplain, Dry Run, table designer, Compare |
| Elasticsearch | Search | Release 1 | Indices, aliases and data streams; SQL or Kibana-style requests, and the query DSL in Explain. | Database does not supportDry Run, table designer |
| OpenSearch | Search | Release 1 | Self-hosted or a managed domain, with everything Elasticsearch connections do. | Database does not supportDry Run, table designer |
| Neo4j | Graph | Release 1 | Neo4j 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 3 | Time series | Release 1 | Tags, fields and time; SQL or InfluxQL; plans; and importing data as points. | Database does not supportDry Run, table designer, Users and Roles |
| YugabyteDB | Distributed SQL | Release 1 | As PostgreSQL: everything works. | Supports everything |
| TimescaleDB | Time series | Release 1 | As PostgreSQL: everything works. | Supports everything |
| AlloyDB Omni | Relational | Release 1 | As PostgreSQL: everything works. | Supports everything |
| openGauss | Relational | Release 1 | As PostgreSQL: everything works. | Supports everything |
| TiDB | Distributed SQL | Release 1 | As MySQL: everything works. | Supports everything |
| OceanBase | Distributed SQL | Release 1 | As MySQL: everything works, with its own plans in Explain. | Supports everything |
| GreptimeDB | Time series | Release 1 | As MySQL: results edited by writing rows again (it has no UPDATE). | Database does not supportDry Run |
| Microsoft Fabric | Cloud data warehouse | Release 1 | As SQL Server, with Entra ID sign-in. | Database does not supportExplain |
| Babelfish for PostgreSQL | Relational | Release 1 | As SQL Server. | Supports everything |
| FerretDB | Document | Release 1 | As MongoDB: everything MongoDB connections do. | Database does not supportDry Run, table designer, ER diagrams, schema comparison |
| Microsoft DocumentDB | Document | Release 1 | As MongoDB: everything MongoDB connections do. | Database does not supportTable designer, ER diagrams, schema comparison |
| ODBC data sources | Any | Via ODBC | DSNs, drivers or connection strings; installed drivers are found for you. Other features depend on the driver. | Database does not supportExplain |
| Google Cloud Spanner | Distributed SQL | On the release roadmap | Planned for an upcoming release. | — |
| SAP SQL Anywhere | Relational | On the release roadmap | Planned for an upcoming release. | — |
| Teradata Vantage | Cloud data warehouse | On the release roadmap | Planned for an upcoming release. | — |
| Vertica | Analytics | On the release roadmap | Planned for an upcoming release. | — |
| SingleStore | Distributed SQL | On the release roadmap | Planned for an upcoming release. | — |
| GreengageDB (Greenplum) | Analytics | On the release roadmap | Planned for an upcoming release. | — |
| Yellowbrick | Cloud data warehouse | On the release roadmap | Planned for an upcoming release. | — |
| VeloDB | Analytics | On the release roadmap | Planned for an upcoming release. | — |
| Oracle Autonomous Database | Relational | On the release roadmap | Planned for an upcoming release. | — |
| Amazon Aurora DSQL | Distributed SQL | On the release roadmap | Planned for an upcoming release. | — |
| LibSQL and Turso | Embedded | On the release roadmap | Planned for an upcoming release. | — |
| chDB | Embedded / analytics | On the release roadmap | Planned for an upcoming release. | — |
No database matches that.
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.