PostgreSQL

Official

modelcontextprotocol

Read-only database access with schema inspection

Features

postgresqlsqlschema

Category

Databases

Quick Install

npx -y @modelcontextprotocol/server-postgres

Configuration

Config file location:

~/Library/Application Support/Claude/claude_desktop_config.json
config.json
{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-postgres"
      ]
    }
  }
}

Step 1: Copy the configuration above

Step 2: Open or create the config file at the path shown above

Step 3: Merge with existing config (add to mcpServers object) or replace if new

Step 4: Restart your Claude Desktop application

Details

Author
modelcontextprotocol
Type
Official
Category
Databases