Guide: Connecting PostgreSQL to Cursor and Claude Desktop
The PostgreSQL MCP server is used to: Secure access to PostgreSQL databases. Allows AI to inspect schemas, execute SQL queries, and retrieve data safely. Instead of manually writing configuration files, use the generator on the right.
AI Skills (Prompt Recipes)
Copy these prompts and send them to Claude/Cursor after connecting the tool to activate the skills:
Data Anomaly Analysis
Inspect the schema of the transactions table, write an SQL query to find transactions with amounts above average, and list the top 5 suspicious records.
Weekly Report Generation
Every Monday, generate a report showing new user signups for the previous week grouped by country.
Common Troubleshooting Issues:
- Missing commas in
claude_desktop_config.json, which crashes the entire client. - Incorrect slash escaping in Windows paths (use
\\\\instead of\\). - Incorrect arguments syntax in the JSON array.
Fill in the fields below to generate the JSON config, CLI command, or schema for AI agents.
claude_desktop_config.json
Terminal / Console
Tool JSON Schema for OpenAI/CrewAI
LangChain Python Tool