Dory PostgreSQL Database Support
Dory supports PostgreSQL databases for operational analytics, internal tools, product analysis, and day-to-day data investigation. After connecting PostgreSQL, you can browse schema, write SQL, inspect results, build charts, and ask AI to generate or explain queries with real database context.
Best-Fit Use Cases
- Query operational application data.
- Analyze users, orders, payments, logs, or product events.
- Explore unfamiliar schemas quickly.
- Generate first-draft SQL with AI and refine it manually.
- Save reusable troubleshooting and metric queries.
Supported Capabilities
| Capability | PostgreSQL support |
|---|---|
| Connections | Host, port, database, username, password, SSL, and SSH tunnel. |
| Explorer | Schemas, tables, views, columns, constraints, and DDL. |
| SQL Console | PostgreSQL SQL editing, execution, results, and tabs. |
| AI Chat | Schema-grounded SQL generation, Join explanation, and optimization help. |
| Charts & Results | Turn aggregated query results into charts or detail tables. |
| Saved Queries | Save and organize reusable PostgreSQL SQL. |
Connection Requirements
Prepare the host, port, database, username, password, SSL setting, and SSH tunnel details if the database is private. Production environments should use readonly roles whenever possible.
Schema Tips
PostgreSQL projects often use multiple schemas such as public, analytics, and internal. Confirm the target schema in Explorer before writing queries or asking AI to generate SQL.
Performance and Security Advice
- Use read-only roles for production analysis.
- Filter by time range before scanning large tables.
- Review joins and aggregations before running AI-generated SQL.
- Confirm the active schema when table names are ambiguous.
FAQ
Why can I connect but not see tables?
The current user may lack USAGE permission on the schema or SELECT permission on the target tables.
Why does AI-generated PostgreSQL SQL reference missing columns?
Open Explorer and provide the exact table and column names in the prompt. Ask AI to rewrite the query using only visible columns.
Does Dory support Neon?
Yes. Neon uses Dory's PostgreSQL-compatible capabilities. See Neon.
Related Docs
Dory ClickHouse Database Support
Learn how to connect ClickHouse to Dory, run SQL, browse schema, generate queries with AI, and use monitoring and privilege management.
Dory Neon Database Support
Connect Neon Serverless PostgreSQL to Dory, query cloud Postgres data, browse schema, and generate SQL with AI.