Skip to main content
Glama
lm203688

MySQL MCP Server

Get Table Sample

get_table_sample

Retrieve sample rows from a specified table in a MySQL database to quickly understand its data content. Optionally set the row limit up to 100.

Instructions

获取表的样本数据(默认前5行),快速了解数据内容

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
limitNo返回行数,默认5,最大100
tableYes表名称
databaseYes数据库名称

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault
resultYes

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observedv0.1.0

TDQS

A3.8/5.0
Behavior3/5

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

No annotations are present, so the description carries the full burden. It discloses the default 5-row limit but does not address ordering guarantees, read-only nature explicitly, or behavior beyond the limit. For a sampling tool, this is minimal but not misleading.

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 one concise Chinese sentence, front-loads the action, and includes the default behavior. There is no wasted wording or redundancy.

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 an output schema and 100% parameter coverage, the description is complete for a simple sample tool. The only notable gap is the absence of explicit guidance on ordering or when to prefer this over query, but this is minor given the tool's simplicity.

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%, with all three parameters (database, table, limit) already described. The description only repeats the default limit value and adds no extra parameter-level meaning beyond the schema.

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 '获取表的样本数据' (get sample data of a table) with a specific default of '前5行' (first 5 rows). This distinguishes it from siblings like query (custom queries) and describe_table (schema information).

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 phrase '快速了解数据内容' implies a quick-preview use case, but it does not explicitly state when to use this tool over query or describe_table, nor does it mention exclusions or alternatives.

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