SQLite Query
A must-have tool for SQLite3 databases administration and data manipulation
Overview
Description

This tool provides complete management of any SQLite3 database.
It contains following modules:

  • SQL Editor
    It contains SQL Editor with syntax highlighting. You can run any type of sql statement or script. Output is flushed to formatted text, not to grid, what it allows more flexible and synoptic result overview.
    Any data producing statement can be exported to SQL, CSV or XML format (including BLOBs)
    Every correctly run statement is saved in SQL History Buffer. Result buffer supports minimap for quick orientation in large result sets and result folding (results for every run statement can be collapsed to one line - similar to code folding) You can open multiple instances of this editor to run "simultaneous" queries.
  • Table Editor
    Provides comprehensive and full-featured information about table structure, its indices, triggers etc.
    Here you can inspect, edit, export and import table data. It contains powerful Record and BLOB editor.
    Table data can be exported to CSV, SQL and XML (including BLOBs).
    Any data from CSV or XML (DataPacket 2.0) can be imported into table. Dynamic field assignment or auto-increment counter are available.
  • Trigger Explorer
    Here you can inspect every defined trigger and its source.
  • SQL History
    Here you can review every succesfully run statement.

Screenshots

OS compatibility
Windows XP
Windows 2003
Windows Vista
Windows 7
Windows Server 2008
Windows 8
Windows 8.1
Windows Server 2012
Windows Server 2012 R2
Windows 10
Windows Server 2016
Windows Server 2019
Pricing

ALL LICENSES ARE LIFETIME. REGISTERED USERS WILL RECEIVE ALL FUTURE UPDATES FOR FREE.

License
Free to use for private, educational and non-commercial purposes.
For other usage you should buy commercial license.
Version History