Alternatives to Letos
A free, open-source desktop app for creating, editing and browsing SQLite databases, formerly SQLiteStudio. The listings below can replace it for an important use case. Each note says what changes if you switch.
The original
Letos
A free, open-source desktop app for creating, editing and browsing SQLite databases, formerly SQLiteStudio.
Replacements
Listings that take over the same core job as Letos.
DB Browser for SQLite
Opens a SQLite file in a spreadsheet-like window so you can look at the data without writing SQL.
DB Browser for SQLite offers spreadsheet-style editing, CSV import and plotting, and adds FreeBSD, but releases are infrequent and large databases make the grid sluggish.
DBeaver Community
One database client for more than a hundred databases, with a proper SQL editor and ER diagrams.
DBeaver handles SQLite alongside more than a hundred other databases with ER diagrams, but it is Eclipse-based, heavy and slow to start.
DbGate
One database client for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite, Redis and a dozen more, on desktop or as a web app.
DbGate covers SQLite plus many SQL and NoSQL engines on desktop or Docker, but it is Electron-based and some connectors are premium-only.
Antares SQL
An open-source desktop SQL client for MySQL, PostgreSQL and SQLite with a focus on usability.
Antares SQL is a free open-source client covering SQLite, MySQL and PostgreSQL, from a smaller project with a small contributor base.
Beekeeper Studio
A SQL client that is pleasant to look at and works the same on Windows, macOS and Linux.
Beekeeper Studio supports SQLite and many other databases with a modern interface, but it runs on Electron and some features are paid.
TablePlus
Native database client for many engines with a clean interface.
TablePlus is a native multi-engine client that also runs on iOS, but it is closed source and the free tier limits tabs and connections.
Similar software
Related functionality, not a direct replacement.
SQLite
A small, self-contained SQL database engine that stores a whole database in one file.
LiteCLI
A command-line SQLite client with auto-completion and syntax highlighting.
sqlite-utils
A Python command-line tool and library for creating, querying and transforming SQLite databases.
Datasette
Publishes SQLite databases as an explorable website and JSON API.
Tad
A desktop viewer for CSV and Parquet files and SQLite and DuckDB databases, with pivot tables.
VisiData
An interactive terminal multitool for exploring, cleaning and converting tabular data in many formats.
