Free SQLite IDE

qStudio is an SQLite IDE, that easily allows creating, opening and querying SQLite databases.

Load Existing Database

To open an existing sqlite database, go to File -> Open Database

Or by using our installer, in windows .sqlite and .db files become associated with qStudio and you can simply click to open them.

Double clicking a .sqlite or .db file will open it automatically in qStudio:

Running Queries

Once you have selected a SQLite file as the current connection you can use the below keyboard shortcuts to run commands against the file as shown below.

Query Shortcuts