Labsco
MCP SERVER

OpenGov MCP Server

by srobbin

Query a city's open data portal in SoQL — select, where, group, having, order — and get the rows back without downloading a dataset.

Government, Legal & Legislative RecordsVerified
Summary
The whole server is one tool, and it behaves like a query console on a city's data.

get_data takes SoQL clauses directly, so filtering and aggregation happen at the portal instead of after the rows arrive. When building a query clause by clause gets awkward, soqlQuery accepts a complete one, and q covers plain text search. DATA_PORTAL_URL sets the portal, while domain and datasetId aim an individual call.

What it is

A single-tool front end to a city open data portal, reaching both the data and the metadata that describes it.

What you get
  • Data and metadata access through get_data, aimed by datasetId and domain.
  • Filtering and aggregation carried out at the portal through select, where, group, having and order, with limit and offset for paging.
  • Free-text lookup through q, or a complete query handed over as soqlQuery when clause-by-clause construction is not enough.
Requirements

DATA_PORTAL_URL, set to the open data portal you want to query. No account or key beyond that.

Setup effort

One command — npx -y opengov-mcp-server@latest