WinSQLite Editor

At a glance

WinSQLite Editor is a native Windows desktop app, written in C++ with Qt 6, for opening and editing SQLite database files. You can browse and inline-edit tables, write SQL in an editor with autocomplete, view tables as a diagram, and work with vector embeddings. It compiles in its own copy of SQLite and the sqlite-vec extension rather than relying on Qt's SQLite driver.

Good fit

A Windows 10 or 11 user who keeps embeddings in SQLite through sqlite-vec and wants to inspect them visually. The source includes a vector explorer, a projection step and a 3D scatter view next to the usual schema browser, row editor and create-table and create-index dialogs.

Consider something else when

You are on macOS, or you want a prebuilt Linux app. The README offers Linux build commands, but the ready-made downloads are the Microsoft Store, a portable GitHub archive and winget, and the platform badge names only Windows 10 and 11. Also skip it if your SQLite files never hold vectors and a familiar general-purpose browser already does the job.

Start here

Run winget install WinSQLiteEditor, or download the .zip or .7z from GitHub Releases, extract it and run the executable with no installer or admin rights. Open a .db file and check that its tables, triggers and indices appear in the schema browser before editing any rows.

Cost and requirements

The portable archive from GitHub Releases is free and has the same core features as the Microsoft Store edition, which adds automatic updates and one-click uninstall. Building from source needs Qt 6 (Core, Sql and Widgets), CMake 3.16 or later and a C++20 compiler such as MSVC 2022 or MinGW.

Limits to know

The README calls the project MIT-licensed, but the repository tree has no LICENSE file, so reuse terms rest on that statement alone. The "no telemetry" and "100% offline" claims are the author's own and are not backed by an audit. The build prerequisites list only Windows 10 and 11, even though the README also gives Linux build commands.

Related work

• SQLite: the database engine whose files this editor opens, and which it compiles in as its own static copy (context)

Still unclear

• Is the Microsoft Store edition free, or does it charge for the convenience of automatic updates?
• Which formats does the export dialog write?