Postgres

Answers from your app’s Postgres database, or its read replica.

Every answer comes with the SQL Dot ran against your database.

Threadanalytics

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.

Threadanalytics

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.

OrderAmountWaiting
#48213$4203 days
#48377$1852 days
#48402$962 days

Threadanalytics

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.

AccountActive users
Lumen64
Corvid52
Halden41

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

Connect your data.

Start for Free