The universal web IDE
for every database
Connect to PostgreSQL, MySQL, MongoDB, MSSQL, SQLite and more — right from your browser. Write SQL with AI, edit data like a spreadsheet, design dashboards, and ship scheduled reports. No installs, no drivers, no DBA tickets.
| country | orders | revenue |
|---|---|---|
| United States | 12,418 | $284,901.12 |
| Germany | 3,902 | $92,144.08 |
| India | 3,210 | $71,029.55 |
| United Kingdom | 2,845 | $66,701.40 |
| Japan | 1,994 | $48,212.66 |
One workspace for every database
- PostgreSQL
- MySQL
- MariaDB
- Microsoft SQL Server
- Azure SQL
- SQLite
- CockroachDB
- Amazon Redshift
- Greenplum
- MongoDB
- Oracle
- Snowflake
- BigQuery
- ClickHouse
- DynamoDB
- Cassandra
- Redis
- Elasticsearch
- IBM Db2
- Couchbase
- PostgreSQL
- MySQL
- MariaDB
- Microsoft SQL Server
- Azure SQL
- SQLite
- CockroachDB
- Amazon Redshift
- Greenplum
- MongoDB
- Oracle
- Snowflake
- BigQuery
- ClickHouse
- DynamoDB
- Cassandra
- Redis
- Elasticsearch
- IBM Db2
- Couchbase
Database engines supported
Median query latency
GCM credential encryption
Runs in your browser
Features
Everything you need to work with data
DB AI Magic replaces a stack of disconnected database tools with one fast, collaborative workspace.
AI Chat for Your Database
Ask in plain English. DB AI Magic introspects your schema, writes the SQL, runs it, and visualizes the result — auto-retrying up to five times if a query fails.
Truly Universal
PostgreSQL, MySQL, MariaDB, MSSQL, Azure SQL, MongoDB, SQLite, Redshift, CockroachDB and Greenplum — one consistent UI across every engine.
Monaco SQL Editor
The editor that powers VS Code: autocomplete, syntax highlighting, multi-cursor, snippets, and full keyboard shortcuts — right in your tab.
Spreadsheet Data Editor
Edit rows inline with AG Grid. Paste from Excel, bulk update, sort and filter millions of rows with virtual scrolling and undo history.
Visual Schema Explorer
Browse tables, columns, indexes and foreign keys. Render your entire schema as an interactive ER diagram, then jump to any table in one click.
Dashboards & BI Reports
Turn any query into a chart with ECharts. Drag-and-drop dashboards on a responsive grid. Schedule reports to email, Slack, or PDF.
Teams & Granular Permissions
Invite teammates by email. Assign per-connection roles — read, write, schema, export — and audit who ran what, when.
Zero-Trust Credentials
Every connection string is sealed with AES-256-GCM before storage. JWT sessions, refresh tokens, Google OAuth2, and short-lived in-memory decryption.
Export Everywhere
One click to CSV, Excel (.xlsx) or PDF. Streamed exports handle multi-gigabyte result sets without crashing the tab.
Live Query Streaming
Results stream over WebSockets as the database produces them. Cancel long-running queries safely — no zombie connections left behind.
Saved Queries & History
Star, tag and share queries across your team. Every execution is logged with parameters, timing and rows returned.
Scheduled Reports
Run a query on a cron schedule, render it to CSV, Excel or PDF, and deliver it by email — powered by BullMQ + Redis.
AI Chat
Talk to your database in plain English
DB AI Magic reads your schema, picks the right tables, writes the SQL, runs it, and visualizes the answer. If the query fails it automatically retries up to five times with the error message — you only ever see a working result.
- Schema-aware prompts — no manual table hints
- Auto-retry on errors up to 5 attempts
- Charts and tables rendered automatically
- Bring your own provider key — encrypted with AES-256-GCM
OpenAI
- · GPT-5
- · GPT-4.1
- · o4-mini
Anthropic
- · Claude Opus 4.7
- · Claude Sonnet 4.6
- · Claude Haiku 4.5
Google Gemini
- · Gemini 2.5 Pro
- · Gemini 2.5 Flash
I'll group orders by country over the last 90 days and sum the cent amounts:
Universal
Built for every database you touch
Ten engines are production-ready today, with stub adapters in place for ten more on the public roadmap.
Ready to use
PostgreSQL
Ready
MySQL
Ready
Microsoft SQL Server
Ready
SQLite
Ready
MongoDB
Ready
On the roadmap
MariaDB
Coming soon
Azure SQL
Coming soon
CockroachDB
Coming soon
Amazon Redshift
Coming soon
Greenplum
Coming soon
Oracle
Coming soon
Snowflake
Coming soon
BigQuery
Coming soon
ClickHouse
Coming soon
DynamoDB
Coming soon
Cassandra
Coming soon
Redis
Coming soon
Elasticsearch
Coming soon
IBM Db2
Coming soon
Couchbase
Coming soon
How it works
From connection string to live dashboard in minutes
No drivers, no DBA ticket, no Docker compose file. Sign in, connect, explore.
- 01
Connect in seconds
Pick an engine, paste a connection string or fill the form. We test it on the spot and encrypt the credentials with AES-256-GCM before anything is stored.
- 10+ supported engines
- Live connection test
- Encrypted-at-rest credentials
- 02
Explore with AI
Browse the schema visually or talk to your data in plain English. The AI reads your tables, writes the SQL, executes it, and shows the answer — retrying on errors automatically.
- Plain-English to SQL
- Auto-retry on failures
- Charts generated on the fly
- 03
Build & Share
Save queries, compose dashboards on a drag-and-drop grid, invite teammates with scoped permissions, and export anything as CSV, Excel or PDF.
- Drag-and-drop dashboards
- Role-based permissions
- Scheduled email reports
Security
Your credentials are never the weak link
DB AI Magic was built with database secrets as the threat model. Every piece of sensitive data is encrypted, scoped, and audited.
AES-256-GCM at rest
Every connection string is encrypted with authenticated AES-256-GCM before it hits the database. Keys never leave the server.
JWT + refresh tokens
Short-lived access tokens with rotating refresh tokens. HTTP-only cookies, signed and verified on every request.
Granular RBAC
Per-connection permissions (read, write, schema, export) with a per-action audit log. Revoke instantly.
Google OAuth2
One-click sign-in via Google with intent capture, so we never silently link existing accounts.
In-memory decryption
Decrypted credentials live only inside a request scope. Pools auto-evict; nothing is logged or echoed.
Rate-limited APIs
All endpoints are rate-limited at the edge with sane defaults — easy to harden further per-tenant.
Pricing
Free for one, fair for a whole team
Bring your own AI key, keep your own data. Upgrade when you invite your first teammate.
Pricing coming soon
Plans haven't been published yet — check back shortly.
FAQ
Common questions
Everything you might want to know before connecting your first database.
No. DB AI Magic runs entirely in your browser. Sign in, paste a connection string, and you are querying in seconds. There is nothing to download or update — and no native drivers to chase down.
No credit card · no install
Connect your first database in the next minute.
Sign up free, paste a connection string, and run your first AI query before your coffee gets cold.