Investigate your data
If you ask
“How many orders were placed in the last 24 hours and what's the total revenue?”
Then
Run SELECT queries to answer product or debugging questions.
Works in Claude, Codex, Cursor & any MCP agent
How this prompt works
-
Turn on the PostgreSQL connector in Claude, ChatGPT or Cursor — once.
-
Paste the prompt above. No code, no menus.
-
Run SELECT queries to answer product or debugging questions.
FAQ
How do I investigate your data with PostgreSQL?
Add the PostgreSQL MCP connector once, then paste this prompt into Claude or ChatGPT: "How many orders were placed in the last 24 hours and what's the total revenue?". Your AI runs it in PostgreSQL.
Do I need to code?
No. You install the connector once (a short config or one click), then ask in plain words. The prompt on this page works as-is.
Which AI assistants work?
Claude (Desktop, Code), Cursor, ChatGPT and other MCP clients. The same prompt works across them.
Set up PostgreSQL in Claude
Copy-paste config, setup steps and more ready-to-run prompts on the connector page.
Open PostgreSQL setupMore prompts