Database performance is improved by identifying the slowest tables and implementing suggested indexes to reduce query times.
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.
- Category: Operations and infrastructure
- Effect: Changes data in your accounts
- MCP servers: Aderlo Cloud MCP (https://koskamo.com/explore/aderlo-cloud-mcp)
- Source: Aderlo Cloud MCP documentation (https://aderlo.cloud/mcp)
- Source quote: "“Show the 10 slowest tables in the store database and suggest indexes.”"
- Playbook page: https://koskamo.com/explore/use-cases/optimize-slow-database-tables
Prompt: Show the 10 slowest tables in the store database and suggest indexes.