Charlotte Open Data MCP Server
One-line summary: A read-only MCP server that answers everyday Charlotte questions — representatives, services, safety, zoning, transit, budgets — using official City of Charlotte / Mecklenburg County open data (accepting addresses or latitude,longitude).
Address profile —
get_address_profile: council member, county commissioner, CMPD division, fire station, trash/recycling/yard-waste days, zoning, FEMA flood zone, historic district, ZIP, parcel ID;lookup_addressvalidates addresses via the county master list.Trash & recycling —
get_trash_and_recycling_schedule: pickup days and whether it's a GREEN or ORANGE recycling week.Safety —
get_crime_near(CMPD incidents within a radius, filterable by offense/days),summarize_crime(citywide counts by offense, division, year, NPA, clearance),get_traffic_crashes_near(crashes by severity near a spot).City services & neighborhood change —
get_311_requests_near(potholes, streetlights, dumping),get_code_enforcement_cases(housing/nuisance/zoning/graffiti/parking),get_street_closures,get_capital_projects_near(phase, budget, PM contact),get_pending_rezonings.Places & transit —
find_nearby_places(18 categories: libraries, schools, parks, greenways, pharmacies, groceries, EV chargers, light rail, bus stops, public Wi-Fi…),get_bus_route(CATS frequency by time of day).Government transparency —
get_city_budget(by department/fund/expense category),get_city_salary_stats(aggregate pay by department or job title; no names).Generic catalog access —
search_datasets(keyword search over ~380 datasets),describe_dataset(fields/types/record count),query_dataset(SQL-filtered records, optionally near a location),summarize_dataset(server-side count/sum/min/max/avg/stddev grouped by up to 3 fields).Operational notes — every tool is read-only/idempotent; geocoding covers Mecklenburg County only; data freshness varies (budget currently FY2018–FY2023); CMPD locations are generalized; generic tools are limited to portal-serving hosts; no live CATS arrivals.
Provides read-only access to the City of Charlotte Open Data Portal's ArcGIS Hub site and ArcGIS REST layers, enabling search, dataset description, SQL-filtered queries, spatial queries, and summary statistics across Charlotte and Mecklenburg County public datasets.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Charlotte Open Data MCP Server when is trash pickup at 600 E 4th St?"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
Charlotte Open Data MCP Server
An MCP server that lets an LLM answer Charlotte residents' everyday questions with official public data from the City of Charlotte Open Data Portal — https://data.charlottenc.gov.
The portal lives at
data.charlottenc.gov. It is an ArcGIS Hub site; its ~380 datasets are ArcGIS REST layers run by the City of Charlotte and Mecklenburg County. No API key is required.
What's on the portal
A survey of the catalog (/api/feed/dcat-us/1.1.json) shows these main themes:
Theme | Examples |
Public safety | CMPD incidents (870k+ since 2017, updated daily), homicides, traffic stops, fire incident reports, crashes |
City services | 311 service requests (3.4M), solid-waste collection routes, code enforcement cases, street closures |
Planning & zoning | Zoning, rezoning petitions, historic districts, 2040 policy map, floodplains, parcels |
Transportation | CATS bus routes and stops, LYNX light rail, park-and-ride, bike lanes, sidewalks, greenways |
Places | Libraries, schools, parks, fire/police stations, pharmacies, grocery stores, EV chargers, day care |
Government | Capital projects, budget, employee salaries, council and commissioner districts |
Demographics | Census block groups/tracts, Quality of Life neighborhood profiles |
Related MCP server: mcp-arcgis-raleigh
Tools
The tools are chosen for the questions residents actually ask. Every tool is read-only, and
every location parameter accepts either an address ("600 E 4th St, Charlotte") or
"latitude,longitude".
My address
Tool | Answers questions like |
| "Who is my council member?" "What police division and fire station serve me?" "What's my zoning? Am I in a flood zone or historic district?" |
| "What day is trash pickup? Is this a recycling week (GREEN/ORANGE)?" |
| "Is this a valid address? What's its parcel ID and municipality?" |
Safety
Tool | Answers questions like |
| "Any car break-ins near my apartment this month?" |
| "How have robberies in Charlotte changed since 2019?" "Which division has the most burglaries?" |
| "Is the intersection by my kid's school dangerous?" |
City services and neighborhood change
Tool | Answers questions like |
| "Has anyone already reported this pothole or streetlight?" |
| "Does the house I'm renting have open housing-code violations?" |
| "Are any roads closed on my commute?" |
| "What's being built near me, when is it done, and who do I contact?" |
| "Is anyone trying to rezone land near my neighborhood?" |
Places and transit
Tool | Answers questions like |
| Nearest library, school, park, greenway, pharmacy, grocery store, EV charger, light rail station, bus stop, public Wi-Fi… (18 categories) |
| "How often does the 9 run on Sunday evenings?" |
Government transparency
Tool | Answers questions like |
| "How much does the city budget for Police?" |
| "What do Charlotte firefighters earn on average?" (aggregates only, no names) |
Anything else in the catalog
Tool | Purpose |
| Keyword search over the whole portal |
| Fields, types, and record count for a layer |
| SQL-filtered records from any layer, optionally near a location |
| Server-side counts/sums grouped by fields |
Setup
Requires Python 3.14 (developed on 3.14.7).
~/.pyenv/versions/3.14.7/bin/python -m venv .venv
.venv/bin/python -m pip install -e . --group devUse with Claude Code
claude mcp add charlotte-open-data -- /absolute/path/to/meck-311-mcp/.venv/bin/charlotte-open-data-mcpUse with Claude Desktop
Add to claude_desktop_config.json:
{
"mcpServers": {
"charlotte-open-data": {
"command": "/absolute/path/to/meck-311-mcp/.venv/bin/charlotte-open-data-mcp"
}
}
}Other transports and debugging
.venv/bin/charlotte-open-data-mcp --transport streamable-http --port 8000 # http://127.0.0.1:8000/mcp
npx @modelcontextprotocol/inspector .venv/bin/charlotte-open-data-mcp # interactive inspectorDevelopment
.venv/bin/pytest # unit + in-memory MCP tests; no network access
.venv/bin/ruff format --check . && .venv/bin/ruff check .
.venv/bin/mypyLayout:
src/charlotte_mcp/arcgis.py: async ArcGIS REST / Hub client (timeouts, bounded retries, host allowlist)src/charlotte_mcp/address.py: address matching against the county Master Address layersrc/charlotte_mcp/catalog.py: the curated layers behind the purpose-built toolssrc/charlotte_mcp/server.py: the MCP tools
Data notes and limitations
Geocoding uses Mecklenburg County's Master Address layer, so only addresses inside the county resolve. Coordinates outside the county are rejected.
Freshness varies by dataset: CMPD incidents, 311 requests, and code enforcement are current within days; the Budget Report dataset currently runs FY2018–FY2023. Tools report what the portal publishes.
CMPD locations are generalized by the department for privacy.
311 data records when requests were received, not when they were resolved.
Timestamps are ISO 8601 in Charlotte local time with the UTC offset (e.g.
2026-09-06T00:00:00-04:00). The underlying services store UTC.Budget amounts include large negative lines (e.g. "00 Non Department", Charlotte Water), so
get_city_budgetreports both the net total and the sum of positive lines.Statistics limits: some city map services ignore
resultRecordCounton aggregate queries, so the client enforces row limits itself.Live bus arrivals are not on the portal; pair this server with a CATS real-time source. Bus stop IDs from
find_nearby_placesmatch CATS stop IDs.The generic tools only reach hosts that serve portal datasets (
gis.charlottenc.gov,meckgis.mecklenburgcountync.gov,services.arcgis.com,gis.ci.charlotte.nc.us).Mecklenburg County's server rejects default Python user agents, so the client sends its own.
Ideas for more tools
Neighborhood Quality of Life indicators by NPA (income, age, housing, amenities)
Charlotte Fire incident reports by address block
CMPD officer traffic-stop statistics
Sidewalk and bike network gaps near an address
Tree canopy and land surface temperature by neighborhood
Available Tools
19 toolsdescribe_datasetDescribe a dataset's fieldsARead-onlyIdempotent
Show a dataset layer's description, record count, and fields.
Call this before query_dataset or summarize_dataset to learn field names and types.
Inputs: layer_url (required). Returns: name, fields, layer_url, description, +4 more
find_nearby_placesFind nearby public placesARead-onlyIdempotent
Nearest public places of one type, sorted by straight-line distance.
Categories include libraries, public schools, parks, greenways, fire and police stations, post offices, pharmacies, grocery stores, medical facilities, child care, EV chargers, park-and-ride lots, light rail stations, bus stops, YMCAs, places of worship, and public Wi-Fi. Bus stop IDs can be used with CATS real-time arrival services.
Inputs: category (required), location (required), limit, radius_miles. Returns: notes, places, category, location, +2 more
get_311_requests_near311 service requests near a locationARead-onlyIdempotent
311 service requests reported near a location, with counts by request type.
Shows whether a problem (pothole, missed pickup, dumping, streetlight) was already reported.
Inputs: location (required), days, limit, radius_miles, +1 more. Returns: Records matching a filter, optionally near a location.
get_address_profileAddress profile: representatives, services, zoningARead-onlyIdempotent
Everything that serves or governs a location, in one call.
Returns city council district and representative, county commissioner, CMPD patrol division, first-due fire station, trash/recycling/yard-waste days, zoning, FEMA flood zone, historic district, ZIP code, and tax parcel ID.
Inputs: location (required). Returns: Public services, representatives, and regulations that apply at a location.
get_bus_routeCATS bus route frequenciesARead-onlyIdempotent
CATS bus routes with scheduled frequency (minutes between buses) by time of day.
For stops near an address use find_nearby_places with category 'bus_stop'.
Inputs: route. Returns: Records matching a filter, optionally near a location.
get_capital_projects_nearCity capital projects near a locationBRead-onlyIdempotent
City capital projects (roads, sidewalks, parks, facilities) near a location.
Includes phase, schedule, budget, and the project manager's contact information.
Inputs: location (required), limit, phase, radius_miles. Returns: Records matching a filter, optionally near a location.
get_city_budgetCity budget by department or fundBRead-onlyIdempotent
City of Charlotte budget totals for a fiscal year by department, fund, or expense type.
Inputs: limit, group_by, department, fiscal_year. Returns: rows, notes, group_by, fiscal_year, +4 more
get_city_salary_statsCity employee pay statisticsARead-onlyIdempotent
Pay statistics for City of Charlotte employees: head count and annual pay rates.
Aggregated by department or job title for one quarter (the latest by default); individual employees are not listed.
Inputs: year, limit, quarter, group_by, +2 more. Returns: rows, year, notes, filters, +3 more
get_code_enforcement_casesCode enforcement cases near an addressBRead-onlyIdempotent
Housing and neighborhood code enforcement cases at or near an address.
Covers nuisance (junk, overgrown lots), minimum housing, zoning, graffiti, and parking violations. Useful for renters, buyers, and neighbors.
Inputs: location (required), days, limit, status, +2 more. Returns: Records matching a filter, optionally near a location.
get_crime_nearPolice incidents near a locationARead-onlyIdempotent
CMPD police incident reports near a location: counts by offense and the latest reports.
Answers "is there much crime near 123 Main St?" or "any car break-ins near me lately?".
Inputs: location (required), days, limit, offense, +1 more. Returns: Records matching a filter, optionally near a location.
get_pending_rezoningsPending rezoning petitionsBRead-onlyIdempotent
Rezoning petitions currently in process, citywide or near a location.
Shows the petitioner, existing and requested zoning, acreage, and a link to the petition.
Inputs: near, limit, radius_miles. Returns: Records matching a filter, optionally near a location.
get_street_closuresStreet closures and detoursARead-onlyIdempotent
Street and lane closures and detours published by CDOT, citywide or near a location.
Inputs: near, limit, active_only, radius_miles. Returns: Records matching a filter, optionally near a location.
get_traffic_crashes_nearTraffic crashes near a locationARead-onlyIdempotent
Reported traffic crashes near a location, with counts by severity.
Useful for "is this intersection dangerous?" or traffic-calming requests.
Inputs: location (required), days, limit, radius_miles. Returns: Records matching a filter, optionally near a location.
get_trash_and_recycling_scheduleTrash and recycling scheduleBRead-onlyIdempotent
Garbage, recycling, and yard-waste collection days for an address in Charlotte.
Inputs: location (required). Returns: notes, location, schedule
lookup_addressLook up a Mecklenburg County addressBRead-onlyIdempotent
Find an address in Mecklenburg County's official master address list.
Returns matches with coordinates, tax parcel ID, municipality, and ZIP code.
Inputs: address (required), max_results. Returns: note, query, candidates
query_datasetQuery any datasetBRead-onlyIdempotent
Fetch records from any portal dataset layer with a SQL filter, optionally near a place.
Inputs: layer_url (required), near, limit, where, +3 more. Returns: Records matching a filter, optionally near a location.
search_datasetsSearch Charlotte open datasetsARead-onlyIdempotent
Search the Charlotte Open Data Portal catalog (about 380 datasets) by keyword.
Use this to find data the purpose-built tools don't cover. Pass a result's layer_url to describe_dataset, query_dataset, or summarize_dataset.
Inputs: query (required), limit. Returns: query, datasets, total_matching
summarize_crimeCitywide crime statisticsARead-onlyIdempotent
Citywide CMPD incident counts grouped by offense, division, year, or neighborhood.
Use group_by='year' with an offense filter for trends, e.g. robberies per year since 2017.
Inputs: year, limit, offense, group_by, +1 more. Returns: Server-side aggregate of a dataset.
summarize_datasetAggregate any datasetARead-onlyIdempotent
Count or aggregate any portal dataset server-side, grouped by up to three fields.
Answers questions like "how many 311 requests of each type were made in ZIP 28205?". Rows are sorted by the statistic, largest first, in a column named stat_value.
Inputs: group_by (required), layer_url (required), near, limit, +4 more. Returns: Server-side aggregate of a dataset.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
Scored across 19 tools
Most tools map to distinct data domains (311, crime, crashes, budget, etc.), but get_address_profile duplicates several specialized capabilities—especially trash/recycling schedule—and the generic query_dataset/summarize_dataset can answer questions also covered by purpose-built tools. Descriptions provide guidance (e.g., search_datasets says to use purpose-built tools first), so misselection risk is moderate but present.
All 19 tools use snake_case with a verb-first pattern (get_, lookup_, summarize_, find_, search_, describe_, query_), and resource names are clear and predictable. Minor verb variety (get vs lookup vs find) is semantically appropriate and does not break consistency.
19 tools is on the higher side but justified by the breadth of Charlotte open data (address, transit, safety, budget, etc.) plus a generic dataset access layer. Each tool targets a distinct data type, though the composite address profile and generic trio create some redundancy.
The surface covers major city data domains and the generic search/describe/query/summarize tools allow access to any of ~380 portal datasets, so agents can answer most questions without dead ends. Minor gaps include real-time transit arrivals and a dedicated bus stop tool (handled indirectly via find_nearby_places), but overall coverage is strong.
Related MCP Connectors
Provides access to Civic Plus - See Click Fix, allowing you to interact with your data via an LLM.…
Search and query government open-data portals (Socrata SODA API).
Search and read published GoVisit destination and local business data through 22 read-only tools.
Real-world data for agents: air quality, geocoding, quakes, holidays, web search
Related MCP Servers
- AlicenseNot gradedqualityBmaintenanceProvides access to Cincinnati open data via the Socrata SODA API, allowing users to query datasets using natural language or direct tool calls.150 npmMIT
- AlicenseNot gradedqualityCmaintenanceEnables AI agents to search and query City of Raleigh GIS open geospatial datasets (parcels, zoning, parks, transport, city services) via ArcGIS Feature Services.85 npmMIT
- AlicenseNot gradedqualityCmaintenanceEnables searching and querying Durham, North Carolina open geospatial data from ArcGIS Feature/Map Services, including parcels, zoning, and public safety datasets via natural language or direct tool calls.86 npmMIT
- AlicenseNot gradedqualityCmaintenanceEnables AI agents to search and query City of Charlotte GIS datasets (parcels, zoning, public works) via ArcGIS Feature Services.88 npm1MIT