PostgreSQL MCP Server
by SaadRiaz99
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| DATABASE_URL | No | Optional SQLAlchemy database URL, e.g. postgresql+asyncpg://user:password@localhost:5432/your_db. Note: the asyncpg pool uses the separate DATABASE_* fields; changing DATABASE_URL alone does not configure that pool. | |
| DATABASE_HOST | Yes | PostgreSQL host. Required for the asyncpg pool. | |
| DATABASE_NAME | Yes | PostgreSQL database name. Required for the asyncpg pool. | |
| DATABASE_PORT | Yes | PostgreSQL port. Required for the asyncpg pool. | |
| DATABASE_USER | Yes | PostgreSQL user. Required for the asyncpg pool. | |
| ENABLE_AI_SQL | No | Enable AI SQL tools. | |
| READ_ONLY_MODE | No | When true, only SELECT and EXPLAIN are allowed. | |
| ENABLE_AUDIT_LOG | No | Enable audit logging. | |
| DATABASE_PASSWORD | Yes | PostgreSQL password. Required for the asyncpg pool. |
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
ResponsivenessUnresponsive