Letos for Windows
Letos: portable SQLite manager with visual ERD and SQL tooling
- Free
- 4.8
- 5
- V 4.0.3
Letos: portable SQLite manager with visual ERD and SQL tooling
Letos opens SQLite files in a portable GUI, combining an SQL editor, ERD designer, and multi-database browser in one workspace. Paweł Salawa maintains the project as a desktop utilities tool, preserving portability and cross-platform builds. Key capabilities include syntax-highlighted SQL editing, visual schema design, and import/export to CSV, JSON, XML, PDF, and HTML. Developers, DBAs, and data students benefit from visual schema work and scriptable custom functions.
What Letos performs when you open a database
Letos manages SQLite databases by letting you create, edit, and browse tables, views, and indexes through a graphical interface. The tool supports both SQLite3 and legacy SQLite2 files, offers an integrated ERD editor for visual schema layout, and runs SQL with syntax highlighting, code completion, and error logging. Imports and exports include CSV, SQL, PDF, HTML, JSON, and XML, which covers common interchange formats.
How it interacts with the host system during use
Letos runs without installing and does not modify the Windows registry, so it can run from a USB stick or a local folder. The portable design avoids administrative privileges during launch. The application is built in C++ with Qt, which explains the lightweight footprint referenced by its portable distribution and the ability to run on 32-bit and 64-bit desktop systems.
Is it safe to operate on production databases
Letos offers configurable safety options through plugins and scripting isolation: encryption extensions such as SQLCipher and SQLite3MultipleCiphers load via plugins, and custom functions can run in Python, JavaScript (QtScript), or Tcl. The plugin architecture separates optional features from core browsing, and the project’s open-source GPLv3 licence makes internal behavior inspectable before use on important data.
Who should adopt Letos
Letos is an effective choice for technical users who need portable, visual control of SQLite files and scripting access for custom work. The tool demands basic database knowledge to make full use of the ERD editor and scripting hooks, but it rewards that investment with a portable, inspectable toolkit. Recommended.
Pros
- Built-in ERD editor for visual schema design
- Portable, zero-install operation without registry changes
- Supports CSV, SQL, JSON, XML, PDF, and HTML import/export
- Plugin support for SQLCipher and additional extensions
Cons
- Requires database knowledge to use ERD and scripting safely
- Plugin model needed for some encryption support
- Solo-maintained project may limit rapid feature expansion
Letos for Windows
- Free
- 4.8
- 5
- V 4.0.3