SQLite Expert Professional 5.4.11.554 + Portable

The graphical interface supports all SQLite features. It includes a visual query builder, an SQL editor with syntax highlighting and code completion, visual table and view designers and powerful import and export capabilities.

Visual SQL Query Builder
- Build complex SQL queries with ease.
- Formatted SQL query text layout.
- Powerful means of SQL query parsing and analysis.
- Advanced SQL editor with syntax highlighting and code completion.

Data editing
- Edit data in the grid using powerful in-place editors.
- Image editor currently supporting JPEG, PNG, BMP, GIF and ICO image formats.
- Visualize and modify BLOB fields using the integrated Hex editor.

Powerful restructure capabilities
- Visual editors for table columns, indexes, foreign keys, triggers, unique and check constraints.
- Restructure any complex table without losing data.
- Any restructure operation is wrapped in a nested transaction which is rolled back if any errors occur when applying changes.

Import and Export data
- Import data from ADO data source, CSV files, SQL script or SQLite.
- Export data to CSV files, SQL script, Excel or SQLite.
- Copy tables between SQLite databases using drag and drop operations.
- Export data to Excel via clipboard.

Other features
- Full Unicode support.
- Support for attached databases.
- Supports SQLite extensions and third-party SQLite libraries.
- Lua and Pascal scripting support.

What's new

Homepage