5

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

Improve this question
1

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

Improve this answer
2
  • 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
5

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

Improve this answer
1
2

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.

Improve this answer

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.