PostgreSQL MCP Server
Query databases, read schemas, execute safe SQL, and fetch data. Analyze database structure and answer questions about data.
- Maintained by
- Community (Crystal DBA)
- Hosting
- Runs locally on your machine
- Authentication
- API key or credentials (environment variables)
- Last checked
The MCP reference Postgres server was archived (moved to modelcontextprotocol/servers-archived); this is Postgres MCP Pro, use --access-mode=unrestricted to allow writes.
How to connect the PostgreSQL MCP server
Pick your AI client and paste the snippet. New to this? Our guide to how MCP clients and servers fit together explains what each piece does.
Claude Code
claude mcp add --env DATABASE_URI=postgresql://USER:PASSWORD@HOST:5432/DBNAME --transport stdio postgresql \
-- uvx postgres-mcp --access-mode=restrictedClaude Desktop
{
"mcpServers": {
"postgresql": {
"command": "uvx",
"args": [
"postgres-mcp",
"--access-mode=restricted"
],
"env": {
"DATABASE_URI": "postgresql://USER:PASSWORD@HOST:5432/DBNAME"
}
}
}
}Fully quit and reopen Claude Desktop after saving.
Full Claude Desktop setup guide →Cursor
{
"mcpServers": {
"postgresql": {
"command": "uvx",
"args": [
"postgres-mcp",
"--access-mode=restricted"
],
"env": {
"DATABASE_URI": "postgresql://USER:PASSWORD@HOST:5432/DBNAME"
}
}
}
}VS Code
{
"servers": {
"postgresql": {
"type": "stdio",
"command": "uvx",
"args": [
"postgres-mcp",
"--access-mode=restricted"
],
"env": {
"DATABASE_URI": "postgresql://USER:PASSWORD@HOST:5432/DBNAME"
}
}
}
}Frequently asked questions
What is the PostgreSQL MCP server?
It is a Model Context Protocol (MCP) server — a small piece of software that gives AI assistants like Claude a secure, governed connection to PostgreSQL. Query databases, read schemas, execute safe SQL, and fetch data. Analyze database structure and answer questions about data.
Is there an official PostgreSQL MCP server?
Not from PostgreSQL itself. This one is community-maintained (Crystal DBA). It is widely used, but review the repository and pin a version before relying on it in production.
Is the PostgreSQL MCP server hosted, or do I run it myself?
It runs locally. Your AI client starts it on your own machine with uvx, and it talks to the client over standard input and output rather than the network.
Do I need an API key for the PostgreSQL MCP server?
Yes. The local server reads DATABASE_URI from its environment, so you create that credential first and add it to your client's config.
What can an AI assistant actually do with PostgreSQL?
Through this server an assistant can work with query, schema inspection, analytics — reading from and acting on PostgreSQL directly instead of you copy-pasting between windows. What you allow it to do is controlled by the permissions you grant.
How do I set this up for my business?
The setup section above has copy-paste config for Claude Code, Claude Desktop, Cursor and VS Code. If you want it rolled out across a team with permissions, governance and support handled, that is what Crox's Build engagement covers.
New to MCP? Start with our plain-English guide to the Model Context Protocol or see how to connect AI to your business tools without writing code .
Want this connected to your business — with governance handled?
Crox maps your processes, connects AI to the tools you already use, and keeps it working as models change. Start with a readiness assessment or talk to us about a build.