Data engineer based in the UK. I build small, free, on-prem tools for data and SQL work, and send fixes upstream to the projects I use. MSc Data Analytics, Aston.
- schema-scout — reverse-engineers a SQL Server database into an AI-ready catalog: infers the undeclared foreign keys, flags PII, scores how AI-ready the schema is, and renders an offline dashboard. Runs entirely on-prem.
- sql-sop — a SQL linter
that catches dangerous and non-conforming SQL in CI and pre-commit.
pip install sql-sop· browser playground - sql-sop-mcp — an MCP
server wrapping the linter, so Claude / Cursor / any MCP client can call it.
pip install sql-sop-mcp - pr-sop — small PR-governance
checks: changelog drift, version mismatch, stale pre-commit pins.
pip install pr-sop - morning-brief —
rule-based Gmail triage, read-only, no LLM.
pip install morning-brief
- OpsMind — on-prem AI over manufacturing data: natural-language-to-SQL through a LangGraph agent, RAG over pgvector / ChromaDB, models served locally by Ollama, with an eval harness.
- production-analytics-pipeline — incremental ETL from a manufacturing ERP; FastAPI + Next.js + Power BI, Prefect orchestration, 53 tests.
- uk-crime-pipeline — Police UK API into PostgreSQL and BigQuery; dbt marts, ~100k records, Polars ingestion.
Python · SQL Server / PostgreSQL · dbt · pandas / Polars · FastAPI · Ollama / LangGraph (on-prem AI) · Docker · GitHub Actions