Web · Developer tool
Author — Next.js studio, React Flow visualization, LLM orchestration, optional Rust compressor
AI Schema Designer
Agentic PostgreSQL schema generation
What it is
AI Schema Designer takes a product brief and streams a Postgres schema you can actually ship: tables, relationships, indexes, triggers, functions, visualized in React Flow, with schema.sql and ARCHITECTURE.md on the way out. Generation goes through OpenRouter with retry/fallback; an optional Rust orchestrator compresses prompts.
The output is not a pretty ERD screenshot. It is files a backend can run.
Why I built it
Teams still sketch schemas in docs and then retype them in SQL. I wanted an agent that starts from intent and ends at export-ready DDL plus architecture notes.
Whom it is for
Backend and product engineers who need a first-pass (or tenth-pass) Postgres schema from a written brief, without starting from a blank migration.
Aim
Go from “here is the product” to tables, FKs, indexes, and docs in one sitting, with a graph you can inspect.
Goal
A tool that produces schema.sql you would not be embarrassed to open in review.
Hope
That schema design stays a conversation with the domain, and the mechanical DDL is generated, checked, and exported—not copied from a gist.
What it does
- Streaming LLM generation with retry/fallback via OpenRouter
- Exports schema.sql and ARCHITECTURE.md
Stack
Next.js · Rust · React Flow · OpenRouter