@themarch/mcp-postgres-local

MCP server exposing read-only access to a local Postgres database.

Tools

• query(sql, params?) — run a SELECT
• tables() — list public tables
• describe(table) — column types
• count(table, where?) — row count

Env

• DATABASE_URL (required)
• MCP_PG_READONLY=1 (default; set to 0 to allow writes — at your own risk)

Wire it up

// .cursor/mcp.json or ~/.claude/settings.json
{
  "mcpServers": {
    "postgres-local": {
      "command": "node",
      "args": ["./node_modules/@themarch/mcp-postgres-local/dist/index.js"],
      "env": { "DATABASE_URL": "${env:DATABASE_URL}", "MCP_PG_READONLY": "1" }
    }
  }
}