PostgreSQL
Connect PostgreSQL to Inconvo.
What you’ll need
Section titled “What you’ll need”- Allow 52.17.120.25 to reach your PostgreSQL port (default
5432). - A read-only role with
SELECTon the schemas you want the agent to see. - Ability to read
information_schemaso we can sync tables/columns.
Fill the form
Section titled “Fill the form”- Display name: A friendly label your team will see in Inconvo.
- Host / Port: The Postgres endpoint and port (usually
5432). - Database name: The database the agent should read from.
- Username / Password: Dedicated credentials with least privilege.
- Advanced options → Custom options: Add
sslmode=requireand any other connection parameters you need. We append these to the connection string.
Example:
postgresql://USER:PASSWORD@HOST:5432/DBNAME?sslmode=requireAfter you save
Section titled “After you save”- We spin up your private connector and start syncing the schema; the status will show as Connecting while that runs.
- Point us to a read replica if you want to keep traffic off primaries.
- Keep the role’s
search_pathlimited to the schemas you intend to expose.