For PostgreSQL

AI analytics for Postgres

Last updated

Short answer

exelens connects to PostgreSQL, including RDS, Aurora, Supabase and self-hosted servers, with a read-only user over SSL. Every query runs in a read-only transaction against the views you import, and answers use an AI model on your own key.

How exelens connects to PostgreSQL
Detailexelens on PostgreSQL
Works withAmazon RDS, Aurora, Supabase and self-hosted PostgreSQL
Sign-inA database user and password, over SSL (sslmode require by default)
What exelens can readSELECT on the views you import. Use a dedicated read-only user
SafetyEach session sets default_transaction_read_only and a statement timeout
Best practicePoint exelens at a read replica so analysis never touches your primary
Where the data livesIn Postgres. Rows are loaded temporarily only while a question is answered

How it works on Postgres

  1. Create a read-only role. The setup script in Data → Connect creates one and grants SELECT on the views you choose.
  2. Allow exelens to connect. Add the exelens egress addresses to your security group or pg_hba.conf.
  3. Enter host, port, database and credentials. Press Test connection. exelens warns if the user has INSERT, UPDATE, DELETE or TRUNCATE anywhere.
  4. Import views and ask.

When Postgres is your warehouse

Many startups run analytics straight on Postgres or a replica long before they adopt a cloud warehouse. exelens works fine there, and nothing changes when you move to Snowflake or Redshift later: you add the new connection and keep your boards.

Book a demo to try it on a replica.

Frequently asked questions

Can I use my production database?
You can, but a read replica is better. The connection is read-only either way, yet a replica keeps analytical queries away from your application's traffic.
Does exelens need superuser rights?
No. A user with CONNECT and SELECT on the views is enough, and exelens warns if the user can write.
Is SSL required?
SSL is on by default. You can change the mode for a local test database, but do not do so over the internet.

See exelens on your PostgreSQL

A short walkthrough with the founder: connect read-only, ask a real question, pin the answer.