Databases
Overview
Dory is an AI-native data workspace for modern databases. You can connect supported databases, browse schema, write SQL, generate queries with AI, inspect results, build charts, and save reusable queries.
Database Support Overview
| Database | Best fit | Dory support |
|---|---|---|
 ClickHouse | Event, log, observability, and high-throughput analytics | SQL, Explorer, AI, Monitoring, and Privileges. |
 PostgreSQL | Operational apps, internal tools, and analytics | Schema browsing, SQL, AI assistance, and result analysis. |
 Neon | Serverless PostgreSQL and cloud development | PostgreSQL-compatible connection support. |
 MySQL | Web application databases and reporting | Querying, AI assistance, and production-safe exploration. |
 MariaDB | MariaDB application databases and reporting | Dedicated connection support for SQL, Explorer, and AI assistance. |
 SQL Server | Enterprise applications, reporting, and operational systems | T-SQL execution, Explorer, AI assistance, and schema-aware workflows. |
 Oracle | Enterprise systems, ERP, finance, and long-running production databases | Oracle SQL execution, object exploration, AI assistance, and schema context. |
 SQLite | Local files, prototypes, demos, and lightweight analysis | Absolute-path local .sqlite / .db file connections. |
 DuckDB | Local analytical files and MotherDuck workflows | Local DuckDB files and MotherDuck tokens. |
 Cloud Databases | Managed databases and team deployments | TLS, allowlists, SSH tunnels, and secret-management guidance. |
Typical Dory Database Workflow
- Create a connection in Connections.
- Browse databases, schemas, tables, and columns in Explorer.
- Write and run SQL in SQL Console.
- Use AI Chat to generate, explain, fix, or optimize queries.
- Validate results and build charts in Charts & Results.
- Save reusable SQL in Saved Queries.
Choose a Connection Method
- Use the desktop app for local development and direct access from your machine.
- Use Docker or self-hosting when a team needs shared access.
- Use file paths for SQLite and DuckDB only when the Dory runtime can read those files.
- Use SSH Tunnel or cloud networking settings when databases are not publicly reachable.
Next Steps
How is this guide?