Skip to content

PostgreSQL

Connect PostgreSQL to Inconvo.

  • Allow 52.17.120.25 to reach your PostgreSQL port (default 5432).
  • A read-only role with SELECT on the schemas you want the agent to see.
  • Ability to read information_schema so we can sync tables/columns.
  • 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=require and any other connection parameters you need. We append these to the connection string.

Example:

postgresql://USER:PASSWORD@HOST:5432/DBNAME?sslmode=require
  • 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_path limited to the schemas you intend to expose.