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
![SQLite Open Database](images/sqlite-open-database.png)
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](images/sqlite-file-association.png)
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.
![SQLite SQL IDE](images/sqlite-running-query.png)
Query Shortcuts
![Query Shortcuts](/qstudio/help/images/query-shortcuts.png)