Search / io.github.sparta2025/postgres-mcp
postgres-mcp
L0· runs locallyPostgreSQL MCP server with 15 tools (SQL, EXPLAIN, health, indexes) plus a Gradio UI with LLM chat.
v0.4.2 · active · repository · descriptor JSON · versions
Search / io.github.sparta2025/postgres-mcp
L0· runs locallyPostgreSQL MCP server with 15 tools (SQL, EXPLAIN, health, indexes) plus a Gradio UI with LLM chat.
v0.4.2 · active · repository · descriptor JSON · versions
{
"mcpServers": {
"postgres-mcp": {
"command": "uvx",
"args": [
"postgres-mcp-pro==0.4.2"
],
"env": {
"DATABASE_URL": "${DATABASE_URL}"
}
}
}
}claude mcp add postgres-mcp -e "DATABASE_URL=${DATABASE_URL}" -- uvx postgres-mcp-pro==0.4.2[mcp_servers.postgres-mcp]
command = "uvx"
args = ["postgres-mcp-pro==0.4.2"]
env = { "DATABASE_URL" = "${DATABASE_URL}" }
{
"$schema": "https://opencode.ai/config.json",
"mcp": {
"postgres-mcp": {
"type": "local",
"command": [
"uvx",
"postgres-mcp-pro==0.4.2"
],
"enabled": true,
"environment": {
"DATABASE_URL": "{env:DATABASE_URL}"
}
}
}
}{
"mcpServers": {
"postgres-mcp": {
"command": "uvx",
"args": [
"postgres-mcp-pro==0.4.2"
],
"env": {
"DATABASE_URL": "${DATABASE_URL}"
}
}
},
"deeplink": "cursor://anysphere.cursor-deeplink/mcp/install?name=postgres-mcp&config=eyJjb21tYW5kIjoidXZ4IiwiYXJncyI6WyJwb3N0Z3Jlcy1tY3AtcHJvPT0wLjQuMiJdLCJlbnYiOnsiREFUQUJBU0VfVVJMIjoiJHtEQVRBQkFTRV9VUkx9In19"
}{
"servers": {
"postgres-mcp": {
"type": "stdio",
"command": "uvx",
"args": [
"postgres-mcp-pro==0.4.2"
],
"env": {
"DATABASE_URL": "${DATABASE_URL}"
}
}
}
}{
"mcpServers": {
"postgres-mcp": {
"command": "uvx",
"args": [
"postgres-mcp-pro==0.4.2"
],
"env": {
"DATABASE_URL": "${DATABASE_URL}"
}
}
}
}extensions:
"postgres-mcp":
enabled: true
name: "postgres-mcp"
type: stdio
cmd: "uvx"
args:
- "postgres-mcp-pro==0.4.2"
envs:
"DATABASE_URL": "${DATABASE_URL}"
timeout: 300
Placeholders to fill from your own secret store: ${DATABASE_URL}. 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 unknowndeps.known_vulns21 advisories to act on (malicious, or rated high or critical with a fix available): GHSA-2g87-pp6c-29x5 in [email protected] (indirect, fixed in 3.14.4), GHSA-5wr8-gcqf-gqf3 in [email protected] (indirect, fixed in 3.14.4), GHSA-39mp-8hj3-5c49 in [email protected] (direct, fixed in 6.7.0), ...; 12 more of lower severity or without a fixdeps.mcp_sdk_versionmcp 1.30.0, no known advisorydeps.resolvable[email protected] resolved: 97 packagesNo 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 ~liveness-unmeasured ~updated-60d-ago
Derived from observable signals (official registry feed and our own credential-free probes); no code audit performed. How it is computed.
[email protected] PyPI96 dependencies, resolved · MCP SDK mcp 1.30.0 · advisories checked 2026-10-19
| advisory | severity | package | fixed in |
|---|---|---|---|
| GHSA-2g87-pp6c-29x5aiohttp: Multiple instances of excessive or unbounded memory/CPU use | high | [email protected]indirect | fixed in 3.14.4 |
| GHSA-5wr8-gcqf-gqf3aiohttp server lacks an initial request/header timeout | high | [email protected]indirect | fixed in 3.14.4 |
| GHSA-39mp-8hj3-5c49Gradio is Vulnerable to Absolute Path Traversal on Windows with Python 3.13+ | high | [email protected]direct | fixed in 6.7.0 |
| GHSA-7hp7-4p35-3cx2Gradio contains a cookie injection vulnerability | high | [email protected]direct | fixed in 6.15.0 |
| GHSA-j36p-7w88-g82jGradio FileExplorer preprocess path traversal allows files outside root_dir to reach callbacks | high | [email protected]direct | fixed in 6.16.0 |
| GHSA-jmh7-g254-2cq9Gradio has SSRF via Malicious `proxy_url` Injection in `gr.load()` Config Processing | high | [email protected]direct | fixed in 6.6.0 |
| GHSA-45hq-cxwh-f6vcPillow `BdfFontFile`: `Image.new()` called without `_decompression_bomb_check()` — bomb protection bypass via font loading | high | [email protected]indirect | fixed in 12.3.0 |
| GHSA-5x94-69rx-g8h2Pillow: `FontFile.compile()`: `Image.new()` called without `_decompression_bomb_check()` | high | [email protected]indirect | fixed in 12.3.0 |
| GHSA-62p4-gmf7-7g93Pillow: Out-of-bounds read via attacker-controlled row stride on Pillow's mmap path (McIdas AREA files) | high | [email protected]indirect | fixed in 12.3.0 |
| GHSA-6r8x-57c9-28j4Pillow: Heap out-of-bounds write `Image.paste()` / `Image.crop()` via signed coordinate overflow | high | [email protected]indirect | fixed in 12.3.0 |
23 more advisories in the dependencies endpoint.
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 |
|---|---|---|---|---|
postgres-mcp-pro | pypi | 0.4.2 | – | DATABASE_URL |
No tools observed. Local packages are never executed by the registry.
Schemas: list_tools.
{
"name": "io.github.sparta2025/postgres-mcp",
"$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
"version": "0.4.2",
"packages": [
{
"version": "0.4.2",
"transport": {
"type": "stdio"
},
"identifier": "postgres-mcp-pro",
"registryType": "pypi",
"environmentVariables": [
{
"name": "DATABASE_URL",
"format": "string",
"isSecret": true,
"isRequired": true,
"description": "PostgreSQL connection URL, e.g. postgresql://user:pass@localhost:5432/dbname"
}
]
}
],
"repository": {
"url": "https://github.com/sparta2025/postgres-mcp",
"source": "github"
},
"description": "PostgreSQL MCP server with 15 tools (SQL, EXPLAIN, health, indexes) plus a Gradio UI with LLM chat."
}