PostgreSQL (read-only)

The same safe, look-only SQL helper, but for PostgreSQL databases. Several of our connectors mirror history into a database, so this is the careful way to query that kind of source directly — reads only, never writes.

Claude Code only

How to use it

With a connection configured in a credentials file you control, ask in plain English and Claude writes the SELECT, auto-selecting the right database, and refuses any write or destructive command. Claude Code only: it connects to a live Postgres from your machine. You create the credentials file; keep passwords out of chat.

How to invoke / keep it on

Ask to query / explore a PostgreSQL database in Claude Code and it loads, picking the database from your saved connection descriptions.

20 powerful examples for Melinda Maria

Copy, tweak, make them yours. Just describe the task — Claude loads the skill automatically.

01"Connect to our reporting Postgres and list the tables, then explain what each one looks like it holds."

02"Run a read-only query to total LoudCrowd-attributed revenue by creator for last quarter and rank them."

03"Compare a figure the dashboard shows against the underlying Postgres table with a SELECT, so I trust the number."

04"Write a safe analytics query for month-over-month order growth and confirm it’s impossible for it to modify the database."

05"Explore the shipbob order-mirror table in Postgres and tell me the date range it actually covers."

06"Pull the top creators by attributed orders from the influencer-mirror table, read-only, as a ranked list."

07"Write a query for total units shipped per month from the mirror and flag the busiest month."

08"Show me how complete the history mirror is — earliest and latest order dates and any gaps."

09"Cross-check the ShopMy connector’s summary number against its source table in Postgres with a SELECT."

10"Write a read-only query for average days-to-ship over the last 90 days."

11"List the columns of the orders mirror so I know what fields I can analyze."

12"Pull revenue by sales channel (DTC vs wholesale) from the mirrored data and confirm it’s read-only."

13"Find the SKUs with the fastest sell-through last month straight from Postgres."

14"Write a query for new-customer count per week and explain how you identified first-time buyers."

15"Check for duplicate order rows in the mirror that might be inflating a total, read-only."

16"Show me a creator leaderboard joining order counts to revenue, ranked."

17"Pull a cohort retention slice (how many month-1 buyers came back in month-2), safely."

18"Compare two quarters of revenue side by side from the mirror in one table."

19"Help me export a Postgres query result to CSV to hand to the finance team."

20"Verify a number that looked off in a connector by querying the underlying Postgres table directly and reporting the discrepancy."

← Back to Databases