For non-developers
What can Claude do with PostgreSQL?
Imagine asking your AI: 'What tables are in my database and how are they related?' or 'Show me the top 10 slowest queries from the last hour' — and it connects directly to your Postgres database. This server lets your AI query and inspect Postgres databases through conversation, without you writing SQL by hand.
★ Hand-picked walkthrough
Set Up PostgreSQL MCP Server with Claude Desktop
Things you can ask Claude
Schema Exploration
Get a natural-language tour of an unfamiliar database.
Say to Claude
Describe the schema of my database — list tables, key columns, and how they relate to each other Data Investigation
Run SELECT queries to answer product or debugging questions.
Say to Claude
How many orders were placed in the last 24 hours and what's the total revenue? Query Drafting
Let AI draft complex queries with joins and CTEs that you can review and run.
Say to Claude
Write a query to find users who signed up in the last 30 days but haven't made a purchase When it helps
- ✓You want to explore an unfamiliar database schema
- ✓You need to run ad-hoc SELECT queries to investigate data or bugs
- ✓You're learning SQL and want AI to draft queries you can review
- ✓You're doing analytics on a read replica and want conversational queries
FAQ
Can Claude use PostgreSQL?
Yes. With the PostgreSQL MCP connector (an MCP server), Claude can work with PostgreSQL directly in your conversation — Official PostgreSQL MCP server — query and inspect Postgres databases with read-only access for safe AI-powered data analysis.
Do I need to code to use PostgreSQL with Claude?
No. You install the connector once (a short config or one command), then you just ask Claude in plain English. The example prompts on this page work as-is.
How do I add PostgreSQL to Claude?
Open the PostgreSQL connector page for copy-paste setup, or follow the per-client guide for Claude Desktop, Claude Code, Cursor, or ChatGPT.
Set up PostgreSQL in Claude
Copy-paste config, setup steps, plus the walkthrough — on the connector page.