sw-postgres-mcp

Connect Runs on your machine

claude mcp add sw-postgres-mcp -e DATABASE_URL_READONLY=<DATABASE_URL_READONLY> -e DATABASE_URL_WRITER=<DATABASE_URL_WRITER> -- npx -y [email protected]

{
  "mcpServers": {
    "sw-postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "DATABASE_URL_READONLY": "<DATABASE_URL_READONLY>",
        "DATABASE_URL_WRITER": "<DATABASE_URL_WRITER>"
      }
    }
  }
}

{
  "mcpServers": {
    "sw-postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "DATABASE_URL_READONLY": "<DATABASE_URL_READONLY>",
        "DATABASE_URL_WRITER": "<DATABASE_URL_WRITER>"
      }
    }
  }
}

{
  "servers": {
    "sw-postgres-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "DATABASE_URL_READONLY": "<DATABASE_URL_READONLY>",
        "DATABASE_URL_WRITER": "<DATABASE_URL_WRITER>"
      }
    }
  }
}

Replace the values in angle brackets with your own. Keys stay on your machine; we never see them.

Tools

This server runs locally, so its tools are listed by your MCP client once it starts.

Environment variables

Details

More databases servers See all

• VibeScale

  Pre-launch checks for AI-built apps: leaked keys, Supabase RLS gaps, browser-exposed env vars.

• Imf Mcp Server

  Query IMF SDMX 3.0 macroeconomic dataflows — WEO, BOP, CPI, exchange rates, 190 countries.

• Apex DB

  Vehicle specifications, emissions, and powertrain data with source provenance.

• TrialBase DB

  Clinical trials across multiple registries with identifiers and source links.

• PatchLabs

  Security checks for AI-built apps (Lovable, Supabase, Bolt): RLS, headers, monitoring, fixes.

• Tidy Byte Tools API

  Remote MCP for JSON repair, hashing, formatting, IDs, dates, units, and other small tools.