query
Run SELECT queries on PostgreSQL databases securely using SQL commands and parameters. Explore schemas, analyze data, and retrieve results efficiently with this MCP tool.
Instructions
Execute a SELECT query
Input Schema
Name | Required | Description | Default |
---|---|---|---|
params | No | Query parameters (optional) | |
sql | Yes | SQL SELECT query (use $1, $2, etc. for parameters) |
Input Schema (JSON Schema)
{
"properties": {
"params": {
"description": "Query parameters (optional)",
"items": {
"type": [
"string",
"number",
"boolean",
"null"
]
},
"type": "array"
},
"sql": {
"description": "SQL SELECT query (use $1, $2, etc. for parameters)",
"type": "string"
}
},
"required": [
"sql"
],
"type": "object"
}