Explore

Explore Civic Data

Find datasets about any topic across multiple cities and present them in plain language.

Workflow

1. Determine city from the user's query. Default to NYC for this demo. If ambiguous, ask.

2. Search for datasets using the right MCP for the city:

   • NYC, Chicago, SF, Seattle, LA --> socrata search tool (domain auto-detected)
   • Boston --> boston search_datasets tool
   • Demographics or statistics for any city --> data-commons search_indicators with places array

3. Discover columns before querying. For every dataset found:

   • Socrata: get_data with SELECT * LIMIT 1 to see real column names
   • Boston: get_schema on the resource ID
   • Data Commons: columns come from the indicator metadata

4. from each relevant dataset to show what's actually in it.