Design a MySQL or MariaDB schema visually
MySQL and MariaDB have their own vocabulary: storage engines, character sets and collations, ENUM columns, auto increment. DesignDB speaks it, and shows which features each of the two databases supports.
MySQL details covered
- Engines, character sets and collations per table.
- ENUM columns, auto increment and generated columns.
- Foreign keys with their ON DELETE and ON UPDATE actions.
- Indexes, unique constraints and check constraints.
Moving between databases
Started on PostgreSQL and now moving to MySQL? Switch the diagram to MySQL and DesignDB converts the types, then lists everything it changed or could not carry over (arrays, for example, have no MySQL equivalent).
Plans
Try it in your browser with no account: your diagrams stay in that browser. A free account saves up to 5 diagrams in the cloud, with up to 50 tables each. Importing and exporting SQL and other formats, sharing, comments and version history are part of Pro.
Schemas to start from
Questions
Does it support MariaDB separately from MySQL?
Yes. They are separate choices in the editor, so a feature one of them lacks is flagged when you pick it.
Can it write a migration for MySQL?
On Pro, yes: upgrade and roll back scripts, with notes on steps that can fail on existing rows or lose data, and files for Flyway, Liquibase, golang-migrate, dbmate and others.