SERVER

sw-postgres-mcp

Rank #55,941

io.github.jpka/sw-postgres-mcp

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

3 versions

by jpka (2 servers)View repository ↗

First listed

Aug 12, 2026

Last publish date

Aug 15, 2026

PURPOSE

What you can do with sw-postgres-mcp

sw-postgres-mcp is a Model Context Protocol (MCP) server published by jpka. It ranks #55,941 of 144,396 active servers on MCP Toplist. sw-postgres-mcp is listed across 2 registries — Official MCP and Glama, with 3 tracked versions. It was first listed on Aug 12, 2026 and most recently updated on Aug 15, 2026.

Not verifiedMCP Toplist has not yet written a checked profile for this server, so the paragraph above is assembled from registry data only. The repository README is the authority on what it does.

CAPABILITIES AND LIMITATIONS

What sw-postgres-mcp can and cannot do

Not verifiedMCP Toplist has not catalogued this server's tools or limitations. The repository README lists them.

REQUIREMENTS

What you need before using sw-postgres-mcp

DeclaredNo credentialsNo credentials declared

The registry listing declares no required environment variables or authentication. This is declared metadata, not a verified install — the repository README is the authority.

Declared by Glama, last synced Oct 16, 2026. Not independently verified by MCP Toplist.

Declared in the registry install config

DATABASE_URL_READONLY · required
DATABASE_URL_WRITER · required

INSTALLATION AND FIRST TASK

Connect sw-postgres-mcp and confirm it works

npm package

claude mcp add sw-postgres-mcp -e "DATABASE_URL_READONLY=<your DATABASE_URL_READONLY>" -e "DATABASE_URL_WRITER=<your DATABASE_URL_WRITER>" -- npx -y sw-postgres-mcp

Replace each placeholder with your own value before saving.

npm package

[mcp_servers.sw-postgres-mcp]
command = "npx"
args = ["-y", "sw-postgres-mcp"]

[mcp_servers.sw-postgres-mcp.env]
DATABASE_URL_READONLY = "<your DATABASE_URL_READONLY>"
DATABASE_URL_WRITER = "<your DATABASE_URL_WRITER>"

Add to ~/.codex/config.toml. Replace each placeholder with your own value before saving.

npm package

{
  "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>"
      }
    }
  }
}

Add to claude_desktop_config.json (Settings → Developer → Edit Config). Replace each placeholder with your own value before saving.

npm package

{
  "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>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (per project). Replace each placeholder with your own value before saving.

npm package

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

Save as .vscode/mcp.json in your workspace. Replace each placeholder with your own value before saving.

npm package

{
  "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>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json. Replace each placeholder with your own value before saving.

npm package

{
  "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>"
      }
    }
  }
}

Replace each placeholder with your own value before saving.

First successful task

After adding the config, ask your client to list this server's tools. A tool list confirms the connection; an empty list or an error means the server did not start or needs credentials.

ALTERNATIVES

When to choose another server

Other servers by jpka

shopify-operations-mcp#62,390

View all jpka servers →

No task-specific alternatives are catalogued for sw-postgres-mcpyet; the list above is its publisher's other servers.

MAINTENANCE AND EVIDENCE

What changed, and when this was checked

First listed: Aug 12, 2026
Latest version published: Aug 15, 2026
Version history: 3 versions tracked (below)
Requirements evidence: Declared by Glama, last synced Oct 16, 2026. Not independently verified by MCP Toplist.
Profile checked: Not yet — purpose, capabilities and requirements above come from registry data only
Ranking data as of: Oct 16, 2026

Registry sightings

Glama ↗listed since Aug 13, 2026 · still listed
Official MCP ↗listed since Aug 14, 2026 · still listed

Do you maintain sw-postgres-mcp? to correct or enrich this profile.

VERSIONS

Available versions (3)

Version	Published
0.3.1	Aug 15, 2026
0.3.0	Aug 14, 2026
0.1.0	Aug 13, 2026

STANDING

#55,941of 144,396 active serversTop 50%

Ranks ahead of 88,455 of 144,396 servers on MCP Toplist.

BADGE

Show your rank

Maintain this server? Add the live rank badge to your README — it updates automatically as the leaderboard changes.

Markdown

[![MCP Toplist](https://mcptoplist.com/badge/io.github.jpka%2Fsw-postgres-mcp.svg)](https://mcptoplist.com/server/io.github.jpka%2Fsw-postgres-mcp)

HTML

<a href="https://mcptoplist.com/server/io.github.jpka%2Fsw-postgres-mcp"><img src="https://mcptoplist.com/badge/io.github.jpka%2Fsw-postgres-mcp.svg" alt="MCP Toplist: Top 50% of 144,396" /></a>

Variants: append ?metric=score or ?metric=stars to the image URL.

FAQ

Frequently asked questions

Who maintains sw-postgres-mcp?: sw-postgres-mcp is maintained by jpka, which publishes 2 MCP servers (5 total versions) tracked on MCP Toplist.
Is sw-postgres-mcp listed on the Official MCP Registry?: Yes — sw-postgres-mcp is listed on the Official MCP Registry, alongside Glama.
How many versions does sw-postgres-mcp have?: MCP Toplist tracks 3 versions of sw-postgres-mcp, most recently published on Aug 15, 2026.
Where can I find the source code for sw-postgres-mcp?: The source code for sw-postgres-mcp is hosted at github.com/jpka/sw-postgres-mcp.

Used in projects

Do you run this server?

Community projects list the MCP servers behind real agents and apps. Publish yours and this page will link to it.

EXPLORE

All MCP Servers Official MCP Servers GitHub MCP Servers Best MCP Servers Most Active MCP Servers New MCP Servers Best New MCP Servers