socrata-mcp-server

---

Tools

Six tools covering the full Socrata workflow — portal discovery, dataset search, schema inspection, SoQL querying, and DuckDB-powered analytical SQL over large result sets:

Tool	Description
socrata_list_portals	List known Socrata-powered government open-data portals with domain, organization name, and dataset count
socrata_find_datasets	Search for datasets across all Socrata portals or scope to one portal via the Discovery API
socrata_get_dataset	Fetch full metadata and typed column schema for a dataset by ID — required before writing SoQL queries
socrata_query_dataset	Execute a SoQL query against any dataset: search, select, where, group, having, order, with DataCanvas spillover
socrata_dataframe_describe	List registered tables in a DataCanvas session — schema, row count, column names
socrata_dataframe_query	Run SELECT-only SQL against DataCanvas tables populated by socrata_query_dataset

socrata_list_portals

List known Socrata-powered government open-data portals.

• Backed by the Discovery API domains catalog — hundreds of city, county, state, and federal portals
• Client-side substring filtering on domain or organization name
• Pagination (up to 200 per page) with offset
• Returns domain (pass to socrata_find_datasets), organization name, and dataset count
• Use this first when you don't know which portal to target

---

socrata_find_datasets

Search for datasets across all Socrata portals or scope to a single portal.

• Full-text search across dataset names and descriptions
• Scope to a single portal with the domain parameter
• Filter by category (e.g. ["Public Safety", "Transportation"]) and tags (e.g. ["covid19"])
• Asset type filtering: datasets, maps, files, calendars, stories
• Sort by relevance, page views, created date, or updated date
• Pagination (up to 100 per page) with offset
• Returns dataset IDs, names, abbreviated column previews, domains, and update timestamps
• Column names here are preview-only — call socrata_get_dataset for typed schema before writing queries
• Recovery hints on empty results — echoes applied filters and suggests how to broaden

---

socrata_get_dataset

Fetch full metadata and column schema for a Socrata dataset by ID.