Search / io.github.les-k/pg-readonly-mcp
pg-readonly-mcp
L0· runs locallyA read-only Postgres MCP server that parses SQL rather than pattern-matching it.
v0.1.1 · active · repository · website · descriptor JSON · versions
Search / io.github.les-k/pg-readonly-mcp
L0· runs locallyA read-only Postgres MCP server that parses SQL rather than pattern-matching it.
v0.1.1 · active · repository · website · descriptor JSON · versions
{
"mcpServers": {
"pg-readonly-mcp": {
"command": "uvx",
"args": [
"pg-readonly-mcp==0.1.1"
],
"env": {
"PG_READONLY_MCP_DSN": "${PG_READONLY_MCP_DSN}"
}
}
}
}claude mcp add pg-readonly-mcp -e "PG_READONLY_MCP_DSN=${PG_READONLY_MCP_DSN}" -- uvx pg-readonly-mcp==0.1.1[mcp_servers.pg-readonly-mcp]
command = "uvx"
args = ["pg-readonly-mcp==0.1.1"]
env = { "PG_READONLY_MCP_DSN" = "${PG_READONLY_MCP_DSN}" }
{
"$schema": "https://opencode.ai/config.json",
"mcp": {
"pg-readonly-mcp": {
"type": "local",
"command": [
"uvx",
"pg-readonly-mcp==0.1.1"
],
"enabled": true,
"environment": {
"PG_READONLY_MCP_DSN": "{env:PG_READONLY_MCP_DSN}"
}
}
}
}{
"mcpServers": {
"pg-readonly-mcp": {
"command": "uvx",
"args": [
"pg-readonly-mcp==0.1.1"
],
"env": {
"PG_READONLY_MCP_DSN": "${PG_READONLY_MCP_DSN}"
}
}
},
"deeplink": "cursor://anysphere.cursor-deeplink/mcp/install?name=pg-readonly-mcp&config=eyJjb21tYW5kIjoidXZ4IiwiYXJncyI6WyJwZy1yZWFkb25seS1tY3A9PTAuMS4xIl0sImVudiI6eyJQR19SRUFET05MWV9NQ1BfRFNOIjoiJHtQR19SRUFET05MWV9NQ1BfRFNOfSJ9fQ%3D%3D"
}{
"servers": {
"pg-readonly-mcp": {
"type": "stdio",
"command": "uvx",
"args": [
"pg-readonly-mcp==0.1.1"
],
"env": {
"PG_READONLY_MCP_DSN": "${PG_READONLY_MCP_DSN}"
}
}
}
}{
"mcpServers": {
"pg-readonly-mcp": {
"command": "uvx",
"args": [
"pg-readonly-mcp==0.1.1"
],
"env": {
"PG_READONLY_MCP_DSN": "${PG_READONLY_MCP_DSN}"
}
}
}
}extensions:
"pg-readonly-mcp":
enabled: true
name: "pg-readonly-mcp"
type: stdio
cmd: "uvx"
args:
- "pg-readonly-mcp==0.1.1"
envs:
"PG_READONLY_MCP_DSN": "${PG_READONLY_MCP_DSN}"
timeout: 300
Placeholders to fill from your own secret store: ${PG_READONLY_MCP_DSN}. The registry never accepts secret values.
This is a local package: the command runs on your machine.
Not scored: fewer than three checks apply, usually because no remote answered a credential-free probe or the server is a local package.
protocol.modern, protocol.stateless, protocol.transport, protocol.list_ttlno remote answered a protocol handshake (not probed yet, unreachable, or local-only)auth.prm, auth.as_metadata, auth.cimdno remote uses OAuthauth.secret_in_urlno templated URLtools.descriptions, tools.description_length, tools.schemas, tools.annotations, tools.directory_hints, tools.token_cost, tools.api_dumptool list unknown (behind auth, not probed, or empty)stability.changes, stability.rug_pulltool list unknownNo tool definition changes recorded. A server's first observation is its baseline; later probes record what changes.
Checks run on what our credential-free, read-only probes observe; tools are never called and no code audit is performed. How it is computed.
+repository +namespace-matches-repo +website ~liveness-unmeasured +updated-18d-ago
Derived from observable signals (official registry feed and our own credential-free probes); no code audit performed. How it is computed.
[email protected] PyPIthis version is not known to the dependency resolver
Dependency graphs from deps.dev; advisories from OSV.dev, including the GitHub Advisory Database and the PyPI Advisory Database; all CC BY 4.0. The graph is what a clean install of this version resolves today; nothing was installed or run. How it is checked.
| package | registry | version | runtime | secrets |
|---|---|---|---|---|
pg-readonly-mcp | pypi | 0.1.1 | – | PG_READONLY_MCP_DSN |
No tools observed. Local packages are never executed by the registry.
Schemas: list_tools.
{
"name": "io.github.les-k/pg-readonly-mcp",
"$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
"version": "0.1.1",
"packages": [
{
"version": "0.1.1",
"transport": {
"type": "stdio"
},
"identifier": "pg-readonly-mcp",
"registryType": "pypi",
"environmentVariables": [
{
"name": "PG_READONLY_MCP_DSN",
"format": "string",
"isSecret": true,
"isRequired": true,
"description": "Postgres connection string for a role that holds only SELECT. The server refuses to start otherwise."
}
]
}
],
"repository": {
"url": "https://github.com/les-k/pg-readonly-mcp",
"source": "github"
},
"websiteUrl": "https://les-k.github.io/field-notes.html",
"description": "A read-only Postgres MCP server that parses SQL rather than pattern-matching it."
}