MCP 服务器

uk-schools-mcp

MCP server providing access to comprehensive UK school data from official government sources, including search, details, near-postcode, comparisons, Ofsted ratings, and DfE education datasets.

README

UK Schools MCP Server

A Model Context Protocol server that provides AI assistants with access to comprehensive UK school data from official government sources.

Features

Search schools by name, postcode, or local authority (GIAS bulk data)
Get detailed school information (type, phase, age range, capacity, contact details)
Find schools near a postcode with distance sorting (Postcodes.io geocoding)
Compare schools side-by-side
Browse and query 23+ DfE education datasets (absence, exclusions, performance, SEND, admissions, workforce, funding, destinations, and more)
One-step dataset discovery: find the right dataset for any education topic
Get Ofsted inspection grades and judgements from Management Information data
Links to Ofsted inspection reports

Data Sources

Source	Type	Auth	What it provides
GIAS	Bulk CSV (daily)	None	All ~65k schools: name, URN, type, phase, address, capacity, pupils, head teacher, SEN, etc.
Postcodes.io	REST JSON API	None	UK postcode geocoding (lat/lng) for catchment area searches
Explore Education Statistics	REST JSON API	None	DfE publications: performance tables, absence, exclusions, applications & offers, workforce
Ofsted	Monthly Excel + report links	None	Inspection grades, judgement areas, dates, and report URLs

Installation

Using uv (recommended)

git clone https://github.com/yourusername/uk-schools-mcp.git
cd uk-schools-mcp
uv sync --all-extras
uv run python -m uk_schools_mcp.server

Using pip

pip install mcp httpx polars pydantic openpyxl

Usage with Claude Desktop

Add to your Claude Desktop configuration (~/Library/Application Support/Claude/claude_desktop_config.json on macOS):

{
  "mcpServers": {
    "uk-schools": {
      "command": "uv",
      "args": [
        "--directory",
        "/path/to/uk-schools-mcp",
        "run",
        "python",
        "-m",
        "uk_schools_mcp.server"
      ]
    }
  }
}

Available Tools

`search_schools`

Search for UK schools by name, postcode, or local authority using GIAS data.

Example: "Find primary schools in Milton Keynes"

`get_school_details`

Get comprehensive details for a specific school by URN, including links to Ofsted reports and the GIAS page.

Example: "Show me details for URN 109825"

`find_schools_near_postcode`

Find schools within a radius of a UK postcode, sorted by distance. Uses Postcodes.io for geocoding and GIAS data for school locations.

Example: "Find all primary schools within 2km of MK9 3BZ"

`compare_schools`

Compare multiple schools side-by-side by URN.

Example: "Compare schools with URNs 109825, 110234, and 110567"

`search_education_statistics`

Search the DfE Explore Education Statistics catalogue for publications on school performance, absence, exclusions, applications & offers, workforce, etc.

Example: "Search for publications about school absence"

`get_publication_datasets`

List available datasets for a DfE publication (use after search_education_statistics).

`get_dataset_metadata`

Get available filters, indicators, geographic levels, and time periods for a DfE dataset. Essential before querying to discover what data is available and what IDs to use.

Example: "What filters and indicators are available for dataset ds-123?"

`query_dataset`

Query a DfE Explore Education Statistics dataset with specific indicators, filters, time periods, and geographic levels. Enables access to school-level data on absence, exclusions, performance, admissions, workforce, and more.

Example: "Query the absence dataset for 2023 academic year at national level"

`get_ofsted_ratings`

Get Ofsted inspection ratings and grades for a school by URN. Returns overall effectiveness grade and grades for each inspection area (Quality of Education, Behaviour and Attitudes, Personal Development, Leadership and Management), plus inspection dates, type, and previous grades.

Example: "Get Ofsted ratings for URN 109825"

`list_ees_topics`

List all 23 available education data topics from the DfE Explore Education Statistics API, organized by category (performance, welfare, demographics, admissions, workforce, finance, destinations, early years).

`discover_dataset`

Automatically find the publications and datasets for a given education topic. Replaces the manual 4-step workflow with a single call. Returns dataset IDs ready for use with get_dataset_metadata and query_dataset.

Example: "Discover datasets for topic 'absence'" or "Find SEND data"

Available topics: absence, exclusions, ks2_performance, gcse_performance, a_level_performance, applications_offers, workforce, sen, school_pupils_characteristics, free_school_meals, school_capacity, admission_appeals, destinations, children_looked_after, children_in_need, mat_performance, school_funding, la_school_expenditure, further_education, early_years, early_years_foundation, neet, elective_home_education

Development

Setup

git clone https://github.com/yourusername/uk-schools-mcp.git
cd uk-schools-mcp
uv sync --all-extras
uv run pytest
uv run ruff check src/ tests/

Project Structure

uk-schools-mcp/
├── src/
│   └── uk_schools_mcp/
│       ├── server.py           # MCP server + tool handlers
│       └── clients/
│           ├── gias.py         # GIAS bulk CSV client
│           ├── postcodes.py    # Postcodes.io geocoding client
│           ├── ees.py          # Explore Education Statistics API client
│           └── ofsted.py       # Ofsted report URL helper
├── tests/
│   └── test_server.py
├── NEXT_STEPS.md               # Roadmap for additional data sources
└── pyproject.toml

How GIAS Data Works

On first use, the server downloads the daily GIAS bulk CSV (~65k schools, ~30MB) from:

https://ea-edubase-api-prod.azurewebsites.net/edubase/downloads/public/edubasealldata{YYYYMMDD}.csv

The CSV is cached locally at ~/.cache/uk-schools-mcp/ and refreshed daily. All search and lookup operations run against this cached data using polars for fast filtering.