mysql_index_suggestions

MCP tool from Infrawise by Sidd27

Exact ALTER TABLE ADD INDEX SQL for your MySQL table

How to use it

mysql_index_suggestions is exposed by the Infrawise MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the mysql_index_suggestions tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.

Install Infrawise

$npx infrawise start --claude

FULL INFRAWISE LISTING

Other tools in Infrawise (21)

analyze_function

Issues in a specific function — scans, missing indexes, N+1, trigger event shapes, missing IAM permissions; returns every same-named file as a separate match

get_api_routes

API Gateway APIs (REST, HTTP, WebSocket) — routes, HTTP methods, paths, and Lambda integrations

get_cache_overview

ElastiCache clusters — engine, encryption in transit/at rest, replication group, failover, cost signal (data never read)

get_cloudfront_overview

CloudFront distributions — per-behavior path patterns, origins (S3 vs custom, resolved API Gateway name), cache policy, viewer protocol policy

get_cognito_overview

Cognito user pools — MFA config, app client auth flows, OAuth settings, token validity (secrets never included)

get_eventbridge_details

EventBridge rules — name, state, schedule/event pattern, target functions

get_graph_summary

Full infrastructure graph — all nodes, edges, and findings

get_infra_overview

Complete snapshot — services, counts, high-severity findings, configured flag (data age and per-source status ride the dataHealth block on every response)

get_lambda_overview

Lambda functions — runtime, memory, timeout, execution role ARN, triggers (SQS/SNS/DynamoDB/Kinesis/MSK/EventBridge/S3), env var key names, cost signal

get_log_errors

CloudWatch error patterns and counts (no raw log messages)

get_parameter_overview

SSM Parameter Store — names, types, tiers (values never included)

get_queue_details

SQS queues — DLQ status, encryption, FIFO type, visibility timeout, message counts

get_s3_overview

S3 buckets — versioning, encryption, public access, event notifications

get_secrets_overview

Secrets Manager — names, rotation status, and key names inferred from code (values never included)

get_stack_outputs

Stack outputs and cross-stack exports parsed from local IaC files, with staleness flags for orphaned cdk.out templates

get_stream_details

Kinesis streams (shards, retention, capacity mode) and MSK clusters (state, Kafka version, brokers)

get_table_schema

Column-level schema for named tables/collections — types, PKs, FKs, indexes, DynamoDB keys/billing mode, cost signal (no row data)

get_topic_details

SNS topics — subscription counts, protocols, and filter policies (required message attributes per subscription)

postgres_index_suggestions

Exact CREATE INDEX SQL for your actual table

suggest_gsi

Exact GSI config for a DynamoDB table + attribute — names the existing index instead when one already covers it

suggest_mongo_index

Exact createIndex command for a MongoDB collection + field