I would like to have a software tool to create/modify/view table relationships in a SQLite database in a visual way, something like the picture below. For a MySQL database, I can use the MySQL workbench to view 1-to-many relationships. Is there an equivalent tool for SQLite?

example image


Dbeaver is also a great tool to work with databases including SQLite and can visualize the relations between tables

  • 1
    Great software recommendation. I have changed the best answer to yours. – user1824987 May 13 '19 at 14:28
  • 1
    Glad I could help – Thomas May 13 '19 at 15:17

The viewing part can be achieved using SchemaCrawler; amongst its features, it generates database diagrams. It supports various database formats, including SQLite. Disclaimer: I haven't used it (yet).

Here is an example image, found on the roman10 website.

enter image description here


Datagrip by jetbrains supports SQLite. I've used it for other (MySQL, Oracle) types of databases, and it's been good. However, I haven't used it for SQLite.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.