Postgres MCP

MIT License

228

Overview InspectNew Schema Related Servers Reviews Score

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

Name	Required	Description	Default
`max_index_size_mb`	No	Max 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"
}

Install Server

HTTP connection URL

Related Tools

analyze_query_indexes
@crystaldba/postgres-mcp
optimize_sql
@madhukarkumar/singlestore-mcp-server
analyze-missing-indexes
@PuroDelphi/mcpFirebird
get-execution-plan
@PuroDelphi/mcpFirebird
databases_create_index
@appwrite/mcp
get_table_index
@wenb1n-dev/mysql_mcp_server_pro

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