Track record

Selected work, with the numbers.

Most of this work runs in our own engineering lab and reference installation in Gauteng. Figures are from October 2026. Each item shows whether it is live or still in build.

SQL Server and data

Data models and SQL Server tooling.

SQL ServerIn build

Data-integration model on SQL Server and PostgreSQL

T-SQL · PostgreSQL · .NET · Python

A model that lands, resolves, reconciles and corrects incoming data. It is built for SQL Server first. Every migration is also written for PostgreSQL. It is tested with synthetic data only.

  • 200 tables in 14 schemas, with 147 views, 77 functions, 85 procedures and 135 triggers.
  • 197 versioned migrations per engine: 71,279 lines of T-SQL and 66,086 lines for PostgreSQL.
  • 456 foreign keys and 385 CHECK constraints enforce the rules inside the database.
  • Built on SQL Server 2022 and PostgreSQL 17 under a written engine-parity declaration.
  • 485 tracked requirements with 0 dependency cycles.
  • A simplification review identified the 105 to 110 core tables, with each shortcut tested.
SQL ServerIn build

Gated SQL Server automation agent

Python · .NET ScriptDom · tSQLt · Docker · Temporal

An agent toolkit for data modelling, T-SQL, tuning and DBA tasks. Every query passes five gate layers before it reaches a server.

  • Default-deny policy, ScriptDom parse checks, signed procedures and a kill switch.
  • 958 tests passed across 11 suites, including 415 T-SQL tests.
  • Lab servers on SQL Server 2022 and SQL Server 2025, with full-text search.
  • Covers plan forcing, maintenance frameworks and schema drift checks.
  • Four independent reviews. Every high and medium finding was fixed.
SQL ServerIn build

Voice-driven 3D data model studio

C# · .NET 10 · 3D browser app · voice

A studio that explains a SQL Server data model by voice and in 3D: table relationships, data lineage and live data flow.

  • Its walkthrough case is the 200-table data-integration model above.
  • Release V0.3.30 reached user acceptance testing.
SQL ServerIn build

Workflow platform on SQL Server or PostgreSQL

C# · .NET 10 · RabbitMQ · Camunda 8 · Blazor

A self-hosted workflow platform with a live operations console. It runs on SQL Server or PostgreSQL.

  • 148 SQL files under version control.
  • About 3,000 automated test methods.

Home automation

Home Assistant and local-first control.

Home AssistantLive

Live Home Assistant installation

Home Assistant · Node-RED · Python · Hyper-V

Design, operation and audit tooling for a full Home Assistant house, with a local web console.

  • Audit on 16 October 2026: 259 devices, 24 areas, 42 automations and 988 entity states.
  • Propose, approve, execute: locks, gates, the alarm, geysers, climate and power need the owner to confirm each action.
  • Daily automatic backups and a written restore runbook.
Home automationIn build

Local-first home hub

Python · Flutter · provider simulators

A multi-hub home controller that keeps working on the local network when the cloud is down. Solar and energy management is in design.

  • Live hub with 82 entities, with cloud and local network paths reconciled.
  • Milestones M0 and M1 reached: the core platform running with two hubs.
  • Provider simulators test every integration without real devices.
  • The first prototype matched 30 cloud devices to 46 local network nodes, and switched a real outdoor light on and off with zero errors.
Home automationIn build

Home control plane with a tamper-evident log

C# · .NET · Blazor · PWA

A self-hosted control plane. Capabilities, workflows and policy run over one bus. Every decision goes into a hash-chained event log.

  • 2,447 of 2,455 tests pass at the October 2026 release gate.
  • Phone, tablet and desktop interface: 36 screens and 429 interface tests.
  • 0 accessibility violations (axe) across 528 phone page runs.
CamerasIn build

Camera system steward

Python · Blue Iris 6 · RTSP · NVR

Inventory, probing and set-up for a multi-camera IP system on a network video recorder.

  • 28 recorder channels inventoried.
  • 27 of 28 main streams verified by RTSP probe.
  • Blue Iris recording and AI alert set-up in progress.

Media

Music and audio.

MediaIn build

Generative music engine

C# · .NET · web interface · casting

An endless generative music engine with live kaleidoscope visuals and casting to TVs.

  • 214 genres.
  • More than 100 instruments.
MediaLive

Self-hosted music server and song library

Docker · Navidrome · Python

A private music server over HTTPS, with a library, creator and player for AI-generated songs.

Platform and integration

The services that hold it together.

IntegrationLive

Single sign-in portal

nginx · Authelia · web app

One sign-in page with two-factor authentication in front of every self-hosted service.

  • 46 proxy routes: production and development for 23 services.
IntegrationIn build

Encrypted mail store

C# · .NET · SQLCipher · age encryption

An encrypted, multi-account mail store that receives signed, encrypted packages through an API.

  • 118 automated tests pass. Tested with synthetic mail only.
SoftwareLive

PC maintenance console

C# · .NET · named-pipe service

A live monitor of CPU, memory and GPU use per process, with controls.

  • Samples every 2 seconds and keeps 14 days of per-minute history.
SoftwareLive

Local voice assistant

Python · local language model · voice

A local-first assistant that answers by chat and by voice call.

  • 141 tests passed at the last release.

How this work was built: AI-assisted engineering with Claude Code, with several agents working in parallel under automated tests and human review.