Projects
Kansas City Almanac
VISION: I'd like to have a fun weather dashboard for the family with Farmer's Almanac vibes that can be embedded into a Home Assistant dashboard.
PROGRESS: The initial thought was to do it all in Databricks - medallion architecture on Delta Lake, Workflows for orchestration, and Prophet for 14-day ML-driven forecasting, and AI/BI Dashboards. Since Databricks doesn't support public dashboard embedding, I took the opportunity to learn Grafana and rebuilt the dashboard there to pull live data from the Gold tables via Databricks SQL. With time I want to expand the metrics, add fun daily facts and holidays, and look into making the theme and UI more kid-friendly - Grafana does not seem to be a good fit here.
- Apache Spark
- Databricks
- Delta Lake
- Grafana
- Pandas
- Prophet
- Python
- REST APIs
- Linux
High Availability
It’s been a lot of fun building out a 3-node Proxmox cluster paired with a 3-node Kubernetes setup across physical machines. Seeing high availability work in practice (through quorum, failover, and recovery) has been great. I’ll continue to containerize more of my services, with the long-term goal of full redundancy and true high availability.
- Docker
- Kubernetes
- Linux
- Networking
- Proxmox
- System Administration
Growing Like Weeds
My kids are growing like weeds. This is just a simple Metabase dashboard fed by a few Postgres tables fed by a Python/Pandas script that pulls in new rows from Google Sheets fed by Google Forms.
- Python
- Pandas
- PostgreSQL
- Google Forms
- Google Sheets
- Metabase
- ETL
- Data Analytics
Drive.Refuel.Repeat
This is what happens when you pull out your phone to record gas tank refill data for nearly ten years. Ingestion is handled by Make.com from Google Forms entries into Supabase's PostgreSQL instance, which is then connected to Metabase.
Data cleaning and transformations are handled entirely in SQL.
- Google Forms
- Make.com
- Metabase
- PostgreSQL
- Supabase
- ETL
- Data Analytics
- DBeaver
4Q25 Environment Updates
VISION: To make my homelab situation look like I know what I'm doing.
PROGRESS: I've really enjoyed rebuilding everything in Proxmox VMs and setting up Tailscale for remote access as needed. For now, I am focused on creating an environment to allow experimentation with AI and to make it easier to kick off new projects. The next phase will be to enable deeper observability and resource monitoring with Grafana and Prometheus.
- AnythingLLM
- Dify
- Linux
- MCP server
- Moltbot
- Proxmox
- System Administration
- Tailscale
- Ubuntu Server
- Virtual Machines
BurmHub
VISION: A self-hosted CRM-inspired platform that centralizes family events, schedules, tasks, projects, and home automation. Ideally, it will integrate with an agent to support conversational querying of all family data.
PROGRESS: After trying out several self-hosted CRM and project management tools, I might just settle on NextCloud + Open WebUI + Postgres. Currently exploring the solutions and integrations offered within the app marketplace.
- AWS
- Budibase
- Data Lake
- Data Modeling
- DBeaver
- Dify
- Google Cloud
- Librechat
- Linux
- MCP server
- n8n
- Ollama
- PostgreSQL
- RAG
- SQL
- Warehouse Design
Poolboy Q
VISION: AI-powered pool chemical testing assistant that transforms emailed PDF reports into normalized, actionable insights. Leveraging a self-hosted LLM, it instantly analyzes pool data and generates step-by-step chemical dosing and maintenance instructions, delivered directly via email.
PROGRESS: Before this pool season, I will replace the single reviewer step with a voting process by multiple models, and I will replace the long system prompt with a proper RAG pipeline. Before I would've rated the output a 7/10 but I'm optimistic I can get this to a 9/10 since I saw major improvements after adding the review step.
- Docker
- Document Library / Vector Store
- ETL
- Google Cloud
- n8n
- Prompting
- RAG
- SQL
AI Lifeguard
VISION: AI-powered cameras monitor our pool area for unattended children.
PROGRESS: Experimenting with vision LLM models and testing frame-masking to boost accuracy. So far, frustrated with results, but optimistic modern models and hardware upgrades can get this done.
- DevOps
- Linux
- n8n
- Networking
- Python
Local AI
VISION: Build a private, self-hosted assistant to replace ChatGPT Claude and Google assistant for queries,
schedule & task management, collaboration, and home automation needs.
PROGRESS: Replaced AnythingLLM with OpenWebUI, upgraded to Qwen3.5 models, integrating Home Assistant with Ollama, and designing the RAG pipeline.
- OpenWebUI
- Linux
- n8n
- Ollama
- Python
- SQL
kWh Dashboard
A simple pipeline that used Python to log into the Evergy account when a new billing notification email was received, extract data from the API and eBill PDFs, and consolidate cost, usage, weather, and solar production metrics for monitoring and analysis. The locally hosted dashboard was powered by Metabase.
- API
- DNS
- FastAPI
- Github
- Linux
- Metabase
- Python
- SQL
- web hosting
Miles To Go
A Tableau story visualizing miles and costs over time between vehicles.
- Spreadsheets
- SQL
- Tableau
PMR
PMR (Preventive Maintenance Report) is a data visualization tool offering clients a metrics-first report following each contract maintenance visit.
- BlueFolder
- Spreadsheets
- macros
Skills
- AnythingLLM
- Apache Spark
- API
- AWS
- Azure
- BeautifulSoup
- BlueFolder
- bubble.io
- Budibase
- Cron
- data cleaning
- Data Analytics
- Databricks
- Data Factory
- Data Lake
- Data Modeling
- database
- DBeaver
- Delta Lake
- DevOps
- Dify
- DNS
- DNS Records
- Docker
- Document Library / Vector Store
- electronics troubleshooting/repair
- ETL
- FastAPI
- Github
- Google Cloud
- Google Forms
- Google Suite
- Grafana
- Kubernetes
- Librechat
- Linux
- macros
- Make.com
- MCP server
- Medallion Architecture
- Metabase
- n8n
- Networking
- Ollama
- Pandas
- PHP
- Podio
- PostgreSQL
- Prompting
- Prophet
- PSQL
- Proxmox
- Python
- QBO
- RAG
- Snowflake
- Spreadsheets
- SQL
- SSMS
- Supabase
- System Administration
- T-SQL
- Tableau
- Tailscale
- Ubuntu Server
- Unity Catalog
- various CRMs
- Virtual Machines
- Warehouse Design
- Webscraping
- web hosting
- Wordpress
- Zapier
- Zoho Suite