PostgreSQL MCP server via psql subprocess
Project description
pg-mcp
PostgreSQL MCP server that executes queries via psql subprocess. No persistent connections — each query opens psql, runs SQL, closes.
Config
~/.config/pg-mcp/connections.yml:
connections:
dev-mydb:
host: db.example.com
port: 5432
dbname: mydb
user: myuser
password: "mypassword"
Tools
list_connections— list configured connectionslist_tables(connection, schema?)— list tablesdescribe_table(connection, table, schema?)— show columns and indexesquery(connection, sql)— execute SQL
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
pg_mcp_server-0.1.0.tar.gz
(52.7 kB
view details)
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file pg_mcp_server-0.1.0.tar.gz.
File metadata
- Download URL: pg_mcp_server-0.1.0.tar.gz
- Upload date:
- Size: 52.7 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: uv/0.10.12 {"installer":{"name":"uv","version":"0.10.12","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":null,"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":null}
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
1cb94344bd05a48e1bb1d0e120cc04bac79bfacec4defe66778dd78f4f775c0a
|
|
| MD5 |
02c44ec8c159af5e4a114fcd2524f1d1
|
|
| BLAKE2b-256 |
0ad798c4452a9a7a31d2fe90ea46c19fe7535be92c3bb8338af2a27ee1a91955
|
File details
Details for the file pg_mcp_server-0.1.0-py3-none-any.whl.
File metadata
- Download URL: pg_mcp_server-0.1.0-py3-none-any.whl
- Upload date:
- Size: 5.0 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: uv/0.10.12 {"installer":{"name":"uv","version":"0.10.12","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":null,"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":null}
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
d914537e3014fd2b7a68b0da9aa2f7e3235fa3cbe426acbab2a08e3efe665b30
|
|
| MD5 |
5c14afb32b289369091d5fb4e39e1516
|
|
| BLAKE2b-256 |
6565229010860cd071b83b38fbbd7c4d141c2a1771e073ebf420a10ef9e3b3b8
|
