Studio
Black Friday

Up to 70% off kits30% off services

Ends in
Case study · Full stack

KastorDataDatabase changes shipped like code, reviewed first and always reversible.

A data platform built end to end on Next.js, Supabase and OpenAI, where every database change is reviewed on a branch and can be rolled back in one click.

The KastorData dashboard with performance metrics, user activity and a table of recent users
Type
Full stack
What we did
Design, architecture and build
Delivered
Web platform, Data workflows, AI impact reports
Built with
  • Next.js
  • Supabase
  • PostgreSQL
  • OpenAI
  • AWS Lambda

Results

What changed after launch

Fewer production schema incidents
95%
Faster migration approvals
3.5x
Of releases covered by automated rollback
100%
Lower cloud compute costs
40%

The problem

Schema changes went straight to production.

  • Schema edits applied straight to production broke dashboards and metrics.
  • There was no easy way to see the blast radius or cost of a change before running it.
  • Rolling back a failed backfill meant slow, manual recovery scripts.

The solution

What we built

  • A Write, Audit, Publish workflow on isolated branches.
  • Impact packs calculated by AWS Lambda workers and summarised with OpenAI.
  • Rollback tags on every release, with one click to revert.
  • One catalog for tables, lineage, usage and access rules.

The parts that matter most

01

Changes start on a branch

Write, audit, publish: nothing touches live data until it is reviewed.

02

Impact packs

Affected tables, cost changes and health checks before release, summarised by AI.

03

One-click rollback

Every release is tagged, so the team can revert in seconds.

What this shows

We build on a modern stack, Next.js, Supabase and OpenAI, and make it safe, fast and ready to grow.

The services behind this project

Use one service on its own, or all of them with one team from the first workshop to launch.

More work

Other products we designed and built

All client work

Building something like this?

Tell us about your product. A short call on your goals, users and must-have features, then a scope, timeline and fixed quote within a week.