PluginBench
MCP Server
Active
MIT

sw-postgres-mcp MCP Server

io.github.jpka/sw-postgres-mcp

RepositoryRegistry
How to choose

What this kind of tool is for

  • Query, inspect, or seed a database without writing a one-off script.
  • Let your agent look up schema details before it writes migration code.
  • Move a small dataset between tools without leaving the terminal.

How to compare servers like this

Engine match:
Confirm it speaks your exact database and version, not just the family.
Access scope:
Read-only connections are the safe default — start there before granting writes.
Safety rails:
Check whether destructive statements need an explicit confirmation before they run.
Maintenance signal:
Database drivers change; a recently updated tool is less likely to break mid-query.

This page carries your copy-paste config: pick your MCP client in the install section on this page and use the copy button.

What is the sw-postgres-mcp MCP server?

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

How to install sw-postgres-mcp

Copy-paste configuration for popular MCP clients.

transport: stdio
Config generated by PluginBench — verify against the source before use.
Environment / auth
  • DATABASE_URL_READONLY
    required
    secret

    Postgres connection string for the read-only role.

  • DATABASE_URL_WRITER
    required
    secret

    Postgres connection string for the writer role.

~/Library/Application Support/Claude/claude_desktop_config.json
JSON config
{
  "mcpServers": {
    "sw-postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "sw-postgres-mcp"
      ],
      "env": {
        "DATABASE_URL_READONLY": "<YOUR_DATABASE_URL_READONLY>",
        "DATABASE_URL_WRITER": "<YOUR_DATABASE_URL_WRITER>"
      }
    }
  }
}

Related MCP servers

Safe-write Shopify operations: plan-before-execute writes with out-of-band approval and audit.

0
TypeScript
MIT
View repository →

Governed MCP seller node: buyer agents discover inventory and register intents; no ad-server writes

0
TypeScript
MIT
View repository →

MCP-first access to your Lunch Money data.

0
Python
MIT
View repository →

Korean market data: kimchi premium, sell-side research, news. Pay per call in USDC via x402.

0
TypeScript
MIT
View repository →

Look up meme template images by name or description, with disambiguation for ambiguous names.

View repository →

Generate covers, Mermaid diagrams, cards, and terminal screenshots/images for AI workflows.

View repository →