Skip to main content
Glama

NYC Open Data

by io.github.pipeworx-io

Query

query
Read-onlyIdempotent

Run a Socrata SoQL query against a NYC Open Data dataset by resource_id (e.g. "8wbx-tsch"). Filter with where/select/group/order (SoQL clauses, without the leading $) plus limit/offset. Returns matching rows as JSON.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
groupNoSoQL $group column(s).
limitNoMax rows (default Socrata 1000).
orderNoSoQL $order, e.g. "date DESC".
whereNoSoQL $where filter, e.g. "year >= 2020 AND status = 'Active'".
offsetNoPagination offset.
selectNoSoQL $select, e.g. "name, count(*) AS n".
resource_idYesDataset id, e.g. "8wbx-tsch" (from datasets).

TDQS

A4.4/5.0
Behavior4/5

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

Annotations already declare readOnlyHint=true and idempotentHint=true. The description adds that it returns JSON rows. No contradiction. Could mention default limit or error handling.

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

Conciseness5/5

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

One sentence that front-loads the action and key parameters. No wasted words, appropriately sized.

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

Completeness4/5

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

Given 7 parameters and no output schema, the description covers the essential: what it does, how to filter, return format. It could add more about dataset ID guidance or error behavior.

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

Parameters4/5

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

Schema coverage is 100%, so each parameter already has a description. The description adds valuable context that SoQL clauses should be without the leading $, which goes beyond the schema.

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 clearly states 'Run a Socrata SoQL query against a NYC Open Data dataset by resource_id'. It specifies the verb (run), resource (dataset), and key parameter (resource_id), and distinguishes the tool from siblings like 'datasets' or 'search_within' by focusing on SoQL querying.

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 mentions filtering with SoQL clauses and pagination. While it provides context for usage, it does not explicitly state when not to use this tool or list alternative tools.

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