Pawansingh3889 - Overview

What I'm building

OpsMind

On-prem AI for food factories. Ask your database questions in English.

$ ollama pull phi3:mini
$ streamlit run app.py

> "What was yesterday's yield?"
  → SELECT ... FROM ProductionRuns
  → 94.2% yield, 38kg waste
  → "Yesterday's yield was above target..."

Ollama ChromaDB LangChain SQLAlchemy 36 tests

Docs · Code

Compliance Dashboard

BRC/HACCP food safety. Replaces the Excel spreadsheets.

$ make setup && make run

  Traceability score:  97.2%
  Temperature control: 99.1%
  Overall compliance:  PASS
  Batches tracked:     674
  Temp readings:       8,640

Streamlit PySpark Databricks z-score anomaly detection

Live · Code

UK Crime Pipeline

End-to-end: live API → PostgreSQL → dbt → Streamlit.

$ python ingestion/fetch_crimes.py
  Fetching 10 cities × 6 months...
  Loaded 99,675 records (ON CONFLICT DO NOTHING)

$ dbt run && dbt test
  4 models, 53 tests passed
  fct_crimes_by_city: 814 rows
  fct_crime_hotspots: top 100 streets

PostgreSQL dbt Prefect 3 CI/CD workflows weekly auto-ingest

Live · Code

SQL Ops Reviewer

GitHub Action that reviews .sql in PRs using local AI.

# One file. That's the setup.
- uses: Pawansingh3889/sql-ops-reviewer@v1
  with:
    github-token: ${{ secrets.GITHUB_TOKEN }}

⚠ WARNING: SELECT * fetches all columns
✗ ERROR: String concatenation → injection risk
  Total: 2 findings across 1 file

GitHub Actions Ollama zero API keys

Code

Upstream contributions

Project	What I shipped
vllm `75K★`	Improved DCP/PCP error messages with actionable backend guidance
pandas `45K★`	Clarified `str.cat()` return type docs + code review that led to merged test case
ChromaDB `18K★`	220-line HNSW tuning guide + replaced 103 ValueError with InvalidArgumentError across API layer
pgspecial/pgcli `12K★`	Added `\dS` system object metacommands matching psql behavior
drt-hub/drt	Snowflake source + ClickHouse, Parquet, Teams, CSV/JSON destinations — 6 PRs merged

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