Skip to main content
Glama

Airtable

by io.github.pipeworx-io

Entity Profile

entity_profile
Read-onlyIdempotent

"Tell me about X" / "research Acme" / "brief me on Tesla" / "what does Apple do" / "company profile for Microsoft" / "give me the rundown on NVDA" / "everything you know about $TICKER" — full cross-source profile of a US public company in ONE parallel call. ALWAYS PREFER over chaining single-pack SEC/XBRL/news lookups when the user asks for a holistic view. Fans out across SEC EDGAR, XBRL, USPTO patents, federal contracts (USAspending), FDA-licensed biologics (Purple Book), H-1B hiring (DOL LCA), news and GLEIF, and returns: cik + company_name (+ resolved_from/resolved_to when value was a name); recent_filings (up to 5 with pipeworx://edgar/company/{cik}/filings/{accession} URIs); fundamentals (LATEST 10-K Revenues + NetIncomeLoss + Cash, sorted period_end DESC); patents (USPTO PatentsView API sunset May 2025 — soft-fails until reactivated); federal_contracts (USAspending awards where the company is the recipient); fda_products (FDA-licensed biologics — vaccines, cell/gene therapies — from the Purple Book; a company with only small-molecule/generic drugs will show none here, that is expected, not a failure); hiring (H-1B sponsorship volume + salary range from DOL LCA filings); recent news mentions via GDELT→GNews fallback; LEI via GLEIF. sources_used / sources_failed say which of these actually returned data for THIS company — an empty section is a real "no data", not a bug. Pass a ticker ("AAPL"), zero-padded CIK ("0000320193"), OR a company name ("Moderna") — names now resolve via SEC EDGAR's company-name match; a private company (no CIK/ticker) returns resolved:false with an explicit notes line, not a bare failure. type accepts "company" or "ticker" interchangeably — both take the same value shapes above.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
typeYes"company" or "ticker" — both are accepted and behave identically; `value` can be a ticker, CIK, or company name either way. person/place coming soon.
valueYesTicker (e.g., "AAPL"), zero-padded CIK (e.g., "0000320193"), or company name (e.g., "Moderna") — names resolve via SEC EDGAR company-name match.

Schema Changelog

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

  1. Changed3 schema fields changed
    • changedInput schema / properties / type / description
      Previous value: -"Entity type. Only \"company\" supported today; person/place coming soon."New value: +"\"company\" or \"ticker\" — both are accepted and behave identically; `value` can be a ticker, CIK, or company name either way. person/place coming soon."
    • changedInput schema / properties / type / enum
      Previous value: -[
-  "company"
-]New value: +[
+  "company",
+  "ticker"
+]
    • changedInput schema / properties / value / description
      Previous value: -"Ticker (e.g., \"AAPL\") or zero-padded CIK (e.g., \"0000320193\"). Names not supported — use resolve_entity first if you only have a name."New value: +"Ticker (e.g., \"AAPL\"), zero-padded CIK (e.g., \"0000320193\"), or company name (e.g., \"Moderna\") — names resolve via SEC EDGAR company-name match."
  2. Added

TDQS

A4.5/5.0
Behavior5/5

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

Annotations already declare readOnly, openWorld, idempotent, and non-destructive. The description adds substantial behavior beyond that: it fans out across multiple sources in parallel, soft-fails for the USPTO sunset, reports sources_used/sources_failed, treats empty sections as real 'no data', and resolves names via SEC EDGAR. This is exemplary transparency for an agent.

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 description is long and dense, but the tool is complex and nearly every clause carries behavioral or parameter information. It front-loads the core purpose and usage preference before enumerating sources and return fields. It could be improved with bulleted structure, but it is not padded or repetitive.

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?

For a tool with no output schema and only two parameters, the description fully compensates by enumerating every return section, source, failure behavior, input resolution path, and expected empty case (e.g., FDA products for small-molecule-only companies). An agent has enough context to call this tool correctly and interpret its result without further lookups.

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

Parameters5/5

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

Schema coverage is 100%, so the baseline is 3, but the description adds major semantic value: it gives concrete value examples ('AAPL', '0000320193', 'Moderna'), explains that type is interchangeable between 'company' and 'ticker', clarifies zero-padded CIK formatting, and describes what happens for private companies. This meaningfully exceeds the schema alone.

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?

The description clearly states the tool's function: 'full cross-source profile of a US public company in ONE parallel call', with concrete example phrasings and input shapes. It is easily distinguished from general lookup tools, but it does not explicitly differentiate from sibling tools like compare_entities or resolve_entity, so it stops just short of a 5.

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?

It gives explicit guidance: 'ALWAYS PREFER over chaining single-pack SEC/XBRL/news lookups when the user asks for a holistic view.' This tells an agent when to reach for this tool and what to prefer it over. It does not spell out when to use alternatives such as compare_entities or ask_pipeworx instead, so exclusion guidance is incomplete.

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