mcp-postgresdb-readonly
by nayzo
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| PORT | No | If set, starts server in HTTP mode on this port. If not set, runs in stdio mode. | |
| MAX_ROWS | No | Maximum rows returned per query (auto LIMIT). Default: 1000. | 1000 |
| MCP_AUTH_TOKEN | No | Bearer token required for HTTP mode. If not set, server is unprotected. | |
| QUERY_TIMEOUT_MS | No | Query timeout in milliseconds. Default: 30000. | 30000 |
| POSTGRES_PROD_SSL | No | Enable SSL for production PostgreSQL. Default: true. | true |
| POSTGRES_TEST_SSL | No | Enable SSL for test PostgreSQL. Default: true. | true |
| POSTGRES_PROD_HOST | No | Hostname for production PostgreSQL database. | |
| POSTGRES_PROD_PORT | No | Port for production PostgreSQL database. Default: 5432. | 5432 |
| POSTGRES_PROD_USER | No | User for production PostgreSQL database. | |
| POSTGRES_TEST_HOST | No | Hostname for test PostgreSQL database. | |
| POSTGRES_TEST_PORT | No | Port for test PostgreSQL database. Default: 5432. | 5432 |
| POSTGRES_TEST_USER | No | User for test PostgreSQL database. | |
| POSTGRES_PROD_SCHEMA | No | Optional schema to restrict access for production environment. If not set, all user schemas are accessible. | |
| POSTGRES_STAGING_SSL | No | Enable SSL for staging PostgreSQL. Default: true. | true |
| POSTGRES_TEST_SCHEMA | No | Optional schema to restrict access for test environment. | |
| POSTGRES_STAGING_HOST | No | Hostname for staging PostgreSQL database. | |
| POSTGRES_STAGING_PORT | No | Port for staging PostgreSQL database. Default: 5432. | 5432 |
| POSTGRES_STAGING_USER | No | User for staging PostgreSQL database. | |
| RATE_LIMIT_PER_MINUTE | No | Maximum requests per minute. Default: 60. | 60 |
| POSTGRES_PROD_DATABASE | No | Database name for production PostgreSQL. | |
| POSTGRES_PROD_PASSWORD | No | Password for production PostgreSQL user. | |
| POSTGRES_TEST_DATABASE | No | Database name for test PostgreSQL. | |
| POSTGRES_TEST_PASSWORD | No | Password for test PostgreSQL user. | |
| POSTGRES_STAGING_SCHEMA | No | Optional schema to restrict access for staging environment. | |
| POSTGRES_STAGING_DATABASE | No | Database name for staging PostgreSQL. | |
| POSTGRES_STAGING_PASSWORD | No | Password for staging PostgreSQL user. |
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
- 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/nayzo/mcp-postgresdb-readonly'
If you have feedback or need assistance with the MCP directory API, please join our Discord server