← PostgreSQL MCP Server (Cloudflare Worker)
1.0.2npm · postgres-mcp-server · current release
Observed 2026-08-18T05:31:15.014Z using mcpSecurity-inventory. Status: succeeded. Negotiated protocol: 2024-11-05.
{
"tools": {}
}| Tool | Category | Annotations | Risk |
|---|---|---|---|
describe_tableGet the structure of a database tableInput schema{
"type": "object",
"properties": {
"schema": {
"type": "string",
"minLength": 1,
"maxLength": 63,
"pattern": "^[a-zA-Z_][a-zA-Z0-9_]*$"
},
"table": {
"type": "string",
"minLength": 1,
"maxLength": 63,
"pattern": "^[a-zA-Z_][a-zA-Z0-9_]*$"
}
},
"required": [
"schema",
"table"
],
"additionalProperties": false
} | — | — · — | — |
explain_queryGet query execution plan (EXPLAIN)Input schema{
"type": "object",
"properties": {
"sql": {
"type": "string",
"minLength": 1,
"maxLength": 50000
},
"analyze": {
"type": "boolean"
},
"buffers": {
"type": "boolean"
},
"costs": {
"type": "boolean"
},
"format": {
"type": "string",
"enum": [
"text",
"json",
"xml",
"yaml"
]
}
},
"required": [
"sql"
],
"additionalProperties": false
} | — | — · — | — |
get_constraintsGet constraints for a tableInput schema{
"type": "object",
"properties": {
"schema": {
"type": "string",
"minLength": 1,
"maxLength": 63,
"pattern": "^[a-zA-Z_][a-zA-Z0-9_]*$"
},
"table": {
"type": "string",
"minLength": 1,
"maxLength": 63,
"pattern": "^[a-zA-Z_][a-zA-Z0-9_]*$"
}
},
"required": [
"schema",
"table"
],
"additionalProperties": false
} | — | — · — | — |
get_table_statsGet table statistics and size informationInput schema{
"type": "object",
"properties": {
"schema": {
"type": "string",
"minLength": 1,
"maxLength": 63,
"pattern": "^[a-zA-Z_][a-zA-Z0-9_]*$"
},
"table": {
"type": "string",
"minLength": 1,
"maxLength": 63,
"pattern": "^[a-zA-Z_][a-zA-Z0-9_]*$"
}
},
"required": [
"schema"
],
"additionalProperties": false
} | — | — · — | — |
list_functionsList functions and procedures in a schemaInput schema{
"type": "object",
"properties": {
"schema": {
"type": "string",
"minLength": 1,
"maxLength": 63,
"pattern": "^[a-zA-Z_][a-zA-Z0-9_]*$"
}
},
"additionalProperties": false
} | — | — · — | — |
list_indexesList indexes for a table or schemaInput schema{
"type": "object",
"properties": {
"schema": {
"type": "string",
"minLength": 1,
"maxLength": 63,
"pattern": "^[a-zA-Z_][a-zA-Z0-9_]*$"
},
"table": {
"type": "string",
"minLength": 1,
"maxLength": 63,
"pattern": "^[a-zA-Z_][a-zA-Z0-9_]*$"
}
},
"required": [
"schema"
],
"additionalProperties": false
} | — | — · — | — |
list_schemasList all schemas in the databaseInput schema{
"type": "object",
"properties": {
"includeSystemSchemas": {
"type": "boolean"
}
},
"additionalProperties": false
} | — | — · — | — |
list_tablesList all tables in a schemaInput schema{
"type": "object",
"properties": {
"schema": {
"type": "string",
"minLength": 1,
"maxLength": 63,
"pattern": "^[a-zA-Z_][a-zA-Z0-9_]*$"
}
},
"additionalProperties": false
} | — | — · — | — |
list_viewsList views in a schemaInput schema{
"type": "object",
"properties": {
"schema": {
"type": "string",
"minLength": 1,
"maxLength": 63,
"pattern": "^[a-zA-Z_][a-zA-Z0-9_]*$"
}
},
"additionalProperties": false
} | — | — · — | — |
queryExecute SQL queries with pagination support and parameterization for security. Supports page sizes up to 500 rows.Input schema{
"type": "object",
"properties": {
"sql": {
"type": "string",
"minLength": 1,
"maxLength": 50000
},
"parameters": {
"type": "array",
"items": {
"type": [
"string",
"number",
"boolean",
"null"
]
},
"description": "Optional array of parameters for parameterized queries"
},
"pageSize": {
"type": "number",
"minimum": 1,
"maximum": 500,
"description": "Number of rows to return (1-500, default: 100)"
},
"offset": {
"type": "number",
"minimum": 0,
"description": "Number of rows to skip for pagination"
}
},
"required": [
"sql"
],
"additionalProperties": false
} | — | — · — | — |