Georgia Civic Data
by georgiacivicdata.org in Other
Georgia education, Census, and immigration data: query, filter, aggregate, and link datasets.
https://mcp.georgiacivicdata.org/mcp/- Tools
- 13
- open to any client
- Uptime
- 100%
- last 30 days
- Response time
- 503 ms
- 773 ms slowest 5%
- Last check
- Passed
- 2 h ago, next in 4 h
Reliability
Status and outage history · Atom feed · Watch with other listings
How to connect
Add it to any MCP client that supports remote servers.
{
"mcpServers": {
"georgia-civic-data": {
"type": "http",
"url": "https://mcp.georgiacivicdata.org/mcp/"
}
}
}13 tools
- list_datasets
Enumerate every approved Georgia dataset (topic) and the shared dimensions. Each topic entry is a LEAN summary — name/keys, year coverage (year_min/year_max + year_gaps), detail levels + default detail, a has_demographic flag (false = no demographic axis, so there is no…
- search_datasets
Keyword search over the catalog metadata (topic names, descriptions, tags, AND column names/descriptions) — the discovery entry point when you don't know the exact topic name. Returns lean topic summaries per hit with a relevance score and which fields matched, plus a…
- describe_dataset
Full schema for one topic: every column (name/type/role/unit/value range/null-meaning), the exact `filters` list with enum values (read this before query_dataset — it is the authoritative set of filter keys), the FK→dimension join shape (`foreign_keys`), example queries, usage…
- query_dataset
Query one topic's gold facts with dimension labels joined in (the district/school/county/demographic names come back on every row). `filters` is a dict of column → value or list-of-values: FK codes (district_code, school_code, county_fips, demographic) and any categorical column…
- distinct_values
List the distinct values of ONE filterable column of a topic — the fast way to learn valid filter values before query_dataset, especially for FREE categoricals and FK codes (district_code/school_code/county_fips/demographic) that carry no enum in describe_dataset (a wrong guess…
- aggregate
Compute a grouped aggregate over one topic — the aggregation-first path. `agg` is one of avg/sum/min/max/count/weighted_rate; `metric` is a metric column (DEFAULTS to the topic key_metric; ignored for count); `group_by` is a list of grain columns (year, FK codes like…
- resolve_entity
Resolve a place or demographic NAME or CODE to its stable keys + labels — the right way to turn 'Atlanta Public Schools' / 'Fulton' / a raw code into the district_code / school_code / county_fips / demographic to filter by (a wrong code guess otherwise returns an empty…
- describe_dimension
Schema for one dimension (districts / schools / counties / demographics): the (possibly composite) primary key, the attribute columns a join attaches, the cross-dataset `link_keys` (e.g. districts.district_census_id → Census via the crosswalk — a 5-digit school-district code…
- get_dimension
Paginated read of a dimension table — the label lookups (district names, school names, county names, demographic labels). Rows are ordered by the dimension's primary key so paging is stable. Use describe_dimension for the schema and link keys. Small page defaults; `truncated` +…
- get_contract
Return the authoritative ODCS v3.2 data contract for a topic (kind='topic') or a dimension (kind='dimension') so you can consume the machine-readable schema without cloning the repo. fmt='yaml' (default) returns the document verbatim as text; fmt='json' returns it parsed. Only…
- lookup_school_zone
Which Georgia public school attendance zones (elementary, middle, high) contain a place, or (attendance_rules=true) how attendance zones work in Georgia. Give exactly one of: lat + lon; an address (geocoded by the U.S. Census Geocoder); a 2020 census tract_geoid (returns every…
- link_tables
List the tables link_query can read (curated gold paths only) and the join keys that bridge facts → dimensions → Census geography. Call this BEFORE writing a link_query. Two-tier to stay context-cheap: with NO arguments it returns a LEAN index — every table's name, grain, detail…
- link_query
Run a cross-dataset / cross-topic analytical SQL query that the per-topic query_dataset filters can't express — e.g. join education, Census, or immigration facts to a dimension (or another dataset) on shared geography (immigration and Census county topics share county_fips…
Security scan
No findings
We scan names, descriptions and tool definitions for hidden instructions and other prompt-injection patterns.
Recent checks
| When | Result | HTTP | Time |
|---|---|---|---|
| 2 h ago | Passed | 200 | 438 ms |
| 13 h ago | Passed | 200 | 773 ms |
| 24 h ago | Passed | 200 | 509 ms |
| 34 h ago | Passed | 200 | 475 ms |
| 43 h ago | Passed | 200 | 485 ms |
Show 9 older checks
| 2 days ago | Passed | 200 | 503 ms |
| 3 days ago | Passed | 200 | 699 ms |
| 3 days ago | Passed | 200 | 504 ms |
| 3 days ago | Passed | 200 | 457 ms |
| 4 days ago | Passed | 200 | 510 ms |
| 4 days ago | Passed | 200 | 453 ms |
| 5 days ago | Passed | 200 | 482 ms |
| 5 days ago | Passed | 200 | 769 ms |
| 5 days ago | Passed | 200 | 508 ms |