# nalgeon/sqlean

The ultimate set of SQLite extensions

Repository: https://github.com/nalgeon/sqlean
Canonical: https://ross.abutalabs.com/products/sqlean
Language: C
License: MIT
License Family: permissive
Topics: sqlite, sqlite-extension
Last push: 2026-08-22T04:57:52+00:00

## Health v2 (maintenance only)
Score: 95/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 99, release rhythm 86, longevity 100
- inputs: {"age_days": 2012, "days_push": 11, "days_rel": 19, "gap_med": 64, "n_releases_24m": 8}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 4366, forks 156 (observed 2026-08-28T04:08:46.674341+00:00)

## What it is
A curated collection of SQLite loadable extensions packaged into domain modules like crypto, math, regexp, stats, text, time, uuid, and fileio. It provides precompiled binaries for Linux, Windows, and macOS, acting as an extended standard library for SQLite.

## Use cases
- add regular expression support to sqlite queries
- compute median and statistics in sqlite
- generate uuids in sqlite
- read and write files from sqlite
- fuzzy string matching in sqlite
- load csv files as virtual tables in sqlite
- hash and encode data in sqlite

## When to choose
- you need functions sqlite lacks, like regexp, statistics, or uuid generation
- you want tested, documented, prebuilt sqlite extensions for multiple platforms
- you want a single bundled extension file instead of hunting scattered extensions

## When to avoid
- you need extensions with external dependencies beyond the C standard library
- you use a database other than sqlite
- you need a 32-bit build

## Facets
- artifact type: library
- maturity: active
- function: database, parser, cryptography, math, date-time, csv, json, search-engine
- domain: databases, developer-tools, files
- platform: windows, cross-platform, cli
- tags: sqlite, sqlite-extensions, c, standard-library, loadable-extensions, uuid, algorithms, linux, macos

## Member repositories
- nalgeon/sqlean (main) score 95

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:08:46.674341+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-29T18:21:24.853328+00:00, confidence not recorded.
  - readme: https://github.com/nalgeon/sqlean (fetched 2026-08-28T04:08:46.674341+00:00, sha 6be946f7acb6)
- Data as of 2026-08-30T08:39:29.467469+00:00.