Optimize slow database tables
Database performance is improved by identifying the slowest tables and implementing suggested indexes to reduce query times.
How it works
Changes data in your accountsOperations and infrastructure
The agent connects to the hosting account's database and executes queries to identify the 10 slowest tables. It analyzes the schema and query patterns to suggest appropriate indexes. The agent then proposes or executes the SQL commands to add these indexes. Before acting, review the suggested indexes to ensure they do not negatively impact write performance or consume excessive storage.
Prompt
Paste this into an agent that has the servers below connected. Adjust the names and dates to your own.
Prompt for Optimize slow database tables
Show the 10 slowest tables in the store database and suggest indexes.MCP servers it needs
Source
The vendor page this playbook is drawn from, and the passage that supports it.
“Show the 10 slowest tables in the store database and suggest indexes.”Aderlo Cloud MCP documentation