Postgres MCP Server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| POOL_MAX | No | Maximum connections in pool | 10 |
| POOL_MIN | No | Minimum connections in pool | 2 |
| CACHE_TTL | No | Cache TTL in milliseconds | 300000 |
| LOG_LEVEL | No | Logging level (error|warn|info|debug) | info |
| SQL_LOGGING | No | Log SQL queries | false |
| DATABASE_URL | No | PostgreSQL connection string in format postgresql://username:password@localhost:5432/dbname | |
| POSTGRES_SSL | No | Enable SSL connection | false |
| CACHE_ENABLED | No | Enable query result caching | true |
| POSTGRES_HOST | No | PostgreSQL host | |
| POSTGRES_PORT | No | PostgreSQL port | |
| POSTGRES_USER | No | PostgreSQL username | |
| POOL_IDLE_TIMEOUT | No | Idle timeout in milliseconds | 30000 |
| POSTGRES_DATABASE | No | PostgreSQL database name | |
| POSTGRES_PASSWORD | No | PostgreSQL password | |
| POOL_ACQUIRE_TIMEOUT | No | Acquire timeout in milliseconds | 60000 |
Capabilities
Server capabilities have not been inspected yet.
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| queryC | Execute SQL queries with transaction support, query analysis, and performance monitoring |
| tablesC | Table management: list, create, alter, drop tables and get detailed table information |
| schemasC | Schema management: list, create, drop schemas and manage schema permissions |
| indexesC | Index management: list, create, drop indexes and analyze index usage |
| dataC | Data operations: insert, update, delete, bulk operations with validation |
| transactionsC | Transaction management: begin, commit, rollback, savepoints |
| adminC | Database administration: users, permissions, database info, maintenance operations |
| monitoringC | Database monitoring: performance metrics, statistics, health checks |
| connectionsC | Connection pool management: status, statistics, configuration |
| permissionsC | Database permissions management: users, roles, grants, privileges |
| securityC | Database security management: SSL, authentication, encryption, auditing |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Latest Blog Posts
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/itsalfredakku/postgres-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server