mcp-cps-data MCP server
About
MCP Server for locally hosted data on Chicago Public Schools
Details
- Author
- mdagost
- Downloads
- 183
- Categories
- Search
Jump to
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
mcp-cps-data MCP serverCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
{
"mcpServers": {
"mcp-cps-data": {
"command": "npx",
"args": [
"@modelcontextprotocol/inspector",
"uv",
"--directory",
"/path/to/mcp-cps-data",
"run",
"mcp-cps-data",
"--sqlite-path",
"/path/to/cps_crawler.db",
"--lancedb-path",
"/path/to/embeddings.lancedb"
]
}
}
}
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"mcp-cps-data mcp server": {
"mcp-cps-data": {
"command": "npx",
"args": [
"@modelcontextprotocol/inspector",
"uv",
"--directory",
"/path/to/mcp-cps-data",
"run",
"mcp-cps-data",
"--sqlite-path",
"/path/to/cps_crawler.db",
"--lancedb-path",
"/path/to/embeddings.lancedb"
]
}
}
}
}McpServers
{
"mcp-cps-data": {
"command": "npx",
"args": [
"@modelcontextprotocol/inspector",
"uv",
"--directory",
"/path/to/mcp-cps-data",
"run",
"mcp-cps-data",
"--sqlite-path",
"/path/to/cps_crawler.db",
"--lancedb-path",
"/path/to/embeddings.lancedb"
]
}
}mcp-cps-data MCP server
A MCP server project for exposing a local SQLite database and a local LanceDB vector database with information on Chicago Public Schools
Components
Tools
The server implements two tools:
- query_schools_and_neighborhoods: Excecute a SELECT query on a table of Chicago public schools and their neighborhoods called "schooltoneighborhood" with the following schema: (id INTEGER NOT NULL, created_at DATETIME NOT NULL, school_id INTEGER NOT NULL, school_name VARCHAR NOT NULL, neighborhood VARCHAR NOT NULL, PRIMARY KEY (id)).
- Takes required parameter query
- query_school_websites: Query a database of Chicago public school websites for context relevant to answering a given question.
- Takes required parameter question and optional parameter school_name.
Configuration
Get the SQlite database and the LanceDB vector database from the [cps-childcare] project(https://github.com/mdagost/cps-childcare).Quickstart
Install
Claude Desktop
On MacOS: ~/Library/Application\ Support/Claude/claude_desktop_config.json
On Windows: %APPDATA%/Claude/claude_desktop_config.json
Development/Unpublished Servers Configuration:
"mcpServers": {
"mcp-cps-data": {
"command": "uv",
"args": [
"--directory",
"/path/to/mcp-cps-data",
"run",
"mcp-cps-data",
"--sqlite-path",
"/path/to/cps_crawler.db",
"--lancedb-path",
"/path/to/embeddings.lancedb"
]
}
}
Debugging
Since MCP servers run over stdio, debugging can be challenging. For the best debugging
experience, we strongly recommend using the MCP Inspector.
You can launch the MCP Inspector via npm with this command:
npx @modelcontextprotocol/inspector uv --directory /path/to/mcp-cps-data run mcp-cps-data --sqlite-path /path/to/cps_crawler.db --lancedb-path /path/to/embeddings.lancedb
Upon launching, the Inspector will display a URL that you can access in your browser to begin debugging.
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
