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.
DATABASE_URL_READONLYrequiredsecretPostgres connection string for the read-only role.
DATABASE_URL_WRITERrequiredsecretPostgres connection string for the writer role.
{
"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

shopify-operations-mcp
Safe-write Shopify operations: plan-before-execute writes with out-of-band approval and audit.
Governed MCP seller node: buyer agents discover inventory and register intents; no ad-server writes

Korean market data: kimchi premium, sell-side research, news. Pay per call in USDC via x402.
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 →

