df3aa2f9a1896ce5e43dca9dc0f5d9566f7f8effsource_git · longgoll/mcp-postgresql-server · current release
Observed 2026-08-25T11:05:22.270Z using mcpSecurity-inventory. Status: partial. Negotiated protocol: 2025-06-18.
{
"tools": {},
"resources": {}
}| Tool | Category | Annotations | Risk |
|---|---|---|---|
describe_tableGet schema information for a tableInput schema{
"type": "object",
"properties": {
"table_name": {
"type": "string"
},
"database": {
"type": "string",
"description": "Optional database name to query"
}
},
"required": [
"table_name"
]
} | — | — · — | — |
explain_queryGet the execution plan for a query (EXPLAIN)Input schema{
"type": "object",
"properties": {
"sql_query": {
"type": "string"
},
"database": {
"type": "string",
"description": "Optional database name to query"
}
},
"required": [
"sql_query"
]
} | — | — · — | — |
list_constraintsList constraints (PK, FK, Unique, Check) for a specific tableInput schema{
"type": "object",
"properties": {
"table_name": {
"type": "string"
},
"database": {
"type": "string",
"description": "Optional database name to query"
}
},
"required": [
"table_name"
]
} | — | — · — | — |
list_indexesList indexes for a specific tableInput schema{
"type": "object",
"properties": {
"table_name": {
"type": "string"
},
"database": {
"type": "string",
"description": "Optional database name to query"
}
},
"required": [
"table_name"
]
} | — | — · — | — |
list_tablesList all tables and views in the database (includes schema information)Input schema{
"type": "object",
"properties": {
"database": {
"type": "string",
"description": "Optional database name to query"
}
}
} | — | — · — | — |
run_modification_queryExecute a modification SQL query (INSERT, UPDATE, DELETE, etc.)Input schema{
"type": "object",
"properties": {
"sql_query": {
"type": "string"
},
"database": {
"type": "string",
"description": "Optional database name to query"
}
},
"required": [
"sql_query"
]
} | — | — · — | — |
run_read_only_queryExecute a read-only SQL query (SELECT)Input schema{
"type": "object",
"properties": {
"sql_query": {
"type": "string"
},
"database": {
"type": "string",
"description": "Optional database name to query"
}
},
"required": [
"sql_query"
]
} | — | — · — | — |
search_in_tableSearch for a text string in all text columns of a tableInput schema{
"type": "object",
"properties": {
"table_name": {
"type": "string"
},
"search_term": {
"type": "string"
},
"database": {
"type": "string",
"description": "Optional database name to query"
}
},
"required": [
"table_name",
"search_term"
]
} | — | — · — | — |