query
Execute SQL queries with transaction support, analyze performance, validate syntax, and monitor active queries in PostgreSQL databases.
Instructions
Execute SQL queries with transaction support, query analysis, and performance monitoring
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| action | Yes | Action: execute (single query), transaction (multiple queries), explain (execution plan), analyze (performance), validate (syntax), cancel (query by PID), active (list active queries) | |
| options | No | Query execution options | |
| parameters | No | Query parameters for parameterized queries | |
| pid | No | Process ID of query to cancel (required for cancel action) | |
| queries | No | Array of queries for transaction action | |
| sql | No | SQL query to execute (required for execute, explain, analyze, validate actions) |
Input Schema (JSON Schema)
{
"properties": {
"action": {
"description": "Action: execute (single query), transaction (multiple queries), explain (execution plan), analyze (performance), validate (syntax), cancel (query by PID), active (list active queries)",
"enum": [
"execute",
"transaction",
"explain",
"analyze",
"validate",
"cancel",
"active"
],
"type": "string"
},
"options": {
"description": "Query execution options",
"properties": {
"limit": {
"description": "Maximum number of rows to return",
"type": "integer"
},
"offset": {
"description": "Number of rows to skip",
"type": "integer"
},
"readOnly": {
"description": "Execute as read-only transaction",
"type": "boolean"
},
"timeout": {
"description": "Query timeout in milliseconds",
"type": "integer"
}
},
"type": "object"
},
"parameters": {
"description": "Query parameters for parameterized queries",
"items": {
"type": "string"
},
"type": "array"
},
"pid": {
"description": "Process ID of query to cancel (required for cancel action)",
"type": "integer"
},
"queries": {
"description": "Array of queries for transaction action",
"items": {
"properties": {
"parameters": {
"items": {
"type": "string"
},
"type": "array"
},
"sql": {
"type": "string"
}
},
"required": [
"sql"
],
"type": "object"
},
"type": "array"
},
"sql": {
"description": "SQL query to execute (required for execute, explain, analyze, validate actions)",
"type": "string"
}
},
"required": [
"action"
],
"type": "object"
}