ROADMAP + BUILD LOG

What we're building, and why.

What's shipped, what's next, and the reasoning behind the calls made along the way.

shipped
planned
exploring
THE PATH

Roadmap

SHIPPED
Core ER canvas + DDL parser

Paste PostgreSQL, MySQL, SQL Server, or SQLite DDL and get an interactive diagram: table nodes, PK/FK badges, auto-layout, pan/zoom, and a minimap. Parsing runs entirely in your browser — the DDL never touches a server unless you run an AI feature.

SHIPPED
Structural gap detection

Deterministic checks for missing FK indexes, orphan tables, and relationships inferred from naming conventions but never formally declared — shown as dashed amber edges next to solid green ones, each ranked by severity.

SHIPPED
Projects, versions & the review workflow

Projects → Collections → Saved DDLs, an append-only version history per schema, a Draft/Ready status pill, and a dashboard queue of ready-for-review schemas with diff summaries and AI-drafted Change Requests.

SHIPPED
AI Engineer & AI Designer

Two Gemini-backed modes: AI Engineer finds and fixes problems in an existing schema as a selectable checklist; AI Designer proposes new tables and columns from a plain-language description. Both stage changes as a diff you accept or discard — nothing lands unreviewed.

SHIPPED
Free/Pro billing

Stripe checkout, a customer portal, and a monthly Gemini token cap (50K Free / 1.5M Pro) — the only difference between tiers. The canvas, gap detection, projects, version history, and the review workflow are unlimited on both.

SHIPPED
Public docs

17 articles across 6 categories covering the whole workflow, no sign-in required.

PLANNED
Live DB connection import

Point at a real Postgres or MySQL database and get a schema instantly, instead of hand-pasting a DDL snapshot. Read-only, SSL-required, and the connection string is never stored.

PLANNED
GitHub PR check

A GitHub App that runs gap detection against a schema file on every pull request and posts the diff summary as a comment, linking back into the full diagram.

PLANNED
Migration SQL from the diff

Forward and rollback ALTER TABLE statements generated from a schema's diff, sitting next to the existing Change Request text instead of stopping at prose.

PLANNED
Public shareable diagram links

A read-only URL for any schema, embeddable in a README or a Notion page. Every schema is strictly private today.

PLANNED
In-app feedback

A lightweight bug/feature-request form inside the app — right now the only channel is replying to a transactional email, which nobody does.

EXPLORING
ORM & type export

Generate a Prisma schema, Drizzle schema, SQLAlchemy models, TypeScript interfaces, or Zod/Pydantic validators straight from the parsed schema, no AI required.

EXPLORING
Ask your schema a question

Natural-language-to-SQL, grounded in the actual tables, columns, and relationships already on the canvas.

EXPLORING
Per-project sharing

A members list per project — every project is single-owner today. The foundation a future team plan would sit on.

EXPLORING
PII/compliance scan

Flag columns that look like personal data and missing constraints around them, as a new category alongside the existing structural and AI-found issues.

BUILD LOG

Developer notes

Notes from building this — the reasoning, not just the changelog.

GAP
No email verification or account deletion yet

Password reset has its own flow, but there's still no way to verify your email, change it, or delete your account from inside the app. Reach out if you need an account removed in the meantime.

TRADEOFF
The account page got folded back into the dashboard

A standalone /account page ended up feeling like a second, half-empty dashboard sitting next to the real one. Its content — account info, subscription, AI usage — now lives directly on the Overview page, and /account just redirects there.

DECISION
Compare DDLs got removed, not fixed

The side-by-side DDL diff tool wasn't landing well in practice. Rather than iterate on it indefinitely, it was pulled entirely, with no replacement planned right now.

DECISION
AI usage is the only thing that's paid

The diagram canvas, gap detection, projects, version history, and the Draft/Ready workflow are unlimited on both tiers. Storage and workflow features don't cost enough at Free-tier scale to justify gating them, and feature-stripping against free ERD tools would hurt adoption more than it protects revenue.

DECISION
AI caps are a token budget, not a call count

A one-table schema and a fifty-table schema cost wildly different amounts to analyze. Tracking exact Gemini tokens (50K Free / 1.5M Pro monthly) instead of a flat number of runs means the cap actually tracks cost instead of penalizing bigger schemas.

shaped by what actually breaks in real schemas ✦

Find the gaps before
production does.

Paste a schema and see your first analysis in under ten seconds.

ERD Factory

Schema visualization & analysis for people who ship databases.

© 2026 ERD Factory