SQLite is a file, not a server, so connecting is the simplest of all: you point Schemity at the database file. This makes it a natural fit for a local ERD tool - both the database and the diagram are files on your disk.

Open the connection form

Choose New connection, set DB type to SQLite, and set Conn method to Direct connection. (SQLite has no network host, so SSH Tunnel is not offered.)

Database configuration field

  • Database file - click Click to select .sqlite file and browse to your .sqlite, .db, or .sqlite3 file.

That is the only field. SQLite has no host, port, username, password, schema, or encryption.

What gets imported

Schemity reads every table in the file: tables and columns with their SQLite types, primary keys and nullability, foreign keys (where defined) drawn as crow’s foot relationships, and unique indexes.

Opening a database read-only

To inspect a SQLite file without any chance of writing to it, right-click the saved connection and choose Open read-only. Schemity opens the file in read-only mode.

SQLite typing notes

SQLite uses flexible type affinity rather than strict column types. Schemity maps each declared type to one of SQLite’s storage classes (INTEGER, TEXT, REAL, BLOB, NUMERIC) so the diagram stays consistent.

Next

Clean up the layout on The ERD Canvas, or commit the diagram with Version Control in Git.