Skip to main content
Glama

NYC Open Data

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.

TDQS

A4.5/5.0
Behavior5/5

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

Annotations already mark it readOnly, openWorld, idempotent, and non-destructive, and the description adds significant behavioral detail beyond those hints: identifiers that cannot be resolved are listed under `unresolved`, ambiguous FIGI matches return `figi_candidates`, and LEI/FIGI enrichment degrades gracefully if GLEIF or OpenFIGI is unavailable. Nothing contradicts the annotations.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness2/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is extremely long and organized as one dense paragraph with deep nested parentheticals, making it hard to scan. While nearly every fact is technically informative, the structure is not appropriately sized for an agent that needs to quickly extract when/how to invoke the tool.

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?

Despite having no output schema, the description explains what is returned for each entity type, labels identifiers by source, discloses ambiguity behavior, covers input formats, and notes cross-source fallback behavior. An agent has enough detail to call the tool correctly and interpret common outcomes.

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 description coverage is 100%, and the description still adds meaningful semantics: company accepts ticker, CIK, ISIN, or name; drug accepts brand or generic; ISIN resolves to the issuing legal entity; and for bonds the value must be the issuer name only, with explicit guidance that trailing security-class words will fail. This materially helps the agent construct correct calls.

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 states a specific purpose: resolving user-spoken names to canonical/official identifiers (CIK, ticker, LEI, RxCUI, FIGI) that other tools require as input. It opens with concrete example queries and clearly distinguishes the tool from lookalike siblings by emphasizing it is the first step when a name needs an ID.

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?

The description gives clear usage context: 'Use FIRST whenever you have a name but need an ID,' and details accepted inputs (ticker, CIK, ISIN, company name, brand/generic drug name). It does not explicitly discuss when not to use it or name alternative sibling tools, 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 NYC Open Data 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.7/5.0
Disambiguation2/5

Several tools have heavily overlapping purposes: ask_pipeworx, ask_pipeworx_beta, and ask_pipeworx_grounded are nearly identical routers, and the five polymarket_* tools all perform prediction-market analysis. Even with detailed descriptions, an agent could easily select the wrong one, especially since the server name 'NYC Open Data' does not hint at this focus.

Naming Consistency4/5

Most tools follow a consistent lowercase snake_case verb_noun pattern (e.g., list_subscriptions, generate_llms_txt, resolve_entity) and families share prefixes like polymarket_ and pipeworx_. Minor deviations exist with one-word names like datasets, metadata, and forget, but overall the naming is readable and predictable.

Tool Count2/5

34 tools is far too many for a server labeled 'NYC Open Data,' where only 3 tools (datasets, metadata, query) actually serve that purpose. The rest form a general-purpose data platform, but even then the count is high and includes many redundant meta-tools and overlapping Polymarket utilities, making the set feel bloated.

Completeness3/5

For the NYC Open Data domain, the three dedicated tools cover search, metadata, and query—adequate core functionality but missing export or dataset management capabilities. For the broader Pipeworx platform, coverage is strong (routing, grounded answers, deep research, entity profiles, subscriptions, memory), but the severe mismatch between the server name and actual scope leaves a major completeness gap.

Resources