MCP Postgres Server

Overview InspectNew Schema Related Servers Reviews Score

explain_query

Analyze PostgreSQL query execution plans using EXPLAIN. Input SQL queries to retrieve detailed insights in text, JSON, XML, or YAML formats for better query optimization and performance tuning.

Instructions

Get query execution plan (EXPLAIN)

Input Schema

Name	Required	Description	Default
`analyze`	No
`buffers`	No
`costs`	No
`format`	No
`sql`	Yes

Input Schema (JSON Schema)

{
  "additionalProperties": false,
  "properties": {
    "analyze": {
      "type": "boolean"
    },
    "buffers": {
      "type": "boolean"
    },
    "costs": {
      "type": "boolean"
    },
    "format": {
      "enum": [
        "text",
        "json",
        "xml",
        "yaml"
      ],
      "type": "string"
    },
    "sql": {
      "maxLength": 50000,
      "minLength": 1,
      "type": "string"
    }
  },
  "required": [
    "sql"
  ],
  "type": "object"
}

Install Server

HTTP connection URL

Related Tools

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/MadeByNando/mcp-postgres-server'

If you have feedback or need assistance with the MCP directory API, please join our Discord server