Skip to main content
Glama

analyze_workload_indexes

Read-only

Analyzes database workload to identify resource-intensive queries and recommend optimal indexes.

Instructions

Analyze the database workload to identify resource-intensive queries and recommend optimal indexes.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
top_nNoNumber of top queries to analyze.
database_nameNoOptional database name. Defaults to AZURE_SQL_DEFAULT_DATABASE.
window_minutesNoHow far back to look in Query Store, in minutes.

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault

No arguments

Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations already declare readOnlyHint=true and destructiveHint=false, so the safety profile is covered. The description adds behavioral context by explaining that the tool identifies resource-intensive queries and recommends indexes, which gives a clearer idea of what the analysis produces beyond what annotations state.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, front-loaded sentence that clearly communicates the tool's purpose without unnecessary words. It is concise and well-structured.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

With a complete parameter schema, annotations for read-only safety, and an output schema present, the description is adequately complete for a read-only analysis tool. It could be slightly more explicit about how it differs from similar index-related siblings, but the overall context is sufficient.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100% for all three parameters (top_n, database_name, window_minutes), each with its own description. The tool description does not add parameter-specific meaning beyond what the schema already provides, so the baseline of 3 applies.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool's function: analyze the database workload, identify resource-intensive queries, and recommend optimal indexes. It uses a specific verb and resource, and distinguishes from siblings like analyze_query_indexes by focusing on workload-level analysis.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines3/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description implies usage for workload-level index analysis (e.g., when you need to analyze the overall database workload), but it does not explicitly state when to use this tool versus alternatives like analyze_index_recommendations or optimize_indexes. No exclusions or alternative guidance is provided.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Install Server

Other Tools

Latest Blog Posts

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/akaalholdings/azure-sql-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server