SQLiteStudio 2.1.5 / 2.99.1 Beta

A practical and useful application that helps you to manage as many SQLite databases as you want and add new tables, triggers and indexes
SQLiteStudio is a comprehensive and reliable SQLite database manager that provides you with a simple means of managing the contents of each database, including tables, triggers and views.

The application comes with an intuitive interface and well-organized menus. Since it does not require you to install it, all you have to do is to double-click the installer and start managing your SQLite databases effortlessly.

The left panel displays all of the available databases along with their data. The hierarchical tree view allows you to select any table, trigger, procedure or statement and view the data in the main window.

From the ‘Databases’ menu you are able to open a new *.db, *.sdb, *.sqlite or *.db2 file and connect to it using the right-click menu. Additionally, you can import schema from other databases or from various file formats such as CSV and dBase. After that, you can view all the existing data and manipulate it the way you want.

The Tables menu allows you to erase data, as well as create a new table and populate it by specifying the number of rows you want to add. In case you want to insert a new table in the existing database, you need to choose the proper options, then specify the table name, set table constraints and add as many columns as you want.

By using the ‘SQL query editor’ option, located in the Tools menu, you are able to manually create your SQL scripts and execute them. In this manner, you can view specific information from each table, or gather data from multiple tables using INNER JOIN statements.

Also, you can add a new trigger for the selected database by specifying its name, choosing its action, then writing the proper code.

In closing, SQLiteStudio comes in handy for users who need to manage and alter SQLite databases by inserting new tables, views, triggers and indexes.

Reviewed by , last updated on October 27th, 2014

file size:
5.3 MB
developed by:
Pawel Salawa
license type:
operating system(s):
Windows All
C: \ Internet \ Servers \ Database Utils
download hub:
SQLite Clients


In a hurry? Add it to your Download Basket!

softpedia rating


user rating 24



Rate it!
13 Screenshots
SQLiteStudio - From the main user interface of SQLiteStudio you can browse through the current database.SQLiteStudio - Add a database by using this window and providing a name and the database version.SQLiteStudio - The Edit Table window enables users to add, edit or delete columns and configure table constraints.SQLiteStudio - From the context menu users can add a new database, edit tables, create new triggers or export tables.SQLiteStudioSQLiteStudioSQLiteStudioSQLiteStudioSQLiteStudioSQLiteStudioSQLiteStudioSQLiteStudioSQLiteStudio
What's New in version 2.99.1 Beta
  • What is not the same:
  • The performance. Application is more responsive, deals with executing queries in background, deals with huge data sets way better than 2.1.x.
  • DDL preview dialog and DDL history window - from now on you can track what changes are done to the database, before they are done by dialog windows. Even if you ignore such preview dialogs, you will always be able to see all DDL changes in the DDL history window!
  • Entering data into forms/dialogs is now validated on the fly - as soon as you type invalid input, you will see a red icon indicating the problem and you can hold mouse over it to see details of the problem.
read full changelog

Application description

SQLiteStudio is a handy tool that was designed in order to assist you in managing the contents of your SQLite database...

Add your review!