Skip to main content
Glama

Postgres MCP

by crystaldba

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

NameRequiredDescriptionDefault
max_index_size_mbNoMax index size in MB
queriesYesList 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" }
Install Server

Other Tools from Postgres MCP

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

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