DB Designer
Add tables and fields, choose types and constraints, then review PostgreSQL, MySQL or SQLite CREATE TABLE statements.
Up to 30 tables, 50 columns per table, 1 MB JSON. Identifier names: letters, digits and underscores; begin with a letter or underscore. SERIAL requires a single primary key. Save JSON before leaving this page.
A QUICK WALKTHROUGH
How to use this tool
- Add tables and edit their fields.
- Set primary keys, required values, uniqueness and references.
- Review SQL or save the design as JSON.
Local schema design
No database is connected. SQL is generated as text and must be reviewed before use. JSON saves this designer’s table and column model; SQL import and diagram image export are not supported. References must target a same-type single primary key or unique column. Cyclic dependencies between tables cannot be exported as SQL.
GOOD TO KNOW
Common questions
Can I load a saved design?
Yes. Load schema JSON with tables and columns. Invalid or oversized designs are rejected before replacing your work.
Does this run SQL?
No. All editing, JSON parsing and SQL generation happen in your browser.