PostgreSQL

Connect PostgreSQL to access relational databases, tables, and query data through Cendriix agents.

Overview

How to connect

1. Navigate to Settings → Integrations → Connectors
2. Click Connect on the PostgreSQL integration
3. Enter your connection credentials
4. Once configured, database data becomes available

Getting your credentials

1. Provide your PostgreSQL connection string: postgresql://user:pass@host:5432/dbname
2. For security, use a dedicated read-only database user

Capabilities

Once connected, Cendriix agents can:

• Run read-only queries against PostgreSQL databases
• Access table schemas and indexes
• Reference database structure for migration planning

Security notes

• Always use a dedicated read-only user for Cendriix access
• Connection credentials are stored encrypted in AWS Secrets Manager
• Ensure network access (VPC peering or IP allowlist) is configured
• Disconnect at any time from Settings → Integrations → Connectors

Further reading

• PostgreSQL Documentation