SQLite Query
A must-have tool for SQLite3 databases administration and data manipulation.
Please help to keep improving and developing of this freeware tool and consider Your donation. Thank You.

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.
Target platforms
Windows 2000
Windows XP
Windows Server 2003
Windows Vista
Windows 7
Windows Server 2008
Windows Server 2008 R2
Windows 8
Windows 8.1
Windows 10
Free to use for private, educational and non-commercial purposes.