Postgres MCP

MIT License

1,059

Overview InspectNew Endpoints Schema Related Servers Reviews Score

analyze_query_indexes

Evaluate up to 10 SQL queries and recommend optimal indexes for improved query performance, considering user-defined constraints like maximum index size.

Instructions

Analyze a list of (up to 10) SQL queries and recommend optimal indexes

Input Schema

Name	Required	Description	Default
`max_index_size_mb`	No	Max index size in MB
`queries`	Yes	List of Query strings to analyze

Input Schema (JSON Schema)

{
  "properties": {
    "max_index_size_mb": {
      "default": 10000,
      "description": "Max index size in MB",
      "title": "Max Index Size Mb",
      "type": "integer"
    },
    "queries": {
      "description": "List of Query strings to analyze",
      "items": {
        "type": "string"
      },
      "title": "Queries",
      "type": "array"
    }
  },
  "required": [
    "queries"
  ],
  "title": "analyze_query_indexesArguments",
  "type": "object"
}

This server cannot be installed

Related Tools

suggest_query_optimizations
@rickyb30/datapilot-mcp-server
analyze_workload_indexes
@crystaldba/postgres-mcp
list_indexes
@c0h1b4/mssql-mcp-server
create_index
@amineelkouhen/mcp-cockroach
analyze-missing-indexes
@PuroDelphi/mcpFirebird
create_index
@EvilPhatBoi/McpSqlServer

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/crystaldba/postgres-mcp'

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