Skip to content
MCP server

Postgres MCP

PostgreSQL MCP wrapper with .env credential mapping, tool selection, and safe read-only…

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

About Postgres MCP

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

PostgreSQL MCP wrapper with .env credential mapping, tool selection, and safe read-only defaults.

Install

Run in a terminal

claude mcp add postgres-mcp -- npx -y @edelciomolina/postgres-mcp

Add to claude_desktop_config.json

{
  "mcpServers": {
    "postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@edelciomolina/postgres-mcp"
      ]
    }
  }
}
Install in CursorOpens Cursor, which asks you to confirm. Or add it by hand:

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@edelciomolina/postgres-mcp"
      ]
    }
  }
}
Install in VS CodeOpens VS Code, which asks you to confirm. Or add it by hand:

Add to .vscode/mcp.json

{
  "servers": {
    "postgres-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@edelciomolina/postgres-mcp"
      ]
    }
  }
}

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

{
  "mcpServers": {
    "postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@edelciomolina/postgres-mcp"
      ]
    }
  }
}

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

{
  "mcpServers": {
    "postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@edelciomolina/postgres-mcp"
      ]
    }
  }
}

Configuration

  • MCP_KEY_HOSTName of the .env variable that holds the database host
  • MCP_KEY_PORTName of the .env variable that holds the database port
  • MCP_KEY_NAMEName of the .env variable that holds the database name
  • MCP_KEY_USERName of the .env variable that holds the database user
  • MCP_KEY_PASSName of the .env variable that holds the database password
  • MCP_KEY_SSLMODEName of the .env variable that holds the SSL mode (e.g. require)

Pricing

Open source

Postgres MCP FAQ

Is Postgres MCP free?

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

How do I add Postgres MCP to Claude Code?

Run this command in your terminal: claude mcp add postgres-mcp -- npx -y @edelciomolina/postgres-mcp

What are the best alternatives to Postgres MCP?

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

Alternatives to Postgres MCP

  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