
The Northwind example database is not the most interesting one for this feature. Select the database, then go to Diagrams | Show Visualization to see how your tables are connected (or not): One of the many helpful tools in DataGrip is the ER diagram viewer. If this is done, you can access your database: It is the only tool of the 3 that needs the extra step of downloading the driver to access your SQLite database. Those extra features come at the price of €89.00 for the first year. It also runs on Windows, Mac and Linux but offers significantly more features. With a bit more time to learn the tool I found the “ Data” tab that shows you the rows in your table without a detour to SQL:ĭataGrip from JetBrains allows you to access a wide range of database systems from various vendors. As I tried it the first time, I was a bit annoyed for the extra step to run the generated SELECT script. It runs on Windows, Mac and Linux with a more polished user interface and a higher update frequency. SQLiteStudio is very similar to DB Browser for SQLite. To view the data in your table, right-click on the table and select “ Browse Table” or go to the “ Browse Data” tab and select your table in the drop-down list:

A speciality of this tool is the create table script you find next to each table:

The database structure tab gives you an overview on your tables and indices.

You can connect to an existing SQLite database or create a new one. Today I give you a quick overview on 3 no-code tools to explore your SQLite databases.ĭB Browser for SQLite runs on Windows, Mac, Linux and FreeBSD.
#DB BROWSER FOR SQLITE ADD ROW DRIVERS#
Not only does it have drivers for all current programming languages, but it also works without the hassle of creating a server to host it. SQLite is a great little database for all kinds of personal data storage.
