Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MCP_NAME | No | Server name | postgresql-mcp-server |
| MCP_VERSION | No | Server version | 1.0.0 |
| MCP_MAX_ROWS | No | Maximum rows returned per query | 1000 |
| MCP_LOG_LEVEL | No | Logging level | INFO |
| POSTGRES_HOST | No | PostgreSQL server host | localhost |
| POSTGRES_PORT | No | PostgreSQL server port | 5432 |
| MCP_LOG_QUERIES | No | Whether to log executed queries | true |
| POSTGRES_DATABASE | Yes | Database name | |
| POSTGRES_PASSWORD | Yes | Database password | |
| POSTGRES_SSL_MODE | No | SSL connection mode | prefer |
| POSTGRES_USERNAME | Yes | Database username | |
| MCP_MAX_QUERY_TIME | No | Max query execution time (seconds) | 30 |
| MCP_ALLOWED_SCHEMAS | No | Comma-separated list of allowed schemas | |
| POSTGRES_MAX_CONNECTIONS | No | Maximum pool connections | 10 |
| POSTGRES_MIN_CONNECTIONS | No | Minimum pool connections | 1 |
Schema
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
No tools | |