​
Postgres Credentials

To connect Definite to Postgres, you’ll need:

  • host: url or IP of your postgres instance
  • port: usually 5432
  • database: usually postgres
  • username
  • password

​
Input your credentials in the Definite UI

From the Definite homescreen Settings Integrations Postgres, from there you should see the following screen in which you can input your Postgres credentials:

​
Additional Postgres Setup Steps For Improved NLQ Performance

Definite parses your Postgres query history (just the SQL, not the actual data returned) to improve NLQ performance and give better in-app recommendations. To enable query history tracking:

  • Install in your Postgres instance

    • If your Postgres instance is on AWS RDS, follow these instructions on how to enable it.
    • If your Postgres instance is hosted on Supabase, you can activate the extension directly from the Supabase UI:

    • For most other Postgres instances, run:

      CREATE EXTENSION pg_stat_statements

Finally you will want to grant your Postgres user read access to pg_stat_statements:

GRANT USAGE ON SCHEMA extensions TO <your_user>;
GRANT pg_read_all_stats TO <your_user>;
GRANT SELECT ON pg_stat_statements TO <your_user>;