Postgres
Answers from your app’s Postgres database, or its read replica.
Every answer comes with the SQL Dot ran against your database.
Daniel Weber9:41 AM
@Dot What share of our new workspaces invite a teammate in their first week, by signup month?
1 reply
Dot9:42 AM
34% in September, up 7 points since June.
Sources: Postgres’ workspaces and invites.
Today
Daniel Weber9:41 AM
Dot What share of our new workspaces invite a teammate in their first week, by signup month?
Dot9:42 AM
34% in September, up 7 points since June.
Sources: Postgres’ workspaces and invites.
Lisa Park9:41 AM
@Dot How many of our orders have been stuck in ‘pending payment’ for more than a day?
1 reply
Dot9:42 AM
57 orders worth $9,300. The oldest has waited three days.
Sources: Postgres’ orders and payments.
Here is the data.
| Order | Amount | Waiting |
|---|---|---|
| #48213 | $420 | 3 days |
| #48377 | $185 | 2 days |
| #48402 | $96 | 2 days |
Today
Lisa Park9:41 AM
Dot How many of our orders have been stuck in ‘pending payment’ for more than a day?
Dot9:42 AM
57 orders worth $9,300. The oldest has waited three days.
Sources: Postgres’ orders and payments.
- #48213: $420 amount, 3 days waiting
- #48377: $185 amount, 2 days waiting
- #48402: $96 amount, 2 days waiting
David Mensah9:41 AM
@Dot I need upgrade leads: which free accounts had more than 10 active users this month?
1 reply
Dot9:42 AM
31 accounts, with 870 active users between them.
Sources: Postgres’ accounts and sessions.
Here is the data.
| Account | Active users |
|---|---|
| Lumen | 64 |
| Corvid | 52 |
| Halden | 41 |
Today
David Mensah9:41 AM
Dot I need upgrade leads: which free accounts had more than 10 active users this month?
Dot9:42 AM
31 accounts, with 870 active users between them.
Sources: Postgres’ accounts and sessions.
- Lumen: 64 active users
- Corvid: 52 active users
- Halden: 41 active users
How GetDot works with Postgres
What Dot reads
Dot reads tables, views, materialized views, partitioned and foreign tables, and their foreign keys, which tell it how tables join without anyone drawing the relationships. Each query starts with a comment naming the Dot user and chat, so you can trace it in pg_stat_activity or your logs.
Permissions and row-level security
For any table Dot’s read-only user can’t SELECT, the sync log gives you the exact GRANT statements to run.
Postgres applies its grants and row security policies to the role Dot signs in as. For per-person rows, Dot’s row-level rules (Team plan) filter each query by the asker’s groups or attributes.
Dot and Postgres MCP servers
Postgres has no built-in AI analyst. The usual route is an open-source MCP server on a read-only role, such as pgEdge’s, which turns plain-English questions into SQL and runs them in read-only transactions.
That is great for a developer poking at their own database from Claude or Cursor. A team needs more around it: shared definitions, Slack, Teams and email, scheduled reports, per-person row rules and a stamp naming who asked on every query. That is Dot, and its own MCP server lets you keep your assistant.
Questions
More in Databases & spreadsheets
Connect your data.
Start for Free
Redshift
AWS Athena
Databricks SQL
Microsoft SQL
MotherDuck