Skip to main content
Glama

Airtable

by io.github.pipeworx-io

Resolve Entity

resolve_entity
Read-onlyIdempotent

"What's the ticker for…" / "find the CIK for…" / "what's the LEI for…" / "what's the RxCUI for…" / "look up the ID for…" / "what is X's official identifier" / "who owns X" / "is X a subsidiary of Y" — resolve a user-spoken NAME to the canonical/official identifiers other tools require as input. Use FIRST whenever you have a name but need an ID. SUPPORTED TYPES: "company" (cross-source identity spine: 10-digit CIK + ticker + company_name from SEC EDGAR, legal-entity LEI from GLEIF with parent/ultimate-parent/children ownership when the LEI resolves, and security FIGI from OpenFIGI — by exact ticker map when a ticker is implied, and otherwise by name search, so NON-EQUITY instruments that never have a ticker (municipal and corporate bonds, notes, authority debt) DO resolve here; when a name matches more than one instrument it asserts nothing and returns figi_candidates to pick from, which is the correct answer to an issuer name that does not identify a single bond; every identifier is labelled with the source that established it, and an identifier that could NOT be resolved is stated explicitly under unresolved rather than omitted — accepts ticker, CIK, ISIN, or company name as input; an ISIN like "CH0038863350" resolves to the LEGAL ENTITY that issued the security via the GLEIF ISIN-to-LEI mapping, covering non-US issuers EDGAR cannot reach), "drug" (returns RxCUI + ingredient + brand from RxNorm + pipeworx://rxnorm/concept/{rxcui} citation; accepts brand or generic name). LEI/FIGI enrichment degrades gracefully — if GLEIF or OpenFIGI is unavailable, the EDGAR identifiers still return. Each call cascades through several lookup endpoints internally — using resolve_entity replaces 2-3 manual lookups.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
typeYesEntity type: "company" or "drug".
valueYesFor company: ticker (AAPL), CIK (0000320193), or name. For drug: brand or generic name (e.g., "ozempic", "metformin"). Pass the ENTITY NAME ONLY — for a bond that is the ISSUER exactly as printed ("NEW YORK ST DORM AUTH"), never the question's full noun phrase ("NEW YORK ST DORM AUTH revenue bonds"): the FIGI lookup matches instrument names, so trailing security-class words match nothing.

Schema Changelog

Changes observed during successful MCP inspections. Dates show when Glama detected each change.

  1. Changed1 schema field changed
    • changedInput schema / properties / value / description
      Previous value: -"For company: ticker (AAPL), CIK (0000320193), or name. For drug: brand or generic name (e.g., \"ozempic\", \"metformin\")."New value: +"For company: ticker (AAPL), CIK (0000320193), or name. For drug: brand or generic name (e.g., \"ozempic\", \"metformin\"). Pass the ENTITY NAME ONLY — for a bond that is the ISSUER exactly as printed (\"NEW YORK ST DORM AUTH\"), never the question's full noun phrase (\"NEW YORK ST DORM AUTH revenue bonds\"): the FIGI lookup matches instrument names, so trailing security-class words match nothing."
  2. Changed3 schema fields changed
    • changedInput schema / properties / type / description
      Previous value: -"Entity type. v1 supports \"company\"."New value: +"Entity type: \"company\" or \"drug\"."
    • changedInput schema / properties / type / enum
      Previous value: -[
-  "company"
-]New value: +[
+  "company",
+  "drug"
+]
    • changedInput schema / properties / value / description
      Previous value: -"Ticker, CIK, or company name (e.g., \"AAPL\", \"0000320193\", \"Apple\")."New value: +"For company: ticker (AAPL), CIK (0000320193), or name. For drug: brand or generic name (e.g., \"ozempic\", \"metformin\")."
  3. Added

TDQS

A4.4/5.0
Behavior5/5

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

Annotations already declare read-only/idempotent/non-destructive, and the description adds meaningful behavior: multi-endpoint cascading, graceful degradation when GLEIF/OpenFIGI are unavailable, figi_candidates on ambiguity, and explicit unresolved reporting. No contradiction with annotations.

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, usage trigger, and supported types, and every detail earns its place. However, it is one dense unstructured block with long nested clauses that would benefit from bullets or shorter sentences.

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?

Covers what is returned (identifiers, labels, figi_candidates, unresolved list, RxCUI citation), how ambiguity is handled, and how enrichment failures degrade. Even without an output schema, an agent can predict tool behavior accurately.

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 coverage is 100%, with the input schema already explaining type and value formats and the entity-name-only rule. The description reinforces examples and adds ISIN-to-LEI context, but it does not substantially exceed the schema, so baseline 3 applies.

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?

Clearly identifies a specific action (resolve a spoken name to canonical identifiers) and the resources (CIK/ticker/LEI/FIGI/RxCUI), and positions itself as the first lookup for IDs other tools need. This differentiates it from sibling profile/comparison tools like entity_profile or compare_entities.

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?

Gives an explicit trigger: 'Use FIRST whenever you have a name but need an ID,' and details accepted input forms for both entity types. It does not explicitly name alternatives or when-not-to-use conditions, so it stops short of a 5.

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

All Airtable toolsInspect
Try in Browser
RayrunBuild, deploy, and operate MCP servers without becoming an infrastructure team.ray.runAd

Glama MCP Gateway

Add one secure layer between your agents and this server.

TDQS

A3.5/5.0
Disambiguation2/5

The Airtable tools are distinct, but the set is dominated by a large Pipeworx research family with multiple near-identical entries (ask_pipeworx, ask_pipeworx_beta, ask_pipeworx_grounded) and several overlapping prediction-market tools (bet_research, polymarket_edges, polymarket_arbitrage). An agent would frequently struggle to pick the right tool among the many data-lookup and research options, especially given the server is supposedly named Airtable.

Naming Consistency2/5

Naming conventions are mixed: some tools use verb_noun snake_case (airtable_create_record, list_subscriptions, resolve_entity), while others use domain-prefixed names (pipeworx_feedback, polymarket_edges) or bare verbs (remember, forget, recall, subscribe). There is no single predictable pattern across the set.

Tool Count2/5

36 tools is heavy for any single server's scope, and the mismatch is worse because the server is named Airtable yet only 5 of 36 tools relate to Airtable. The rest form an unrelated Pipeworx/Polymarket/memory grab-bag, suggesting poor scoping and no clear purpose for the set as a whole.

Completeness2/5

For the stated Airtable domain, the surface is incomplete: records can be created, fetched, and listed, but there is no update_record or delete_record. For the broader Pipeworx/prediction-market domain the coverage is extensive but unfocused, and given the server's name the Airtable gap is glaring.

Resources