> ## Documentation Index > Fetch the complete documentation index at: https://docs.zencoder.ai/llms.txt > Use this file to discover all available pages before exploring further. # PostgreSQL > Connect Zenflow to PostgreSQL to query, inspect, and update databases. This extended integration requires a paid Zencoder account. ## Overview The PostgreSQL integration enables Zenflow agents to query, inspect, and update PostgreSQL databases. Build reports, debug database issues, manage migrations, and synchronize data from within your workflows. ## Connecting PostgreSQL Navigate to **Settings → Integrations** in the Zenflow sidebar. Locate **PostgreSQL** in the Integrations Catalog and click the **Connect** or **\[+]** button.
PostgreSQL Integration Card
A secure popup window will open asking for permission to connect your account. Click **Continue** to proceed.
Pipedream Consent Screen
Provide your database connection string or connection parameters (Host, Port, DB Name, User, Password) in the connection popup.
API Key Connection Screen Example
A progress window will briefly indicate that the account connection is in progress, followed by a confirmation.
Connection in Progress
Once authorized, close the popup. The integration will instantly display as **Connected** in your Zenflow dashboard and is active for your AI agents. Ensure that Zenflow's IP addresses are whitelisted in your database's security group. ## What the Agent Can Do * **Query Database** — Run SQL SELECT, INSERT, UPDATE, and DELETE statements * **Inspect Schema** — List tables, columns, constraints, and indexes * **Optimize Queries** — Analyze query plans (EXPLAIN) and index usage * **Data Export** — Export query results in JSON or CSV format ## Example Use Cases * Inspect and repair corrupted data during debugging sessions * Generate daily operational metrics directly from production tables * Mirror table schemas and setup test databases automatically * Fetch user records to answer specific support inquiries Browse ready-to-use templates in the **[Zencoder Marketplace](https://zencoder.ai/marketplace)**.