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
1 maintainer
Metadata
1 maintainer
Release files for pg-mcp-server 0.1.5
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| pg_mcp_server-0.1.5.tar.gz | 62.2 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| pg_mcp_server-0.1.5-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 68.0 kB
Release files / pg_mcp_server-0.1.5.tar.gz
| Download URL | pg_mcp_server-0.1.5.tar.gz |
|---|---|
| Size | 62.2 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
1a87e8324290fe49727c74de80db008ee6969f0165d78096025e969c0962abe7
|
|
BLAKE2b-256 checksum How to use checksums |
34bf30926c1d3f5a20caf951a40642e8030207a23cbb45bbdf6f21ed1cdf622a
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is 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}
|
Release files / pg_mcp_server-0.1.5-py3-none-any.whl
| Download URL | pg_mcp_server-0.1.5-py3-none-any.whl |
|---|---|
| Size | 5.8 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
00cdcf21eaabd0845c0d2b357a0b3ef9911afea5bdae0a6c5d7c0a765d45c2be
|
|
BLAKE2b-256 checksum How to use checksums |
056a8bdbdd0d9c4ae38a488d65aa658cc83659b941229828d0ef330414b7e607
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is 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}
|
