Getting Started
Supported Databases
DB AI Magic talks to every popular database through a single adapter layer. Here's what works today and what's on the roadmap.
Relational engines
Relational databases get the full query editor, data editor, schema viewer, and reporting surface — everything DB AI Magic can do.
| Engine | Status | Notes |
|---|---|---|
| PostgreSQL | Ready | Full DDL/DML/DQL support. Streams large result sets. |
| MySQL | Ready | Auth modes including caching_sha2_password are supported. |
| Microsoft SQL Server | Ready | Encrypted connections, instance/port detection. |
| SQLite | Ready | Upload a .sqlite file and start querying instantly. |
Document databases
Document databases get a browse-and-query experience with full read / write access. Charts work the same — DB AI Magic flattens the documents on the fly.
| Engine | Status | Notes |
|---|---|---|
| MongoDB | Ready | Browse collections, run queries, edit documents. |
On the roadmap
These engines have stub adapters in place and are queued for release. We prioritise based on customer demand — let us know if one of these is critical for you.
| Engine | Status | Notes |
|---|---|---|
| MariaDB | Coming soon | Treated as MySQL-compatible — same driver, same features. |
| Azure SQL | Coming soon | Identical surface to SQL Server with secure defaults. |
| CockroachDB | Coming soon | Postgres-compatible — works with the Postgres adapter. |
| Amazon Redshift | Coming soon | Postgres-compatible analytic engine. |
| Greenplum | Coming soon | Postgres-compatible MPP engine. |
| Oracle | Coming soon | Public roadmap. |
| Snowflake | Coming soon | Public roadmap. |
| BigQuery | Coming soon | Public roadmap. |
| ClickHouse | Coming soon | Public roadmap. |
| DynamoDB | Coming soon | Public roadmap. |
| Cassandra | Coming soon | Public roadmap. |
| Redis | Coming soon | Public roadmap. |
| Elasticsearch | Coming soon | Public roadmap. |
| IBM Db2 | Coming soon | Public roadmap. |
| Couchbase | Coming soon | Public roadmap. |
Feature parity
Universal capabilities
Browse, query, edit data, schema viewer, export, AI Chat, dashboards and reports all work for any stable engine. The interface looks identical regardless of which engine you're on.
Engine-specific behaviour
Some operations naturally depend on the engine — for example, MongoDB uses collections instead of tables, and SQLite is single-file. DB AI Magic hides the differences where it can and surfaces them clearly where you need to be aware.
Need a different engine?
Requesting an engine
Reach out via the pricing page contact link with the engine name, the version you use, and a short note on what you need to do with it. Engines with multiple requests jump to the top of the queue.