Skip to content
View Pawansingh3889's full-sized avatar

Block or report Pawansingh3889

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don't include any personal information such as legal names or email addresses. Markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
Pawansingh3889/README.md

Pawan Singh Kapkoti

I break things, read source code, and ship fixes upstream.

MSc Data Analytics. Working in food manufacturing, building pipelines and dev tools on the side. Yorkshire, UK.

Portfolio · Resume · LinkedIn


OpsMind — on-prem AI for factories. NL-to-SQL, RAG search, runs on Ollama. docs

UK Crime Pipeline — API → PostgreSQL → dbt → Streamlit. live

sql-sop — fast rule-based SQL linter. 15 rules, pre-commit hook, GitHub Action. pip install sql-sop

SQL Ops Reviewer — GitHub Action that reviews .sql in PRs using local AI. Pairs with sql-sop.

Compliance Dashboard — BRC/HACCP food safety. live


Open source contributor — drt, ChromaDB, pgcli, Electricity Maps, Open Climate Fix.

Pinned Loading

  1. uk-crime-pipeline uk-crime-pipeline Public

    End-to-end data pipeline: Police UK API → PostgreSQL → dbt → Streamlit dashboard. CI/CD with GitHub Actions

    Python

  2. OpsMind OpsMind Public

    On-premises AI assistant for food factories. Natural language SQL, document search, waste prediction, compliance dashboards. Runs locally with Ollama.

    Python 1

  3. uk-education-attainment uk-education-attainment Public

    ML analysis of UK A-Level attainment gaps by ethnicity, gender & deprivation using DfE data

    Jupyter Notebook

  4. manufacturing-compliance-dashboard manufacturing-compliance-dashboard Public

    BRC/HACCP compliance dashboard for food manufacturing. Batch traceability, temperature monitoring, allergen matrix. Streamlit + SQLite.

    Python

  5. sql-ops-reviewer sql-ops-reviewer Public

    AI-powered SQL review for pull requests. Catches performance anti-patterns, security risks, and optimization opportunities. Uses Ollama locally — no cloud APIs.

    Python

  6. sql-guard sql-guard Public

    Fast rule-based SQL linter. 15 rules, pre-commit hook, GitHub Action. pip install sql-sop

    Python