Letos
Letos is an open-source SQLite database editor for Windows users who need to inspect records, change database structures, and run SQL queries.
Operating system: Windows
Publisher: SalSoft Pawel Salawa
Release : Letos 4.0.3
Antivirus check: VirusTotal report
Letos gives developers, analysts, and database administrators a desktop workspace for working with SQLite files. It can be used to inspect databases, change records, build tables, and test queries while developing an application or reviewing stored information. A navigation panel lists database objects, so users can move between tables, views, indexes, and triggers without remembering object names or switching to a terminal.
Manage SQLite tables and queries in a graphical workspace rather than through a command line.
The program keeps database tasks in separate tabs and includes an SQL editor with highlighting and completion. A graphical tool offers another way to assemble queries, while a diagram editor helps map relationships between tables. Users can move data through CSV, SQL, XML, and JSON files, identify differences between databases, and bring them into alignment. Plugins and scripting in Python, JavaScript, or Tcl support additional workflows.
Features:
- Edit SQLite tables and records
- Write SQL with highlighting and completion
- Assemble queries using a graphical tool
- Transfer data in CSV, SQL, XML, and JSON formats
- Identify differences between database files
- Draw diagrams of table relationships
PROS
Table schemas and records can be edited visually.
Handles multiple SQLite databases in one window.
CONS
Encrypted databases require compatible SQLite extensions.