pg-readonly-mcp
by vinit1009
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MCP_PG_DSN | Yes | libpq connection string or URL. Prefer ~/.pgpass or PGPASSWORD to a password in the string. | |
| MCP_PG_AUDIT_LOG | No | Where the audit log goes (created with mode 600). | ~/.pg-readonly-mcp/audit.jsonl |
| MCP_PG_ROW_LIMIT | No | Most rows one run_query returns (hard maximum 10,000). Claude can ask for fewer. | 200 |
| MCP_PG_TIMEOUT_MS | No | Statement timeout for each query. | 10000 |
| MCP_PG_SEARCH_PATH | No | Schemas searched for unqualified table names. | public |
| MCP_PG_ALLOWED_TABLES | Yes | Comma-separated schema.table entries, or schema.* for a whole schema. A bare name means public.name. Quote mixed-case names: "Sales"."Q1 Orders". | |
| MCP_PG_MAX_CELL_CHARS | No | Long text values are cut to this length so one cell cannot flood the context. | 2000 |
| MCP_PG_ALLOW_SUPERUSER | No | Set to 1 only for a throwaway local database. | off |
| MCP_PG_EXTRA_FUNCTIONS | No | Extra function names to allow, e.g. similarity, unaccent. |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Server capabilities have not been inspected yet.
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
No tools | |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
This server cannot be deployed
Maintenance
ActivityMaintained
ResponsivenessNo recent community issues