t4ngo@workstation:~/repos $ ls -la ./projects

// REPO INDEX

Projects

Public repositories from GHT4ngo, grouped by project type. Live links are included when the project has one.

Data engineering

./GHT4ngo/myh-data-pipeline

myh-data-pipeline

LIVE

Pipeline harmonizing Swedish MYH vocational education data into PostgreSQL, FastAPI, an ML approval predictor, and a React dashboard.

  • HTML
  • PostgreSQL
  • FastAPI
  • React
  • ML
./GHT4ngo/fab

fab

LIVE

Flesh and Blood TCG card-data app: ingest to PostgreSQL bronze/silver/gold layers, then expose data through FastAPI.

  • Python
  • PostgreSQL
  • FastAPI
  • Data pipeline
./GHT4ngo/Dimensional-Modeling

Dimensional-Modeling

LIVE

Database design and modeling assignment for a data warehouse schema.

  • T-SQL
  • Data warehouse
  • Dimensional modeling

AI and automation

./GHT4ngo/LiaBot

LiaBot

LIVE

Automated LIA search using JobTech API, Swedish career sites, local AI analysis, and a dashboard UI.

  • Python
  • FastAPI
  • PostgreSQL
  • React
  • Ollama
./GHT4ngo/nexus-personal-assistant

nexus-personal-assistant

WIP

Personal assistant concept for pooling daily information, sorting it, and presenting it clearly.

  • Assistant
  • Automation
  • Product concept
./GHT4ngo/BreakPointBot

BreakPointBot

LIVE

Discord bot for break tracking and lunch menu updates.

  • Python
  • Discord
  • Automation

Card and game tools

./GHT4ngo/MTG-Store-Proof-of-Concept

MTG-Store-Proof-of-Concept

LIVE

Full-stack MTG retail platform concept with automated pricing, AI search, trade-in workflow, and decklist tools.

  • Full stack
  • Pricing
  • AI search
  • Retail
./GHT4ngo/FAB-Price-and-Trading-app

FAB-Price-and-Trading-app

LIVE

Application concept for checking Flesh and Blood card prices and making trades easier.

  • Cards
  • Pricing
  • dbt
  • Lovable

SQL assignments

./GHT4ngo/sql-assignments

sql-assignments

LIVE

Four structured SQL Server assignments covering validation, SCD2 warehouse ETL, index maintenance, and query-performance analysis.

  • T-SQL
  • ETL
  • SCD2
  • Performance

Utilities

./GHT4ngo/ai-token-tracker

ai-token-tracker

BETA

Track AI coding assistant token usage, model, estimated cost, and rate-limit events per project.

  • TypeScript
  • CLI
  • Telemetry
./GHT4ngo/sigkill

sigkill

WIP

Lightweight utility that monitors system memory and kills low-priority processes to keep a development environment responsive.

  • Utility
  • System monitoring
  • Developer tools