Metadata-Version: 2.4
Name: pg-mcp-server
Version: 0.1.2
Summary: PostgreSQL MCP server via psql subprocess
License: MIT
Requires-Python: >=3.10
Requires-Dist: mcp>=1.0.0
Requires-Dist: pyyaml>=6.0
Description-Content-Type: text/markdown

# 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`:

```yaml
connections:
  dev-mydb:
    host: db.example.com
    port: 5432
    dbname: mydb
    user: myuser
    password: "mypassword"
```

## Tools

- `list_connections` — list configured connections
- `list_tables(connection, schema?)` — list tables
- `describe_table(connection, table, schema?)` — show columns and indexes
- `query(connection, sql)` — execute SQL
