Skip to main content
Glama

Buscar un valor en una tabla

lookup-table
Read-onlyIdempotent

Busca una clave en una tabla (objeto o lista de pares clave/valor) y devuelve su valor o un valor por defecto, con coincidencia opcional sin mayúsculas ni tildes. Cuándo: hay que transformar, comparar o revisar con exactitud datos estructurados (JSON, CSV, YAML, XML, arreglos). No para: leer el valor en una ruta como /clientes/0/nit dentro de un documento JSON con la sintaxis RFC 6901 (json-pointer-get). Efectos secundarios: ninguno (solo lectura, sin red, sin estado guardado). Determinista: la misma entrada da la misma salida. Límites: entrada JSON de hasta 64 KB, 1 s por llamada, resultado de hasta 1 MB.

EN: Maps a key to a value through a lookup table (object or list of key/value pairs) with an optional default, case- and accent-insensitive matching and trimming; reports whether the key was found and which table key matched. When: structured data (JSON, CSV, YAML, XML, arrays) has to be transformed, compared or checked exactly. [EN completo / full EN: inputSchema.description]

Input Schema

NameRequiredDescriptionDefault
keyYesKey to look up (string, number, boolean or null; compared as text) (string or number or boolean or null; required; up to 1000 chars).
trimNoTrim surrounding whitespace before comparing (boolean; optional; default true).
matchNoexact, case-insensitive, or case- and accent-insensitive (optional; one of: exact, case, case_accents; default "exact").exact
pairsNoAlternative to table: list of {key, value} (keeps order, allows any key text) (array of object; optional).
tableNoLookup table: object of key -> value (object; optional).
defaultNoValue when the key is not found (default null) (any JSON value; optional).

Output Schema

NameRequiredDescriptionDefault
foundNo
valueNoany JSON value
matched_keyNo

Schema Changelog

Changes observed during successful MCP inspections.

  1. Changed1 schema field changed
    • addedInput schema / properties / key / examples
      Added value: +[
      +  "bogota"
      +]
  2. Added

TDQS

A4.6/5.0
Behavior5/5

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

Beyond the annotations (readOnlyHint, idempotentHint, openWorldHint=false), the description adds the operational envelope an agent needs: no side effects, no network, no stored state, determinism, and hard limits of 64 KB input, 1 s per call and 1 MB result. These limits and the determinism guarantee are not obtainable from the annotations and directly affect whether the tool is safe to call on large payloads.

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?

The label-segmented structure (Cuándo / No para / Efectos secundarios / Determinista / Límites) is strongly front-loaded and each segment earns its place. The appended partial English restatement, which trails off into a pointer to inputSchema.description, is redundant filler that dilutes the otherwise tight framing.

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?

With six parameters including a nested pairs array, rich annotations and a dedicated output schema, the description covers everything the schema cannot: cost limits, determinism, absence of side effects, and the distinction from json-pointer-get. Return-value detail is correctly left to the output schema.

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 parameter baseline is 3. The description recaps the salient behaviors (optional default, case- and accent-insensitive matching, trimming, reporting whether the key was found and which table key matched) but adds no syntax, precedence or edge-case detail beyond the schema, e.g. what happens when both table and pairs are supplied.

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 names a specific verb+resource (mapping a key to a value through a lookup table) and enumerates the two supported table shapes (object or list of key/value pairs). It explicitly rules out a sibling by name, json-pointer-get, so an agent can route correctly without opening a 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?

It has an explicit 'Cuándo' clause (exact transform/compare/check of structured data such as JSON, CSV, YAML, XML, arrays) and an explicit 'No para' clause that names the alternative tool json-pointer-get and the scenario it serves. Both the positive trigger and the exclusion are present.

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

Try in Browser

Glama MCP Gateway

Add one secure layer between your agents and this server.

Resources