# codemix/ts-sql

A SQL database implemented purely in TypeScript type annotations.

Repository: https://github.com/codemix/ts-sql
Canonical: https://ross.abutalabs.com/products/ts-sql
Language: TypeScript
License Family: other
Topics: typescript, sql, parser
Last push: 2021-06-22T17:45:55+00:00

## Health v2 (maintenance only)
Score: 32/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 0, release rhythm 35, longevity 100
- inputs: {"age_days": 2174, "days_push": 1898, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_releases, no_license
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 3301, forks 52 (observed 2026-08-28T04:07:55.692507+00:00)

## What it is
A SQL database implemented entirely in TypeScript type annotations, operating purely at the type level with no runtime code. It supports a subset of SQL including SELECT with conditions and joins, INSERT, UPDATE, and DELETE, all expressed as type annotations.

## Use cases
- run SQL queries against a database defined in TypeScript types
- learn advanced TypeScript type-level programming
- demonstrate what the TypeScript type system is capable of
- parse and execute SQL at compile time
- explore type-level SQL parsing and evaluation

## When to choose
- you want to experiment with or learn extreme type-level TypeScript techniques
- you need a novel demo of the TypeScript type system's capabilities

## When to avoid
- you need a real database for production or application use
- you need runtime SQL execution or persistence
- you need a maintained, licensed dependency

## Facets
- artifact type: library
- maturity: experimental
- function: parser, database, type-system, interpreter
- domain: databases, programming-languages, parsers, developer-tools
- platform: cross-platform
- tags: sql, typescript-types, type-level-programming, novelty, compile-time, nodejs

## Member repositories
- codemix/ts-sql (main) score 32

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:07:55.692507+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:42:56.964460+00:00, confidence not recorded.
  - readme: https://github.com/codemix/ts-sql (fetched 2026-08-28T04:07:55.692507+00:00, sha 5c4e4cb065e4)
- Data as of 2026-08-30T08:39:29.467469+00:00.