Schemity works as a MySQL schema visualizer desktop application. Point it at a MySQL or MariaDB database and it introspects the structure into an ERD, entirely on your machine.
Open the connection form
Choose New connection, set DB type to MySQL, and set Conn method to Direct connection (or SSH Tunnel for a database behind a bastion).
Database configuration fields
- Host and Port - the server address and port. Port defaults to
3306. - Username - the account Schemity authenticates as; read-only is recommended.
- Password - stored in your OS keychain, never in the JSON file.
- DB name - the database to introspect. In MySQL the database is the schema, so there is no separate Schema field.
- Encryption - either Disable (local dev only) or Require (recommended).
If you chose SSH Tunnel, an extra block asks for the SSH host, port (default 22), username, password, and an optional SSH key file.
What gets imported
Schemity imports every table in the database (no selection step): tables and columns with their MySQL types, primary keys and nullability, foreign keys drawn as crow’s foot relationships, unique constraints, and indexes.
A note on foreign keys
Tables using the MyISAM engine do not enforce foreign keys, so none may appear in the metadata. Schemity still imports the tables; you can draw the missing relationships by hand on the canvas. See Relationships.
Next
Tidy the imported diagram on The ERD Canvas, or split it into focused Context Views.