Database schema designer

Design your database. Visualize it. Generate the code.

SchemaForge is a free schema designer that runs in your browser. Draw tables and relationships, catch mistakes as you go, then generate SQL for four databases, migration scripts and EF Core classes.

No install. Your schemas stay in your browser.

SchemaForge showing a twelve-table online shop schema on the canvas, with tables, keys and relationships

Everything between “I have an idea” and “it’s in the database”

One tool for designing, checking, changing and using a schema.

Design

One SQL Server design, four databases

Design once in SQL Server terms, then pick the database you actually run. Types, defaults, identity columns and constraints are translated, and anything that can’t be expressed exactly is listed rather than silently changed.

  • SQL Server, PostgreSQL, MySQL and SQLite
  • Re-runnable scripts and optional comments and indexes
  • Import an existing T-SQL script to start from what you have
The SQL tab showing generated code with a dialect picker
Change

Migrations that know what they’re doing

Save a version, keep designing, and SchemaForge writes the script that turns the old database into the new one — and the script that undoes it.

  • Renames stay renames, so data isn’t dropped and re-created
  • Warnings for anything that can lose data or fail on existing rows
  • Compare with a saved version, another schema, or a script of your live database
A generated migration script with a warning about a new foreign key
Try

A real database in your browser

The playground builds a PostgreSQL database from your design, fills it with believable fake data that respects every key and type, and gives you a query box.

  • Starter queries written for your tables, including joins
  • Runs off the main page, so a slow query never freezes it — and you can stop it
  • 10 to 500 rows per table, new data in one click
The playground showing a join query result over generated shop data
Build

EF Core classes, ready for .NET

Get entity classes and a DbContext configured with the Fluent API so the model matches your design: names, types, keys, indexes, relationships and delete behaviour.

  • One file per class, or everything as a zip with the right folders
  • Namespace, naming and nullable options
  • Clear notes about what EF Core can’t express
Generated C# DbContext with Fluent API configuration
Assist

An AI assistant that shows its work

Describe a database or a change in plain words. You get a proposal with every change listed, checked by the same validator as your own edits. Nothing touches your schema until you press Apply, and it’s one undo step.

  • Design from a sentence, refine it, or ask for a design review
  • Explains a schema in plain language and answers questions about it
  • Uses your own Gemini key, kept only in your browser
The AI assistant with a request typed in and example suggestions

And the details that save you an afternoon

Small things that matter when the schema is real.

Mistakes caught as you type

Missing keys, mismatched types, bad names, impossible cascades — with a one-click fix for most of them.

Share a read-only link

The whole schema lives inside the link, so nothing is uploaded. Anyone can look, export, or save their own copy.

Export anywhere

PNG and SVG pictures, Mermaid for your docs, DBML for dbdiagram, and JSON to back up or move a schema.

Undo, versions, autosave

Every edit is undoable. Work is saved as you go, in your own browser.

Fast with big schemas

Tested with 100 tables and thousands of columns, with one-click auto-layout to tidy them.

Light and dark, any screen

Works on a laptop, a tablet or a phone.

Built to be checked, not just to look right

A schema tool is only useful if the output actually works. So it is tested against the real things.

Real databases

Generated SQL is run on real SQL Server, PostgreSQL, MySQL and SQLite, and what they build is compared with your design.

Migrations both ways

Random edits are applied to real databases with the migration script, then undone with the rollback — and the result must match.

Code that compiles

The generated C# is compiled with the .NET compiler, and EF Core builds the database from it to confirm it matches.

Free to use. A free account unlocks the extras.

Sign in with Google or an email and password.

No account neededWith a free account
  • Visual designer, validation and quick fixes
  • SQL for four databases, and SQL import
  • Versions and migration scripts
  • PNG, SVG, Mermaid, DBML and JSON export
  • Opening a shared link
  • AI assistant (design, review, explain)
  • PostgreSQL playground with fake data
  • EF Core code generation
  • Creating share links

Questions

Short answers.

Where is my data stored?

Your schemas are saved in your own browser, not on a server. Export a JSON file now and then as a backup — clearing the browser’s site data deletes them. If you create an account, only your email and name are kept (by the sign-in service). A share link carries the schema inside the link itself.

Does it connect to my database?

No. SchemaForge is design-first: you can import a T-SQL script of an existing database, and you take the generated SQL, migration or code to wherever you run it. It never holds your database credentials or your data.

Do I need an AI key?

Only for the assistant. You paste your own free Gemini key (from Google AI Studio) into its settings; it stays in your browser and goes only to Google. The assistant sends the structure of your schema — table, column and index names, types and comments, never data rows.

Which databases does it support?

You design in SQL Server terms and generate SQL Server, PostgreSQL, MySQL or SQLite. Where a database can’t express something exactly, the notes tell you what was changed.

Is the AI’s work reliable?

It can be wrong, which is why it only ever proposes. You see every change, SchemaForge checks the result with its own validator (and asks the model to fix its answer once if something is off), and you decide whether to apply it.

Does it work on a phone?

Yes — the layout adapts, and you can view, edit and export. A larger screen is simply nicer for big diagrams.

Open it and try the sample shop

Start from a template or import a script — it takes under a minute to see your schema on the canvas.

Open the app

Privacy

Your schemas are stored in your browser and are not sent to us. Accounts use Supabase: if you sign in we keep your email address (and your name and picture if you use Google) only to sign you in. The AI assistant, when you use it, sends the structure of your schema to Google’s Gemini service with your own key; use a key you can revoke. Share links contain the schema, so anyone who has the link can read it. We don’t run ads or sell data.