Skip to content
All work

05 · Schema generator

AutoER

Business rules in, database schema out.

Database-first projects start with a whiteboard and a long conversation about what the business actually does. AutoER records that conversation as written rules and walks them through staged prompts — entities, then relationships, then constraints — until it can emit a schema.

Each stage is reviewable before the next runs, so the tool assists the modelling instead of replacing it. Built with PHP and the Gemini API; output is plain SQL for MySQL.

Year
2025
Role
Backend, prompt design
Stack
PHP, Gemini API, MySQL

Next project

go-football-core

A small Go backend, written to learn Go properly.