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

3 Answers 3


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. Commented May 13, 2019 at 14:28
  • 1
    Glad I could help
    – Thomas
    Commented May 13, 2019 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

  • There are plenty of apps which will let you modify an existing database, which this answer does not claim. Since you accepted this answer, I won't go into detail, but GIYF (my personal recommendation is sqlitestudio.pl/index.rvt?act=gallery)
    – Mawg
    Commented Sep 14, 2018 at 10:51

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 and acknowledge you have read our privacy policy.

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