himc-mcp
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@himc-mcp List the tables, then describe the spells table and its data-quality flags."
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
HIMC clean data
Cleaned tables from the HIMC data room, plus an MCP server so an AI assistant (Claude, or any other MCP client) can query them directly.
Everything here is fictional. The data room was written for the Hyper Island module Intelligent Machines. Wardline Health, Kingsmere Royal Infirmary, Kisima County Referral Hospital and RSUD Sukamaju do not exist, and no real patient, staff or company data is in it. A result from this data says nothing about a real hospital.
The raw files, the brief and the inject cards are not in this repository: get them from the original repository. This one holds only the cleaned tables of the three hospitals and the prototype back-test.
What is in it
Path | What it is |
| Read this first. What each table is, the cleaning rules, and the caveats. Its last two sections give a first finding and starter questions; skip them if you want to form your own view (the assistant is not shown them) |
| Every table with its row and column counts |
| The 53 problems found: what was wrong, how many rows, what was done |
| The 25 cleaned tables as CSV |
| The script that produced them from the raw files |
| The MCP server to run on your own computer, with the same tables as one SQLite database |
| The hosted MCP server (Cloudflare Worker + D1) behind the link below |
clean/uk_kingsmere/spells.csv.gz (151,217 hospital stays) is compressed because it is 64 MB as
plain CSV. Double-click to unpack it, or read it directly: pd.read_csv("clean/uk_kingsmere/spells.csv.gz").
Related MCP server: sqlite-mcp-server
Use it in Claude or ChatGPT from a link (nothing to download)
The data is hosted as a remote MCP server. Add this address as a custom connector:
https://himc-mcp.pellefredrikson.workers.dev/mcpClaude (web, desktop or phone): Settings › Connectors › Add custom connector. Name it
HIMC, paste the address, leave the other fields empty, and add it. In a new chat, switch the connector on.ChatGPT: Settings › Apps & Connectors › Advanced settings › turn on Developer mode, then create a connector with the address above and authentication set to none. Switch it on in a new chat.
Then paste the prompt in PROMPT.md, or just ask your questions. The server is
read-only, needs no sign-in, and holds only the fictional data. Custom connectors depend on your
plan in both apps; if yours does not offer them, use the file route below.
Use it in ChatGPT or Claude by attaching a file
Download himc.sqlite.gz
(16 MB: every table in one database), attach it to a new chat and paste the second prompt in
PROMPT.md. The assistant unpacks it with its own code tool. In Claude, switch on
Code execution and file creation under Settings › Capabilities first.
Run the MCP server on your own computer
The server is read-only: it answers SELECT queries and cannot change anything. You need
uv installed; nothing else, and no
need to clone this repository.
Claude Code
claude mcp add himc -- uvx --from git+https://github.com/Pelleking/himc-clean-data himc-mcpClaude Desktop (Settings › Developer › Edit Config), and most other MCP clients:
{
"mcpServers": {
"himc": {
"command": "uvx",
"args": ["--from", "git+https://github.com/Pelleking/himc-clean-data", "himc-mcp"]
}
}
}Restart the client. The first start takes a little longer: it downloads the package and unpacks
the database (about 100 MB) into ~/.cache/himc-mcp.
Then ask your questions in plain language. The server describes the data and its caveats; it does not suggest what to look for or what to conclude.
Tools
Tool | What it does |
| The data notes: tables, cleaning rules, caveats |
| All 26 tables with row and column counts |
| Columns, types, sample rows and data-quality flag counts for one table |
| One read-only SQLite |
| The cleaning log, optionally for one dataset |
Columns starting dq_ flag a problem (1 = present). Columns ending _raw hold the value before
correction.
Use it without an assistant
Open the CSV files in any spreadsheet or notebook. For SQL, unpack the database:
gunzip -k src/himc_mcp/data/himc.sqlite.gz
sqlite3 src/himc_mcp/data/himc.sqlite "SELECT horizon_days, mae_model, mae_naive_last FROM prototype__backtest_summary LIMIT 7"Run the server from a clone
git clone https://github.com/Pelleking/himc-clean-data && cd himc-clean-data
python3 -m venv .venv && .venv/bin/pip install -e .
.venv/bin/himc-mcp # speaks MCP over stdin/stdoutCredits and terms
The data room is by the authors of wendinstefan/HIMC, made
for teaching. That repository states no licence, so this copy is shared for use within the course;
ask its authors before using the data for anything else. The MCP server code in src/ is MIT-licensed.
Available Tools
5 toolsdata_quality_logA
The 53 problems found while cleaning: what was wrong, how many rows, what was done, how it was found.
Pass dataset (e.g. "uk.spells", "ke.bed_state") to see one table's issues, or part of a name such as "uk".
Inputs: dataset. Returns: result
describe_tableB
Columns (name and type), row count, three sample rows, and which columns are data-quality flags, for one table.
Inputs: table (required).
list_tablesA
Every table with its row and column counts. Table names are <hospital>__<table>, e.g. uk_kingsmere__daily_site_panel.
Inputs: no named parameters. Returns: result
overviewA
What the tables are, how the data was cleaned and the caveats to respect before analysing. Read this first.
Inputs: no named parameters. Returns: result
queryA
Run one read-only SQLite SELECT (or WITH ... SELECT) and get the rows back.
Aggregate in SQL instead of pulling raw rows: the stays table has 151,000 rows. At most 1,000 rows
are returned; truncated says whether more existed. Dates are text in YYYY-MM-DD form, so
strftime('%Y-%m', date) and date BETWEEN '2025-11-01' AND '2026-10-31' work.
Inputs: sql (required), limit.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
Scored across 5 tools
Each tool has a distinct role: overview for orientation, list_tables for discovery, describe_table for schema detail, query for execution, and data_quality_log for cleaning provenance. The only mild overlap is between overview and data_quality_log, since both discuss how the data was cleaned, though one is dataset-wide narrative and the other is per-table issue logging.
All names are snake_case and readable, with list_/describe_ verb prefixes on the discovery tools. query, overview, and data_quality_log are noun/single-verb forms rather than verb_noun, a minor deviation but nothing confusing.
Five tools is well-scoped for a read-only analytical dataset server: discovery, inspection, execution, and two context tools. Nothing feels padded and every tool earns its place in the exploration workflow.
The surface covers the full read-only lifecycle: orient (overview), discover (list_tables), inspect (describe_table), query (query), and audit provenance (data_quality_log), with SQL handling joins and aggregation. Minor gaps include no schema-wide search or column-level lookup, but agents can work around these with query.
Maintenance
Related MCP Connectors
Hosted MCP server exposing US hospital procedure cost data to AI assistants
Text-to-SQL MCP server: read-only queries on PostgreSQL, MySQL and SQL Server with your real schema
Free hosted MCP server: US healthcare procedure cost estimates and provider pricing. No API key.
Hosted MCP server for Cliniko — patients, appointments, availability, and invoices for AI agents.
Related MCP Servers
- AlicenseAqualityDmaintenanceMCP server providing LLMs with safe, read-only access to the Chinook SQLite sample database, including schema exploration and SQL query execution.11MIT
- AlicenseNot gradedqualityDmaintenanceA read-only MCP server that enables LLMs to safely explore and query any SQLite database via natural language. It exposes tools for listing tables, describing schemas, and executing SELECT/WITH queries with built-in safety guards like write prevention and row limits.MIT
- AlicenseCqualityDmaintenanceA local-first, model-agnostic MCP server that stores personal health data in a SQLite file and provides analysis-ready views for any AI client to log, retrieve, and reason over health records.79MIT
- AlicenseNot gradedqualityDmaintenanceRead-only MCP server for SQL databases (SQLite/PostgreSQL) that enables listing tables, describing schemas, and executing SELECT queries with safety guardrails.MIT