PostgreSQL MCP Guide

Name: PostgreSQL MCP
Author: Anthropic

Execute SQL queries, manage schemas, inspect tables, and interact with PostgreSQL databases. Supports parameterized queries and transactions.

891 stars 34,200 downloadsby Anthropic

Quick Start

Install

npx @mcp/postgresql

Claude Desktop Configuration

Add this to your claude_desktop_config.json:

{
  "mcpServers": {
    "postgresql-mcp": {
      "command": "npx",
      "args": [
        "@mcp/postgresql"
      ]
    }
  }
}

execute_query

Run SQL queries against the database

inspect_schema

View table schemas and relationships

manage_tables

Create and alter tables

PostgreSQL MCP requires the following permissions. Review the risk levels before granting access.