postgres-mcp-server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| LOG_JSON | No | Output logs as JSON | false |
| MAX_ROWS | No | Max rows returned per query | 1000 |
| CACHE_TTL | No | Schema cache TTL in seconds | 300 |
| LOG_LEVEL | No | Log level (DEBUG, INFO, WARNING, ERROR) | INFO |
| READ_ONLY | No | Restrict to SELECT only | true |
| RATE_LIMIT | No | Max requests per window | 60 |
| ALLOW_WRITE | No | Enable write operations | false |
| RATE_WINDOW | No | Rate limit window in seconds | 60 |
| POSTGRES_HOST | No | PostgreSQL host | localhost |
| POSTGRES_PORT | No | PostgreSQL port | 5432 |
| POSTGRES_USER | No | Database user | postgres |
| QUERY_TIMEOUT | No | Query timeout in seconds | 30 |
| METRICS_ENABLED | No | Enable metrics collection | true |
| POSTGRES_DATABASE | No | Database name | postgres |
| POSTGRES_PASSWORD | No | Database password | |
| RETRY_MAX_ATTEMPTS | No | Max connection retries | 3 |
| POSTGRES_MAX_CONNECTIONS | No | Max pool connections | 10 |
| POSTGRES_MIN_CONNECTIONS | No | Min pool connections | 1 |
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 | |
Latest Blog Posts
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
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/abdulsammad-lgtm/postgres-mcp-server'
If you have feedback or need assistance with the MCP directory API, please join our Discord server