Back to MCP Servers
🐘

PostgreSQL MCP Server

by Anthropic

Reference implementation for PostgreSQL. Query databases, inspect schemas, and analyze data.

Reference Implementation
Database
GitHub
Deployment Type
💻Local

Runs on your local machine

Authentication
🔒Credentials

User credentials required

Installation
Medium

Some configuration needed

Use Cases
Common ways to use this MCP server
Data analysis
Schema inspection
Query optimization
Debugging
Ideal For
This server is perfect for these roles and teams
Developers
Data Analysts
DBAs
Installation
Quick start guide for setting up this MCP server

1. Install via npx

npx -y @modelcontextprotocol/server-postgres

2. Add to Claude Desktop config

Edit claude_desktop_config.json

{
  "mcpServers": {
    "postgresql": {
      "command": "npx",
      "args": ["-y", "@modelcontextprotocol/server-postgres"],
      "env": {
        "AUTH_TOKEN": "your-credentials-here"
      }
    }
  }
}

3. Restart Claude Desktop

Close and reopen Claude Desktop to load the new MCP server.

Related MCP Servers
Other servers you might find useful
🎪
Puppeteer MCP Server

Anthropic

Reference implementation for Puppeteer browser automation. Control Chrome/Chromium browsers programmatically.
🔀
Git MCP Server

Anthropic

Reference implementation for Git operations. Read repository status, history, and diffs.
💿
SQLite MCP Server

Anthropic

Reference implementation for SQLite. Query local databases and analyze schemas.
⚡
Supabase MCP Server

Supabase Community

Community Supabase MCP server. Query databases, manage auth, and access storage.
View All MCP Servers
Learn More About Model Context Protocol
Understand how MCP works and how to build your own servers
MCP GuideBrowse All Servers