# little-brother/sqlite-gui

Lightweight SQLite editor for Windows

Repository: https://github.com/little-brother/sqlite-gui
Canonical: https://ross.abutalabs.com/products/sqlite-gui
Language: C
License: GPL-2.0
License Family: copyleft
Topics: sqlite, sqlite3, administration, winapi, sql, tool, windows, database, database-management, manager, editor, gui
Last push: 2025-05-20T18:47:21+00:00

## Health v2 (maintenance only)
Score: 33/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 22, release rhythm 8, longevity 100
- inputs: {"age_days": 2363, "days_push": 470, "days_rel": 470, "gap_med": 189, "n_releases_24m": 2}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1247, forks 58 (observed 2026-08-28T04:04:07.643676+00:00)

## What it is
A lightweight, portable SQLite editor and database management tool for Windows, built with C++/WinAPI. It offers SQL editing with syntax highlighting, data grid editing, import/export, charts, and a built-in REST API server without requiring installation.

## Use cases
- edit sqlite database on windows
- browse and edit sqlite tables with a gui
- run sql queries against sqlite with syntax highlighting
- export and import sqlite data
- compare two sqlite databases
- generate test data for a sqlite table
- query sqlite via a rest api
- visualize sqlite query results as charts

## When to choose
- you need a free, no-install SQLite GUI on Windows
- you want a fast, small native tool instead of an Electron-based editor
- you need extras like data generation, database comparison, or cross-database ODBC queries
- you want a built-in REST API server on top of a SQLite database

## When to avoid
- you work on macOS or Linux - it is Windows-only
- you need a full database administration suite for other database engines
- you require a web-based or collaborative database client

## Facets
- artifact type: application
- maturity: active
- function: gui, editor, database, data-visualization, developer-tools
- domain: databases, developer-tools, windows, data-visualization
- platform: windows
- tags: sqlite, sqlite-editor, database-management, winapi, sql-client, portable, no-install, desktop

## Member repositories
- little-brother/sqlite-gui (main) score 33

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:04:07.643676+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T05:07:58.106785+00:00, confidence not recorded.
  - readme: https://github.com/little-brother/sqlite-gui (fetched 2026-08-28T04:04:07.643676+00:00, sha d8d7d41444cf)
- Data as of 2026-08-30T08:39:29.467469+00:00.