Postgres MCP

A lightweight MCP (Model Context Protocol) server built to query Postgres database using SQL or plain English commands. It provides comprehensive tools for database operations, table introspection, and query execution with smart permission handling.

Features

Smart Query Permission Handling

• Read-only queries: Automatically approved (SELECT, EXPLAIN, SHOW, VALUES)
• Read-write queries: User confirmation required (INSERT, UPDATE, DELETE, MERGE)
• Admin/DDL queries: Elevated permission required (CREATE, ALTER, DROP, etc.)
• Dry-run mode: Validate queries without execution

Comprehensive Table Introspection

• Column definitions with types and constraints
• Primary and foreign key relationships
• Index definitions
• Triggers and check constraints

Database Management

• Multiple database switching capability
• Robust error handling and rollback

Available Tools

Minimum needed environment variables

1. POSTGRES_HOST
2. POSTGRES_USER
3. POSTGRES_PASSWORD
4. POSTGRES_DATABASE

Other environment variables

1. POSTGRES_PORT
2. POSTGRES_SSL (boolean)
3. POSTGRES_VERIFY (boolean)
4. POSTGRES_SEND_RECEIVE_TIMEOUT (in seconds)
5. POSTGRES_CONNECT_TIMEOUT (in seconds)

Configuring using mcpServers json

For Mac and Linux

{
  "mcpServers": {
    "postgres-mcp": {
      "command": "npx",
      "args": ["-y", "@freakynit/postgres-mcp@latest"],
      "env": {
        "POSTGRES_HOST": "<POSTGRES HOST>",
        "POSTGRES_USER": "<POSTGRES USER>",
        "POSTGRES_PASSWORD": "<POSTGRES PASSWORD>",
        "POSTGRES_DATABASE": "<POSTGRES DATABASE>"
      }
    }
  }
}

For Windows

{
  "mcpServers": {
    "postgres-mcp": {
      "command": "cmd",
      "args": ["/k", "npx", "-y", "@freakynit/postgres-mcp@latest"],
      "env": {
        "POSTGRES_HOST": "<POSTGRES HOST>",
        "POSTGRES_USER": "<POSTGRES USER>",
        "POSTGRES_PASSWORD": "<POSTGRES PASSWORD>",
        "POSTGRES_DATABASE": "<POSTGRES DATABASE>"
      }
    }
  }
}