Skip to main content
Glama
miningyu

Scouter MCP Server

by miningyu

Get SQL Analysis

get_sql_analysis
Read-onlyIdempotent

Identify slow SQL statements in a time range, with execution counts, errors, and average time, ranked by elapsed time to diagnose database performance issues.

Instructions

Analyze SQL performance within a time range. Returns SQL statements ranked by total elapsed time, showing execution counts, error counts, and average execution time. Use when investigating database-related performance issues.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
sort_byNoSort criteriaelapsed_sum
end_timeNoEnd time. Defaults to now.
obj_hashNoSpecific agent object hash. Overrides obj_type.
obj_typeNoObject type filter. Ignored if obj_hash is provided.
max_countNoMax SQL items to return (max 100)
start_timeNoStart time. Defaults to 1 hour ago.
Behavior4/5

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

Annotations already declare readOnlyHint=true, idempotentHint=true, and destructiveHint=false. The description adds behavioral context beyond annotations by specifying the output ranking, time-range scoping, and metrics returned. This is useful and not contradictory.

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 two sentences, front-loaded with the core function, followed by usage guidance. Every sentence earns its place with no redundancy or fluff.

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?

The tool has 6 optional parameters, no output schema, and good annotation coverage. The description explains the purpose, output content, and usage context. It does not describe all filter options (obj_hash, obj_type) but the schema covers them, so the description is sufficiently complete for a read-only list tool.

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%, so the schema fully documents each parameter. The description provides high-level context (time range, ranking, counts) that aligns with parameters like start_time, sort_by, and max_count, but it does not add detailed semantics beyond the schema. Baseline 3 is appropriate.

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 analyzes SQL performance within a time range and returns ranked SQL statements with execution counts, error counts, and average execution time. This specific verb+resource+scope distinguishes it from siblings like get_error_summary or get_counter_trend.

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

Usage Guidelines4/5

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

The description provides explicit context: 'Use when investigating database-related performance issues.' It does not name alternatives or exclusions, but the usage scenario is clear enough to guide tool selection among the sibling tools.

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/miningyu/scouter-mcp-server'

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