Back to integrations
Postgres
Open-source relational database management system
Warehouse
How nao works with Postgres
nao connects directly to your PostgreSQL database and reads the full schema on every sync, so the analytics agent stays aligned with your tables and columns as they change. If you build transformations with dbt on Postgres, nao ingests your manifest automatically and turns model documentation, lineage, and metric definitions into agent context.
Queries run against your own Postgres instance using your credentials, so no raw data leaves your environment. Business users ask questions in plain English from the nao Chat UI, Slack, or Teams, and nao generates the SQL, runs it, and returns the answer with the query and sources shown.
What you can do with nao and Postgres
- Let non-technical teammates query a Postgres database in plain English instead of filing data requests
- Connect a production or analytics Postgres instance and keep agent context in sync on every schema change
- Import dbt-on-Postgres documentation and lineage as agent context automatically
- Run queries locally against your own Postgres credentials with full SQL transparency on every answer
