LocalFree

sw-postgres MCP server

jpka/sw-postgres-mcp

Safe-write Postgres MCP server with preview-before-execute writes and rollback safety.

0 GitHub stars136 npm downloads / month
Source code

Install sw-postgres in Claude Code

Claude Code
claude mcp add sw-postgres -e DATABASE_URL_READONLY=... -e DATABASE_URL_WRITER=... -- npx -y sw-postgres-mcp
mcp.json (Claude Desktop, Cursor, VS Code, Windsurf)
{
  "mcpServers": {
    "sw-postgres": {
      "command": "npx",
      "args": [
        "-y",
        "sw-postgres-mcp"
      ],
      "env": {
        "DATABASE_URL_READONLY": "...",
        "DATABASE_URL_WRITER": "..."
      }
    }
  }
}

Replace each ... with your own value.

Frequently asked questions

What does the sw-postgres MCP server do?

Safe-write Postgres MCP server with preview-before-execute writes and rollback safety.

Is the sw-postgres MCP server free?

Yes, most likely. Open source and no paid account or API key is mentioned in the listing. Check the provider for current pricing.

Does sw-postgres run locally or remotely?

Local. Runs on your machine (stdio). You install it with npx, uvx, Docker or from source.

How do I add sw-postgres to Claude Code?

Run: claude mcp add sw-postgres -e DATABASE_URL_READONLY=... -e DATABASE_URL_WRITER=... -- npx -y sw-postgres-mcp

More databases MCP servers

View all

valv

5

valv-dev/valv

Let coding agents query any SQL database safely. Read-only by default and scoped by your policies.

LocalFree

Spreadsheet DB

1128

ManddarinShop/Hikoutei

SQLite-authoritative entity database with an async Google Sheets projection for AI agents.

LocalFree

Igdb

5

bielacki/igdb-mcp-server

Explore and discover video games from the Internet Game Database. Search titles, view detailed inf…

RemoteAccount needed

Showboard

5977

rohanbeingsocial/showboard

Your coding agent answers with dashboards: charts and tables from read-only SQL, Excel and CSV.

LocalFree

PlanetScale

5

planetscale/mcp-server

Connect to PlanetScale databases, branches, schema, query insights, and execute SQL

RemoteAccount needed

Primavera P6

5

nizarhamza/p6-mcp

Primavera P6 MCP server: critical path, DCMA checks, what-if and safe write-back to the P6 database

LocalFree