Schemity is a SQL Server ERD tool desktop application. Connect it to a Microsoft SQL Server instance and it introspects your tables and relationships into a diagram, all locally.
Open the connection form
Choose New connection, set DB type to SQL Server, and set Conn method to Direct connection (or SSH Tunnel to reach a database behind a bastion).
Database configuration fields
- Host and Port - the server address and port. Port defaults to
1433. - Username - the login Schemity authenticates as. SQL authentication is the simplest; read-only is recommended.
- Password - stored in your OS keychain, never in the JSON file.
- DB name - the database to introspect.
- Schema - the schema to read. Defaults to
dbo. - Encryption - either Disable (local dev only) or Require (recommended). Many modern SQL Server setups require encryption.
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 target schema: tables and columns with their SQL Server types, primary keys and nullability, foreign keys rendered in crow’s foot notation, unique constraints, indexes, and check constraints.
Next
Save your work to Git, or organize the schema with Legends & Annotations.