PostgreSQL MCP Server

DatabaseIntermediateTransport: stdio

The PostgreSQL MCP Server provides Claude Code with direct access to your PostgreSQL databases. It supports schema introspection, table listing, and SQL query execution in a controlled environment. By default, queries run in read-only mode to prevent accidental data modification. The server automatically discovers database structure, making it easy to explore unfamiliar schemas, generate reports, and debug data issues without switching tools.

postgresqldatabaseSQLschemaquery

Installation

claude mcp add postgres -- npx -y @modelcontextprotocol/server-postgres postgresql://localhost:5432/mydb

Configuration Example

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-postgres",
        "postgresql://user:password@localhost:5432/mydb"
      ]
    }
  }
}

Capabilities

Run queries

List tables

Describe schema

Insert/Update data

Create tables

Drop tables

Manage users

Backup/Restore

Terminal Preview

PostgreSQL MCP Server

About PostgreSQL MCP Server

MCP (Model Context Protocol) servers connect Claude Code to external tools, APIs, and data sources. PostgreSQL MCP Server is a Database MCP server for Intermediate-level users that enables Claude to interact with real-world services, giving it access to live data and the ability to perform actions beyond its built-in capabilities.

Related Servers

SQLite MCP Server

Query and manage SQLite databases from Claude Code with full SQL support and schema exploration.