A Windows desktop manager for SQLite databases, built with .NET 10 and WinForms. It has an Office-style ribbon, a SQL editor, visual table and query designers, import and export, and saved jobs that you can run from the app or from the command line.
| Query editor | Query designer (dark theme) |
|---|---|
![]() |
![]() |
Download the latest zip from Releases, unzip it anywhere, and run SqliteManager.App.exe. The .NET runtime is included. The command-line job runner, SqliteManager.Cli.exe, is in the same folder.
- Databases: create, open, or open read-only. Work with several databases at once, attach other files (autocomplete knows their tables), and reopen recent files.
- Object explorer: tables, views, indexes, and triggers. Tables expand to show columns, keys, and indexes. Script as CREATE, INSERT, or DROP. Rename and drop objects (drops ask first).
- Data grid: browse large tables quickly with a virtual grid. Filter, sort, and edit cells. Insert and delete rows, set NULL, and view or edit BLOBs as hex, text, or images. Changes are written together in one transaction.
- Query editor: syntax highlighting, autocomplete, and folding. Run all, the selection, or the statement at the caret, and cancel a running query. Each result set opens in its own tab. Also includes query history, Explain Plan, and opening and saving
.sqlfiles. - Table designer: edit columns, indexes, foreign keys, and constraints. The SQL is previewed before you apply it. Changes that SQLite's
ALTER TABLEcannot make rebuild the table and keep the data, triggers, and views. - Query designer: a visual designer in the style of Microsoft Access. Drag tables onto the canvas, draw joins, tick columns, and type criteria, totals, and sorting. Then run the query or send its SQL to a query tab.
- Import and export: import CSV, TSV, Excel (
.xlsxand.xls), and JSON. Export to CSV, TSV,.xlsx, JSON, or a SQL script. - Saved jobs: imports, exports, and SQL scripts with parameters. Each run is added to the run history.
- Maintenance: VACUUM, ANALYZE, integrity and foreign key checks, a PRAGMA editor, and online backup.
- SQL log: every statement the app runs is shown in the SQL Log pane.
- Light and dark themes.
You need Windows 10 or 11 and the .NET 10 SDK.
dotnet build SqliteManager.sln
dotnet run --project src/SqliteManager.App
Run the tests:
dotnet test SqliteManager.sln
SqliteManager.Cli runs jobs that were saved in the app, so you can schedule them with Windows Task Scheduler.
SqliteManager.Cli list
SqliteManager.Cli run --job "Monthly Payout Export" --param @Period=2026-10
SqliteManager.Cli run --job "Load Rep Roster" --job "Monthly Payout Export"
| Option | Meaning |
|---|---|
--job <name> |
A job to run. Repeat to run several jobs in order. |
--param @Name=value |
A parameter value. Repeat for more parameters. |
--jobs-file <path> |
Use this jobs file instead of the default one. |
--history-file <path> |
Write run history to this file instead of the default one. |
The exit code is 0 when every job succeeds and 1 when a job fails.
Settings, jobs, and history are kept in %APPDATA%\SqliteManager\:
| File | Contents |
|---|---|
settings.json |
Options, recent files, window layout, and theme |
jobs.json |
Saved jobs |
history.jsonl |
Job run history |
query-history.jsonl |
The last 1,000 queries run in the editor |
SqliteManager.sln
src/SqliteManager.Core/ Database, schema, DDL, import/export, and job logic
src/SqliteManager.App/ WinForms user interface
src/SqliteManager.Cli/ Command-line job runner
tests/SqliteManager.Core.Tests/ xUnit tests for Core
docs/SPEC.md Full specification
The app and the CLI share the job engine in Core. All SQL lives in Core, values are always passed as parameters, and every identifier is quoted.
Microsoft.Data.Sqlite, Scintilla5.NET, ClosedXML, ExcelDataReader, CsvHelper, and xUnit.
This project was developed with Claude Code.


