CensusChat

hollandkevint/CensusChat

★ 3 stars TypeScript AI/LLM Updated 5d ago

Self-hosted natural language interface to US Census ACS data. TypeScript monorepo: Express + DuckDB backend, Next.js frontend, and a standalone MCP server you can point Claude Desktop at. Plain-English questions become validated SQL.

View on GitHub → 🔍 Audit Wallet Slippage →

Quick Install

Copy the config for your editor. Some servers may need additional setup — check the README.

Add to claude_desktop_config.json:

{
  "mcpServers": {
    "censuschat": {
      "command": "npx",
      "args": [
        "-y",
        "hollandkevint/CensusChat"
      ]
    }
  }
}

README Excerpt

Ask US Census demographics a question in plain English. Claude turns it into SQL, a validation layer checks the SQL against an allowlist, and DuckDB answers it. --- **Question:** which Florida counties have the most residents aged 65 and over? | County | Population | Age 65+ | Age 65+ % | Median household income | National rank, 65+ count |

Tools (2)

block_group_data_expandedcounty_data

Topics

acsanthropic-claudecensus-datademographicsduckdbhealthcare-analyticsmcp-servermodel-context-protocolnatural-language-processingnextjssqltypescript

CensusChat

Quick Install

README Excerpt

Tools (2)

Topics

Related AI/LLM Servers