MCP Postgres Analyst
by AkibUllah
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| PORT | No | Port for HTTP transport binding; alternative to MCP_PORT. | |
| MAX_ROWS | No | Hard cap on rows returned per query. | 1000 |
| MCP_HOST | No | Host interface for HTTP transport binding. | 127.0.0.1 |
| MCP_PORT | No | Port for HTTP transport binding. | 8765 |
| POLICY_PATH | No | Path to the YAML policy file for masking, blocked tables/columns/functions, rate limits, and saved queries. Empty disables policy loading. | config/policy.yaml |
| DATABASE_URL | No | Database connection URL. Supports sqlite:///relative.db, sqlite:////absolute.db, or postgresql://user:pass@host/db (postgres:// accepted). | sqlite:///data/demo.db |
| DEFAULT_LIMIT | No | Default row limit injected into queries. | 100 |
| AUDIT_LOG_PATH | No | Path to the JSONL audit log file. Empty disables audit logging. | logs/audit.jsonl |
| MCP_HTTP_TOKEN | No | Bearer token required on the /mcp endpoint when HTTP transport is used. | |
| ALLOWED_SCHEMAS | No | Comma-separated PostgreSQL schemas exposed by the server. | public |
| MAX_RESULT_BYTES | No | Maximum result payload size in bytes. Rows beyond this are dropped and flagged. | 262144 |
| MCP_ALLOWED_HOSTS | No | Additional Host values accepted by DNS-rebinding protection, for example when using a public hostname. | |
| STATEMENT_TIMEOUT_MS | No | Per-statement timeout in milliseconds. | 5000 |
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 issues