CPS Data MCP Server

Example Use Cases

• 1

  Access and run SQL queries against a local table of Chicago public schools and their neighborhoods to retrieve structured school and neighborhood information.

• 2

  Perform semantic search over Chicago public school website content using a LanceDB vector store to provide contextual answers about specific schools.

• 3

  Integrate local CPS datasets into offline or privacy-preserving workflows, enabling agents to fetch school metadata and website context without external APIs.

Description

This MCP server provides programmatic access to a local SQLite database of Chicago public schools and neighborhoods and a LanceDB vector database of school website content. It implements two tools for executing SQL queries against a schools-to-neighborhoods table and for semantic retrieval over school website content (with optional school name filtering). The project is intended to make local, privacy-friendly CPS data available to agents and can be run locally with simple configuration pointing to the SQLite and LanceDB files. Debugging support is provided via the MCP Inspector.