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

SQLite 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.

SQLite File Association

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

Query Shortcuts