My home city of Philadelphia, PA makes various datasets related to city housing, crime, traffic, and bureaucracy publicly available. I discovered that the data is all accessible via a Carto REST API, and that the queries are in SQL.

I (vibe)coded this small local web application to let you easily query the datasets and view and download the results.

Check it out here:

https://matthewbilyeu.com/phila-data-explorer/

If I find some time I’d like to make an mcp server for it as well.