Skip to main content
Glama

search_metadata

Search physical schema metadata by keyword to find table names, column names, and comments. Use exact substring matching when you know part of a name.

Instructions

按关键词搜索数据库的物理结构:表名、表注释、列名、列注释。适用于「我知道大概的表名或列名,帮我定位」这类需求,或者想看某张表的注释说明。 ★ 找变量请优先用 find_variables——它搜的是变量协调层(变量定义、问卷原文、值标签),带词干还原和相关性排序,对「有没有 xx 相关的变量」这类语义问题效果好得多。本工具搜的是物理结构,只做精确子串匹配,没有同义词和词干处理。

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
limitNo最多返回多少条命中
schemaNo限定只在某个 schema 内搜索
keywordYes搜索关键词,建议用英文单词,如 income / education / age

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault

No arguments

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observedv0.1.0

TDQS

A4.4/5.0
Behavior4/5

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

With no annotations, the description carries the burden and does disclose the key behavioral trait: matching is exact substring only, with no synonyms or stemming, unlike find_variables. It doesn't cover auth/permission needs, but the output schema exists and return shape is not its job. Solid disclosure of the most decision-relevant behavior.

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 purpose before the guidance note, and the two sentences each carry information. The starred alternative note is longer but earns its place by preventing misuse against find_variables.

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

Completeness5/5

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

An output schema exists so return values needn't be explained, and the description covers scope, matching limitations, and the alternative tool. For a 3-parameter search tool this is complete.

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 limit and schema are fully documented in the schema already, establishing a baseline of 3. The description adds only a hint about keyword content (English words), which the schema also states, so little value beyond structured fields.

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?

States a specific verb and resource (keyword search over physical structure: table names, table comments, column names, column comments) and explicitly contrasts itself with find_variables. An agent can distinguish this from list_tables, describe_table, and find_variables without opening any schema.

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

Usage Guidelines5/5

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

Gives both when-to-use ('I roughly know the table/column name, help me locate', or view a table's comment) and when-not-to-use, naming the sibling find_variables and explaining what that tool searches instead. It even explains why find_variables is better for semantic queries (stemming, relevance ranking).

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