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
} | — | | — |