cosmic-mcp

All servers

sw-postgres-mcp

io.github.jpka/sw-postgres-mcp ยท version 0.3.1

Community listing. Not installed or verified by cosmic-mcp. Read the source and its permissions before you run it.

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

https://github.com/jpka/sw-postgres-mcp

Quick facts

  • Listing: Community
  • Published Aug 15, 15:24 UTC
  • Transport: stdio
  • Package: npm sw-postgres-mcp 0.3.1
  • Listed by cosmic-mcp: Nov 9, 04:26 UTC

Databases

Setup snippets

Generated from the registry entry. cosmic-mcp has not run or reviewed this server; values in angle brackets are yours to fill in.

Run it locally (npm)

npx -y '[email protected]'

Claude Desktop (claude_desktop_config.json)

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

Claude Code

claude mcp add 'sw-postgres-mcp' -- npx -y '[email protected]'

Cursor (.cursor/mcp.json)

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

VS Code (.vscode/mcp.json)

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

Related servers

  • spotdb Verified domain
    Ephemeral data sandbox for AI workflows with guardrails and security
  • Reasonbook Verified domain
    Reasonbook: decisions that survive the session, in a local record AI agents keep.
  • AI for Database Verified domain
    Ask your databases questions in plain English, run read-only SQL and set up data alerts.
  • AI2SQL Verified domain
    Text-to-SQL MCP server: read-only queries on PostgreSQL, MySQL and SQL Server with your real schema
  • AICasePredict Verified domain
    Search a large legal database of 325M+ US court records: cases, attorneys, judges and courts.
  • APC Security Reference Server
    Reference MCP server for synthetic APC action-security evaluation and local SQLite sandbox testin...