SQLite Inspector Plus - A portable windows tool for view and editing SQLite database files

Above is a screenshot of SQlite Inspector.

Download SQLite Inspector Plus here

Version 1.0.4 • Portable • Windows

Download Here

SQLite SQL

SQLite has a rich and powerful SQL language built it. Here are some useful generic examples which can be used in the Query screen: 

 SELECT name 
 FROM sqlite_schema 
 WHERE type = 'table' 
 AND name NOT LIKE 'sqlite_%'
 ORDER BY name;
 SELECT name, tbl_name
 FROM sqlite_schema
 WHERE type = 'index'
 ORDER BY tbl_name; 
 SELECT sql
 FROM sqlite_schema
 WHERE type = 'table'
 AND name = 'your_table_name'
 PRAGMA table_info('your_table_name');

 PRAGMA index_info('your_index_name');

About SQLite Inspector Plus

SQLite Inspector Plus is a portable SQLIte database viewer, editor and querying tool for Windows.


It allows database developers to quick and easily open an SQLite database with the .db or .SQlite file extensions and immediately see a list of tables and views within it. The developer can edit values in those tables, add or delete rows.


SQL Statements and Queries

SQL Queries can be performed in the query windows such as SELECT / UPDATE / ALTER / INSERT and DELETE. Select query can also be saved as Views and exported to various formats such as CSV etc.


SQLite SQL Query

SQLite Databases

Only one database can be opened per session but you can temporarily attach another database and therefore view and query the tables together. To attached another database click the tool button circled in red in the screen shot below. Select the database file and give it a brief name in the box on the dialog circled in red.

SQLite Attach database


After the additional database has been attached if you refresh the tables list you will see the tables from the attached database listed with the database alias name you specified prefix at the beginning of the table name. See the screen shot below. These additional tables can also be queried in the query screen using this prefix.

To remove the attachment simple click detach on the main tool bar.

Other features include Adding tables, Indexes, backups, export and table info.

Feedback on SQLite Inspector Plus

This is the beta version of this new tool so expect bugs. If you do get an unexpected error message then contact me and I'll try and fix it as soon as possible. I also have lots of new features planned for this tool so if you would like to see a particular feature let me know so that I can prioritize it if it's already on my list.


As SQLite Inspector is a new tool I would appreciate feedback. Let me know if you get any unexpected errors or a feature doesn't work correctly. Just send an email to alexnolannet@gmail.com and ideally attach a screen shot showing any problems or errors.



All Content Copyright 2004- alexnolan.net. All Rights Reserved