Download Letos (formerly SQLiteStudio) for Windows PC v4.0.4 for Windows PC

Letos 4.0.4 is the free, open-source SQLite database manager formerly known as SQLiteStudio: a visual schema and ERD editor, a scriptable SQL editor, data...

Features

• The ERD editor lets you design schemas visually and generate databases from diagrams, or turn an existing database into a clear, documentable relationship diagram.
• The SQL editor is a real working environment with syntax highlighting, code completion, query formatting and a full execution history for the queries you run.
• Scripting support, custom SQL functions, loadable SQLite extensions and plugins let repetitive imports, conversions and cleanups be automated instead of clicked through.
• Import and export cover CSV, JSON, XML, HTML and SQL scripts, and the data grid supports direct editing, sorting and filtering of table contents in place.
• It is completely free and open source under the GPL, needs no account, bundles the SQLite engine, and is also published as a portable build for USB use.

Considerations

• Letos manages SQLite databases only, so anyone who also works with PostgreSQL, MySQL or SQL Server servers will still need a second, general-purpose client.
• The interface is dense with panels, dialogs and configuration, which is more machinery than a beginner needs just to open a .db file and look at its tables.
• The SQLiteStudio-to-Letos rename means most existing tutorials, bookmarks and muscle memory use the old name, so help and downloads must be checked against letos.org carefully.

Letos, by Pawel Salawa (SalSoft), is the new name for SQLiteStudio: the rename came with the 4.0 generation, version 4.0.4 is the current release, and it continues the long-running free SQLite manager under the GPL, free for personal and commercial use. The rename has one practical consequence — most existing tutorials, bookmarks and muscle memory use the old name, so search both names for help, and check downloads against letos.org carefully. Under the name, nothing about the job changed: it covers the whole life of a SQLite database in one program, with the SQLite engine built in, so there is no separate installation or server — a database is a single file (.db, .sqlite or .db3) that you open or create.

The ERD editor alone separates Letos from simpler clients: you can design a schema visually, rearrange tables and relationships on a diagram, and generate the database from the picture — or reverse an existing database into a diagram worth putting in documentation. Schemas are also created and altered in a visual table editor, and table data is browsed and edited directly in a grid with sorting and filtering. For opening a file and browsing tables, simpler tools exist; Letos is what SQLiteStudio always was — the SQLite manager for people who have outgrown browsing tables and are designing, changing and documenting real schemas.

The SQL editor is a working environment rather than a text box: syntax highlighting, code completion, formatting and a full execution history for the queries you run. Power goes further with custom SQL functions, loadable SQLite extensions and a plugin and scripting system, so a conversion or cleanup you do every week can become a repeatable script instead of an afternoon of careful clicking, or repeated clicks. Import and export cover CSV, JSON, XML, HTML and SQL scripts, among other formats. The honest boundaries: Letos manages SQLite databases only, so anyone who also works with PostgreSQL, MySQL or SQL Server still needs a second, general-purpose client, and the interface is dense with panels and configuration — more machinery than a beginner needs just to open a .db file. This page provides the official Windows x64 installer from the project's GitHub releases, and a portable build is also published; it needs Windows 10 or 11 (64-bit) and 4 GB of RAM. For serious SQLite work on Windows, Letos is the heavy tool worth learning.

Download Letos-4.0.4-windows-x64-setup.exe from letos.org or the project's official GitHub releases (pawelsalawa/letos) using the button above.

Double-click the downloaded EXE, approve the Windows prompt and follow the setup wizard to install Letos 4.0.4. A portable build is also available on the same releases page if you prefer no installation.

Launch Letos, choose Database > Add a database to open an existing .db or .sqlite file — or create a new one — then browse its tables, open the ERD editor, or write SQL in the editor window.

What is SQLite Studio used for?

The program formerly called SQLiteStudio is now named Letos (the rename came with the 4.0 generation, and version 4.0.4 is current), and it manages the whole life of a SQLite database in one program: browse and edit table data in a grid, create and alter schemas in a visual table editor, and lay tables and relationships out in the ERD editor. Its SQL editor adds syntax highlighting, code completion, formatting and an execution history.

Is SQLite studio free?

Yes. Letos — the new name for SQLiteStudio, by the same developer, Pawel Salawa — is free and open-source software released under the GPL, free for personal and commercial use, with its source published in the pawelsalawa/letos GitHub repository. Alongside the Windows installer there is a portable build that runs from any folder or USB stick.

What is the best GUI tool for SQLite?

It depends on the work: DB Browser for SQLite is the simpler tool for opening a file and browsing tables, while Letos is the heavier, scriptable one — an ERD/schema diagram editor, a deeper SQL editor with completion and history, custom SQL functions, loadable extensions and plugin-based scripting. If you design or maintain SQLite databases regularly rather than occasionally inspecting one, Letos is built for that workload.

How do I use SQLite?

With Letos you do not install or run a separate SQLite server, because the engine is built in and a SQLite database is a single file on disk: open a .db, .sqlite or .db3 file (or create a new one), edit data directly in the grid, design tables in the visual editor, and run queries in the SQL editor. Import and export cover CSV, JSON, XML, HTML and SQL scripts.