Connecting a relational database to an AI agent used to mean writing custom API layers or pasting query results into chat manually. With MCP, you add a JSON config block, and Claude can query your PostgreSQL database directly in a conversation.
This guide covers the exact steps to wire up PostgreSQL to Claude Desktop or Cursor, explains the config in detail, and compares your options across the 227 database servers indexed on MCPFind.
What Is an MCP Server for PostgreSQL?
A PostgreSQL MCP server is a small process that sits between your AI client and your database. It translates natural language tool calls from Claude into SQL queries, executes them against your Postgres instance, and returns the results back to the conversation.
The server runs locally on your machine using the MCP stdio transport. Claude does not connect to your database directly. The flow is: Claude issues a tool call, the MCP server receives it, the server runs the query, and the result comes back as a tool response. Your database credentials never leave your machine.
Most PostgreSQL MCP servers expose a standard set of tools: query, list_tables, describe_table, and sometimes execute for write operations. Some add schema introspection and explain-plan analysis.
How to Connect Postgres with MCP: Install and Configure
The most widely used option is @modelcontextprotocol/server-postgres, available on npm. You don't need to install anything globally. The npx -y flag in the config below downloads the package automatically on first run.
Add the server to your Claude Desktop config at ~/Library/Application Support/Claude/claude_desktop_config.json:
{
"mcpServers": {
"postgres": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-postgres",
"postgresql://YOUR_USER:YOUR_PASSWORD@localhost:5432/YOUR_DB"
]
}
}
}Replace YOUR_USER, YOUR_PASSWORD, and YOUR_DB with your actual credentials. For a cloud database, replace localhost:5432 with your host and port. Restart Claude Desktop after saving, and you should see the database tools appear in the tool list.
For Cursor, add the same block to .cursor/mcp.json in your project root.
How Does PostgreSQL Compare to Other Database MCP Options?
PostgreSQL is the most commonly configured relational database in MCP setups, but it is not always the right choice. The databases category on MCPFind indexes 227 servers covering everything from SQLite to distributed NoSQL stores.
Supabase is the most starred database server in the entire directory at 2,556 GitHub stars. It wraps PostgreSQL with an API layer and managed auth, which makes setup faster if you are already using Supabase in production.
SQLite is the right choice for local development. The database is a single file, there is no server process to manage, and several MCP servers support it with zero configuration beyond the file path. For prototyping an agent workflow without a production database, SQLite is the fastest path.
MySQL is a solid alternative for teams on existing MySQL infrastructure. The MCP server ecosystem covers it, though the PostgreSQL tooling tends to be more mature and actively maintained.
MongoDB and Redis have their own dedicated servers for document and key-value use cases. If your data model does not fit relational tables, check the databases category for the right fit before defaulting to Postgres.
What Can Claude Do Once Connected to PostgreSQL?
Once connected, Claude can run queries, inspect schemas, and reason over your data as part of a conversation. You do not write SQL manually.
Ask "which customers signed up last week and have not placed an order" and Claude will construct the join, execute it, and summarize the results. Ask "describe the users table" and Claude will return columns, types, and constraints. For write-enabled setups, Claude can insert or update records when you approve the action.
The practical limit is query complexity. Claude is good at straightforward SELECT and JOIN queries against schemas it has inspected. For multi-step migrations or complex aggregations, it helps to provide the schema upfront by asking Claude to run list_tables first so it has context before you ask the substantive question.
This is a step up from pasting data into chat manually. If your data lives in a tool like Notion rather than a database, see our guide on connecting Notion to AI agents. If you are new to MCP and want to understand the full protocol before configuring your first server, read what is MCP first. For Cursor-specific setup, see how to use MCP with Cursor. If you want to go further and write your own MCP server for a custom database schema, building your first MCP server in Python walks through the full process.
Gus Marquez