New integration: Query PostgreSQL databases directly
You can now connect PostgreSQL databases as an integration. The AI assistant can then access your data directly, run SQL queries and present the results, without you having to write any SQL yourself.
What is possible?
Section titled “What is possible?”Ask questions in natural language, for example:
- “How did our monthly costs develop over the last quarter?”
- “Show me the top 10 customers by revenue”
- “Create a chart of daily user counts”
The assistant automatically detects the available tables and columns, writes the matching SQL query and presents the results as a table or interactive chart.
Security
Section titled “Security”- Read-only: All queries run in a read-only mode, your data cannot be modified
- SSL/TLS: Connections are encrypted automatically
- Credentials: Are stored encrypted and never passed to the AI
We recommend using a dedicated database user with read-only permissions.
How to set it up
Section titled “How to set it up”- Open Settings → Integrations
- Pick PostgreSQL from the available templates
- Enter your PostgreSQL connection string
- The connection test automatically verifies access
Learn more under Integrations & Tools.