Postgres MCP

by crystaldba
Verified

analyze_workload_indexes

Identify frequently executed database queries and provide recommendations for optimal indexing to improve query performance and database efficiency.

Instructions

Analyze frequently executed queries in the database and recommend optimal indexes

Input Schema

NameRequiredDescriptionDefault
max_index_size_mbNoMax index size in MB

Input Schema (JSON Schema)

{ "properties": { "max_index_size_mb": { "default": 10000, "description": "Max index size in MB", "title": "Max Index Size Mb", "type": "integer" } }, "title": "analyze_workload_indexesArguments", "type": "object" }

You must be authenticated.

Other Tools from Postgres MCP

Related Tools

ID: ecl7vgkzit