postgres-mcp-server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| DATABASE_URL | No | URL de conexión PostgreSQL (alternativa a POSTGRES_URL). | |
| POSTGRES_URL | No | URL de conexión PostgreSQL. | |
| PG_MAX_CONNECTIONS | No | Máximo de conexiones del pool. | 10 |
| POSTGRES_ENABLE_WRITE | No | Habilita INSERT, UPDATE, DELETE, MERGE, COPY. | false |
| TRANSACTION_TIMEOUT_MS | No | Tiempo máximo de transacciones pendientes. | 60000 |
| PG_STATEMENT_TIMEOUT_MS | No | Tiempo máximo de sentencia. | 30000 |
| MAX_CONCURRENT_TRANSACTIONS | No | Máximo de transacciones de escritura abiertas. | 5 |
| POSTGRES_ENABLE_MAINTENANCE | No | Habilita DROP, TRUNCATE, ALTER, CREATE, VACUUM, ANALYZE, REINDEX, GRANT, REVOKE. | false |
Capabilities
Features and capabilities supported by this server
| Capability | Details |
|---|---|
| tools | {
"listChanged": true
} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| execute_queryA | Ejecuta una consulta SQL de solo lectura. Por seguridad corre dentro de una transacción READ ONLY. |
| execute_dml_ddl_dcl_tclA | Ejecuta escritura SQL solo si POSTGRES_ENABLE_WRITE=true. Deja la transacción pendiente hasta commit o rollback. |
| execute_maintenanceA | Ejecuta mantenimiento SQL solo si POSTGRES_ENABLE_MAINTENANCE=true. |
| execute_commitA | Confirma una transacción abierta por execute_dml_ddl_dcl_tcl. |
| execute_rollbackA | Revierte una transacción abierta por execute_dml_ddl_dcl_tcl. |
| list_schemasA | Lista esquemas visibles no internos. |
| list_tablesA | Lista tablas visibles, opcionalmente filtradas por esquema. Usa SQL parametrizado. |
| describe_tableA | Describe columnas, índices y constraints de una tabla. Usa SQL parametrizado. |
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/bysonte/postgres-mcp-server'
If you have feedback or need assistance with the MCP directory API, please join our Discord server