postgres-mcp-safe MCP
A drop-in replacement for the deprecated @modelcontextprotocol/server-postgres that enforces read-only access by opening a fresh connection and starting a READ ONLY transaction for every call. It allows AI tools to query a Postgres database, read its schema, and explain queries while preventing destructive operations like COMMIT or DROP TABLE.
Package and access
Local package with source-attributed installation metadata. Koskamo does not execute packages during review.
Checks and signals
Each line is separate evidence, not a trust score.
- Popularity 1 GitHub star
What you can do with it
- Query a Postgres database with read-only statements
- List tables and views with schema and type information
- Describe table columns, constraints, and indexes
- Explain query plans for SQL statements
Source and maintenance
- Last repository push
- Latest release
- v0.1.2
- Maintenance checked
Packages and installation
Source-provided package data. Koskamo has not executed or live-probed this package.
postgres-mcp-safe 0.1.2
{
"version": "0.1.2",
"transport": "stdio",
"identifier": "postgres-mcp-safe",
"runtimeHint": "npx",
"registryType": "npm",
"packageArguments": [
{
"type": "positional",
"valueHint": "postgresql_url",
"isRequired": true,
"description": "Postgres connection URL. Use a read-only role."
}
]
}Tools
Reported by the attributed source; not independently observed by Koskamo.
Maintenance history
Public check and source-refresh events. Editorial and ownership records remain private.
- · repository · passed · metadata changed · updated
- · backfill · recorded · Pre-expansion baseline; unobserved rich metadata remains unknown
Connect from your client
Each snippet configures the same source-provided package; replace placeholders before use.
Cursor
{
"mcpServers": {
"postgres-mcp-safe-mcp": {
"command": "npx",
"args": [
"-y",
"postgres-mcp-safe@0.1.2"
]
}
}
}Cline
{
"mcpServers": {
"postgres-mcp-safe-mcp": {
"command": "npx",
"args": [
"-y",
"postgres-mcp-safe@0.1.2"
]
}
}
}VS Code
{
"servers": {
"postgres-mcp-safe-mcp": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"postgres-mcp-safe@0.1.2"
]
}
}
}Claude Desktop
{
"mcpServers": {
"postgres-mcp-safe-mcp": {
"command": "npx",
"args": [
"-y",
"postgres-mcp-safe@0.1.2"
]
}
}
}Let your agent find its tools
Find servers like postgres-mcp-safe MCP from your agent. Add Koskamo once to search the index for endpoints, access requirements, and client setup. Public discovery needs no key.