Skip to main content
Glama

list_transactions

Read-only

List open InnoDB transactions sorted oldest first to find stuck transactions that cause lock waits or performance issues.

Instructions

[READ] Open InnoDB transactions, oldest first (stuck-transaction hunting).

Args: target: Target name from config; omit for the default.

Input Schema

NameRequiredDescriptionDefault
targetNo

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observedv0.5.0

TDQS

A3.6/5.0
Behavior3/5

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

Annotations already declare readOnlyHint=true and the '[READ]' tag reinforces it, so the safety profile is covered. The description contributes the ordering behavior ('oldest first'), which is genuinely useful, but says nothing about result limits, truncation, or whether the same transaction can appear across calls — gaps that matter for a monitoring tool.

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

Conciseness4/5

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

Front-loaded with the mode tag and the resource, then a compact Args block. Two lines carry the whole definition with no filler, though the Args formatting is slightly verbose for a single optional parameter.

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?

For a no-required-parameter, read-only listing tool with no output schema, the definition tells the agent what is returned (open transactions), in what order, and what the sole parameter means. It lacks detail on returned fields or result-size behavior, which keeps it from a 5.

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

Parameters4/5

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

Schema description coverage is 0%, so the schema only exposes a bare 'target' property with a null default. The description compensates by explaining that it is a target name from config and that omitting it uses the default, which is exactly the semantics an agent needs.

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

Purpose4/5

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

States a specific verb and resource (list open InnoDB transactions) plus meaningful scope qualifiers: 'oldest first' and the diagnostic intent 'stuck-transaction hunting'. It does not explicitly name which sibling to use instead, so it stops short of 5.

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 parenthetical '(stuck-transaction hunting)' implies the diagnostic scenario, but no explicit when-to-use/when-not or alternatives are given. An agent could reasonably wonder whether lock_waits, lock_wait_rca, or long_running_queries is the better starting point in the same situation.

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