# yy0931/sqlite3-editor

Repository: https://github.com/yy0931/sqlite3-editor
Canonical: https://ross.abutalabs.com/products/sqlite3-editor
Homepage: https://marketplace.visualstudio.com/items?itemName=yy0931.vscode-sqlite3-editor
Language: TypeScript
License: GPL-3.0
License Family: copyleft
Topics: database, vscode-extension, editor, sqlite
Last push: 2026-06-04T09:49:11+00:00

## Health v2 (maintenance only)
Score: 70/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 85, release rhythm 35, longevity 96
- inputs: {"age_days": 1352, "days_push": 90, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_releases
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 2731, forks 24 (observed 2026-08-28T04:07:16.109294+00:00)

## What it is
A VSCode extension that provides a custom editor for SQLite3 database files, allowing spreadsheet-like viewing and editing of data and schemas without writing SQL. It also includes a query editor with auto-completion and syntax highlighting.

## Use cases
- edit sqlite database files in vscode
- view sqlite tables like a spreadsheet
- edit table schema without writing SQL
- run SQL queries with autocomplete in vscode
- browse large sqlite databases quickly
- preview image blobs in sqlite tables

## When to choose
- you work with SQLite files inside VSCode and want one-click opening
- you prefer spreadsheet-style editing over writing SQL
- you need fast browsing of large SQLite databases
- you want schema editing and query execution in one tool

## When to avoid
- you need a standalone database client or support for other database engines
- you need multi-user or remote database administration features
- you don't use VSCode

## Facets
- artifact type: plugin
- maturity: active
- function: editor, database, ui-components, developer-tools
- domain: databases, developer-tools, text-editors
- platform: editor-plugin, cross-platform, windows
- tags: sqlite, vscode-extension, database-gui, spreadsheet-editing, sql-editor, macos, linux

## Member repositories
- yy0931/sqlite3-editor (main) score 70

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:07:16.109294+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-30T02:14:40.435529+00:00, confidence not recorded.
  - readme: https://github.com/yy0931/sqlite3-editor (fetched 2026-08-28T04:07:16.109294+00:00, sha 952c2f7e1227)
  - homepage: https://marketplace.visualstudio.com/items?itemName=yy0931.vscode-sqlite3-editor (fetched 2026-08-29T09:58:04.423947+00:00, sha 5f431350231b)
  - site_page: https://code.visualstudio.com/docs/getstarted/userinterface (fetched 2026-08-29T09:58:04.427233+00:00, sha b6b52406dce8)
  - site_page: https://code.visualstudio.com/docs/editor/codebasics (fetched 2026-08-29T09:58:04.429946+00:00, sha c367731ae7d3)
  - site_page: https://code.visualstudio.com/docs/sourcecontrol/overview (fetched 2026-08-29T09:58:04.434073+00:00, sha e856ad68422d)
- Data as of 2026-08-30T08:39:29.467469+00:00.