Hi, I'm Eric Burmeister.

data engineer - automation and systems enthusiast

Projects

Growing Like Weeds

STATUS: ONLINE

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

STATUS: ONLINE

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

STATUS: DEVELOPMENT

All servers have been rebuilt in Proxmox VMs, with remote access handled by Tailscale as needed. Next projects will include rebuilding Poolboy Q (before summer), improving AI Lifeguard after some hardware upgrades, and rebuilding BurmHub and BurmGPT with different tools entirely. For now, this is mostly to allow experimentation with AI (AnythingLLM, Dify, MCP server, Moltbot) and make it easier to kick off new projects.

  • AnythingLLM
  • Dify
  • Linux
  • MCP server
  • Moltbot
  • Proxmox
  • System Administration
  • Tailscale
  • Ubuntu Server
  • Virtual Machines

BurmHub

STATUS: UPDATING SYSTEM

A self-hosted CRM-inspired platform that centralizes family events, schedules, tasks, projects, and home automation. It eliminates reliance on external services (ChatGPT and Google), supporting automated data ingestion and conversational querying of all family data.

  • AWS
  • Budibase
  • Data Lake
  • Data Modeling
  • DBeaver
  • Dify
  • Google Cloud
  • Librechat
  • Linux
  • MCP server
  • n8n
  • Ollama
  • PostgreSQL
  • RAG
  • SQL
  • Warehouse Design

Poolboy Q

STATUS: UPDATING SYSTEM

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.

  • Docker
  • Document Library / Vector Store
  • ETL
  • Google Cloud
  • n8n
  • Prompting
  • RAG
  • SQL

AI Lifeguard

STATUS: UPDATING SYSTEM

When done, we will have a reliable AI-driven pool monitoring system that can trigger alerts/alarms when young children are unattended near our pool. LLM training will include drowning detection, but the focus is preventive, not reactive, measures.

PROGRESS: Actively training and refining the vision LLM, chaining multiple reasoning steps (detect people, identify children, check if they're alone, etc) and testing frame-masking to boost accuracy on real pool footage.

  • DevOps
  • Linux
  • n8n
  • Networking
  • Python

BurmGPT

STATUS: UPDATING SYSTEM

The vision is to build a private, self-hosted app to replace ChatGPT and Google assistant for queries, schedule management, collaboration, tasks, and home automation needs.

PROGRESS: Building custom web search guardrails, document chunking workflows, and data pipelines to support RAG-powered query and task automation.

  • DevOps
  • DNS Records
  • Librechat
  • Linux
  • n8n
  • Ollama
  • Python
  • SQL

kWh Dashboard

STATUS: INACTIVE - SOLD PROPERTY

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

STATUS: ONLINE

A Tableau story visualizing miles and costs over time between vehicles.

  • Spreadsheets
  • SQL
  • Tableau

PMR

STATUS: INACTIVE - SOLD COMPANY

PMR (Preventive Maintenance Report) is a data visualization tool offering clients a metrics-first report following each contract maintenance visit.

  • BlueFolder
  • Spreadsheets
  • macros

Searcher

STATUS: ONLINE

Searcher makes it easy to find replacement parts, diagrams, manuals, and manufacturer portals.

  • bubble.io
  • database
  • Spreadsheets

Skills