Skip to content
MCP server

PostgreSQL MCP Server

Python MCP server for PostgreSQL database inspection and querying

Runs locallyStatus and history
Install
Pricing
Open source
Runs
Locally
Version
0.1.2
Listing updated
4 days ago

About PostgreSQL MCP Server

PostgreSQL MCP Server is an open-source MCP server for databases. It runs locally on your machine and is started by your AI client.

Install

Run in a terminal

claude mcp add postgresql-mcp-server --env POSTGRES_HOST='<POSTGRES_HOST>' --env POSTGRES_PORT='<POSTGRES_PORT>' --env POSTGRES_USER='<POSTGRES_USER>' --env POSTGRES_PASSWORD='<POSTGRES_PASSWORD>' --env POSTGRES_DB='<POSTGRES_DB>' -- uvx mdev-postgresql-mcp-server

Add to claude_desktop_config.json

{
  "mcpServers": {
    "postgresql-mcp-server": {
      "command": "uvx",
      "args": [
        "mdev-postgresql-mcp-server"
      ],
      "env": {
        "POSTGRES_HOST": "<POSTGRES_HOST>",
        "POSTGRES_PORT": "<POSTGRES_PORT>",
        "POSTGRES_USER": "<POSTGRES_USER>",
        "POSTGRES_PASSWORD": "<POSTGRES_PASSWORD>",
        "POSTGRES_DB": "<POSTGRES_DB>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "postgresql-mcp-server": {
      "command": "uvx",
      "args": [
        "mdev-postgresql-mcp-server"
      ],
      "env": {
        "POSTGRES_HOST": "<POSTGRES_HOST>",
        "POSTGRES_PORT": "<POSTGRES_PORT>",
        "POSTGRES_USER": "<POSTGRES_USER>",
        "POSTGRES_PASSWORD": "<POSTGRES_PASSWORD>",
        "POSTGRES_DB": "<POSTGRES_DB>"
      }
    }
  }
}

Add to .vscode/mcp.json

{
  "servers": {
    "postgresql-mcp-server": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mdev-postgresql-mcp-server"
      ],
      "env": {
        "POSTGRES_HOST": "<POSTGRES_HOST>",
        "POSTGRES_PORT": "<POSTGRES_PORT>",
        "POSTGRES_USER": "<POSTGRES_USER>",
        "POSTGRES_PASSWORD": "<POSTGRES_PASSWORD>",
        "POSTGRES_DB": "<POSTGRES_DB>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "postgresql-mcp-server": {
      "command": "uvx",
      "args": [
        "mdev-postgresql-mcp-server"
      ],
      "env": {
        "POSTGRES_HOST": "<POSTGRES_HOST>",
        "POSTGRES_PORT": "<POSTGRES_PORT>",
        "POSTGRES_USER": "<POSTGRES_USER>",
        "POSTGRES_PASSWORD": "<POSTGRES_PASSWORD>",
        "POSTGRES_DB": "<POSTGRES_DB>"
      }
    }
  }
}

Add to your client's MCP settings (most use this shape)

{
  "mcpServers": {
    "postgresql-mcp-server": {
      "command": "uvx",
      "args": [
        "mdev-postgresql-mcp-server"
      ],
      "env": {
        "POSTGRES_HOST": "<POSTGRES_HOST>",
        "POSTGRES_PORT": "<POSTGRES_PORT>",
        "POSTGRES_USER": "<POSTGRES_USER>",
        "POSTGRES_PASSWORD": "<POSTGRES_PASSWORD>",
        "POSTGRES_DB": "<POSTGRES_DB>"
      }
    }
  }
}

Configuration

  • POSTGRES_HOSTPostgreSQL hostRequired
  • POSTGRES_PORTPostgreSQL portRequired
  • POSTGRES_USERPostgreSQL usernameRequired
  • POSTGRES_PASSWORDPostgreSQL password
  • POSTGRES_DBPostgreSQL database nameRequired
  • POSTGRES_READ_QUERY_LIMITMaximum rows returned by read queries

Pricing

Open source

PostgreSQL MCP Server FAQ

Is PostgreSQL MCP Server free?

Yes. PostgreSQL MCP Server is open source, so you can use and self-host it for free.

How do I add PostgreSQL MCP Server to Claude Code?

Run this command in your terminal: claude mcp add postgresql-mcp-server --env POSTGRES_HOST='<POSTGRES_HOST>' --env POSTGRES_PORT='<POSTGRES_PORT>' --env POSTGRES_USER='<POSTGRES_USER>' --env POSTGRES_PASSWORD='<POSTGRES_PASSWORD>' --env POSTGRES_DB='<POSTGRES_DB>' -- uvx mdev-postgresql-mcp-server

What are the best alternatives to PostgreSQL MCP Server?

The closest alternatives to PostgreSQL MCP Server are Midplane, PlatypusDB, Lorebase, Sovaria and model2data studio.

Alternatives to PostgreSQL MCP Server

  1. Midplane

    MCP server

    Postgres gateway for AI agents with table grants, column masking and approval for writes

    Runs locally
    • Open source
    • 5 GitHub stars
    • Databases
  2. PlatypusDB

    MCP server

    Gives MCP clients access to your PlatypusDB database connections, scoped per agent

    Runs locally
    • Open source
    • Databases
  3. Lorebase

    MCP server

    Lets agents read and change a governed, versioned Postgres knowledge graph

    Runs locally
    • Open source
    • Knowledge and memory
  4. Sovaria

    MCP server

    Manage a Sovaria backend (Postgres, auth, storage, functions) from an AI assistant

    Not checked yet
    • 4 tools
    • Remote
    • Freemium
    • Databases
  5. Generate realistic connected test data, dbt projects and dashboards from a schema

    • Remote
    • Freemium
    • Databases
  6. semlayer

    MCP server

    Infers a semantic layer from your data warehouse and serves it to agents

    Runs locally
    • Free
    • Databases