Database Support
Dory Supported Databases
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. |
| 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.
Quick Answer
Dory supports ClickHouse, PostgreSQL, Neon, MySQL, MariaDB, SQLite, DuckDB, and MotherDuck. It can be used as an AI SQL client, database explorer, query result analysis tool, and ClickHouse operations assistant.