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.
| Detail | exelens on PostgreSQL |
|---|---|
| Works with | Amazon RDS, Aurora, Supabase and self-hosted PostgreSQL |
| Sign-in | A database user and password, over SSL (sslmode require by default) |
| What exelens can read | SELECT on the views you import. Use a dedicated read-only user |
| Safety | Each session sets default_transaction_read_only and a statement timeout |
| Best practice | Point exelens at a read replica so analysis never touches your primary |
| Where the data lives | In Postgres. Rows are loaded temporarily only while a question is answered |
How it works on Postgres
- Create a read-only role. The setup script in Data → Connect creates one and grants
SELECTon the views you choose. - Allow exelens to connect. Add the exelens egress addresses to your security group or
pg_hba.conf. - Enter host, port, database and credentials. Press Test connection. exelens warns if the user has
INSERT,UPDATE,DELETEorTRUNCATEanywhere. - 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.