# PostgreSQL BI and Analytics — Connect to Supaboard

> Ask questions of your PostgreSQL data in plain English and see the SQL behind every answer. 5 things teams ask, and what they combine it with.

HTML version: https://supaboard.ai/integrations/postgresql

Postgres holds the tables your application writes to, so it is usually the first place to look when the question is about what customers actually did.

## What teams ask of PostgreSQL

- "How many accounts signed up last month, and how many of them are still active?"
- "Which customers have not placed an order in the last 90 days?"
- "What share of each month's signups ended up paying, and has that got better or worse?"
- "Which subscriptions renew in the next 30 days, and what are they worth?"
- "What does the spread of orders per customer look like, and who sits in the top 1%?"

## What it is combined with

An agent can hold more than one source: ask a question that spans them and Supaboard queries each one, then combines the results.

- Snowflake — the rows your application wrote today, against the history the warehouse has modelled.
- BigQuery — the accounts your product created, against the GA4 export of the traffic that brought them.

## How the connection works

PostgreSQL is one of the 12 databases and warehouses you can connect yourself. It connects directly and is queried when a question is asked, with nothing copied ahead of time, so setting up a first analysis takes about 5 minutes.

The connection form takes a host, a port, a database and a schema, and it checks what you type against the database as you go: it only offers the databases and schemas that role can actually read, and it will not save a connection pointed at one it cannot reach. If the database is not exposed to the internet, the same form tunnels over SSH. If it is, the screen lists the IP addresses Supaboard connects from, ready to paste into a firewall rule.

- Database and warehouse queries are read-only. Changes to connected apps require your approval.
- Credentials encrypted at rest, scoped per workspace, never logged.
- On-premise deployment on Enterprise. Supaboard receives no platform data; inference follows the model endpoint you configure. https://supaboard.ai/enterprise
- A free plan, then from $19 per editor/month: https://supaboard.ai/pricing

## More

- [Databases](https://supaboard.ai/product/databases)
- [Compared with the major BI platforms](https://supaboard.ai/compare)
- [What an AI data analyst does](https://supaboard.ai/)

---

- Site index for agents: https://supaboard.ai/llms.txt
- Sitemap: https://supaboard.ai/sitemap.xml
- Blog feed: https://supaboard.ai/blog/rss.xml
- Product documentation: https://docs.supaboard.ai

Any page on https://supaboard.ai is available as markdown: append `.md` to its path, or send `Accept: text/markdown`.