query

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
`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"
}

Postgres MCP Server

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from Postgres MCP Server

Related Tools

MCP directory API