community-automations/postgres-conv-agent

Research & Intel

PublicClaude subagent

Postgres Conversation Agent

Most people who need a number from Postgres can't write the query, so they file a ticket and wait. This agent lets them just ask, in chat, and get the answer back.

sonnet3 daysPostgresOpenAILangChainpgBouncer
ClaudeClaude
ROI for
README.md

Why this subagent

Most people who need a number from Postgres can't write the query, so they file a ticket and wait. This agent lets them just ask, in chat, and get the answer back.

Every connection runs through a read-only role, so nothing in the database can change. The agent writes the SELECT, runs it, explains the rows in plain words, and shows the exact SQL underneath so the result is easy to trust.

How it runs

    • Read

      Used at step 01 to kick off the pipeline.

    • Write

      Used at step 01 to kick off the pipeline.

    • WebFetch

      Used at step 01 to kick off the pipeline.

    • WebSearch

      Used at step 01 to kick off the pipeline.

Sample output

json
// Sample output
// (generated when the pipeline finishes)

Answer questions about the Postgres database using read-only SELECT queries and report both the result and the SQL used.

Unlock the rest

The full agent definition, install snippet, and starter task are gated for community members.

Members get the full `.md` agent file, the npm / pnpm install one-liners, a starter prompt that we've tuned against real runs, and the open-source repo when this automation ships there. One email, magic link, done.