# go-jet/jet

Type safe SQL builder with code generation and automatic query result data mapping

Repository: https://github.com/go-jet/jet
Canonical: https://ross.abutalabs.com/products/jet
Language: Go
License: Apache-2.0
License Family: permissive
Topics: golang, sql, sqlbuilder, postgresql, code-generator, database, sql-query, sql-query-builder, postgres, typesafe, codegenerator, typesafety, mysql, mariadb, sql-queries, sql-builder, code-completion, datamapper, sqlite, cockroachdb
Last push: 2026-08-22T09:44:15+00:00

## Health v2 (maintenance only)
Score: 86/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 99, release rhythm 60, longevity 100
- inputs: {"age_days": 2741, "days_push": 11, "days_rel": 104, "gap_med": 125.0, "n_releases_24m": 5}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 3781, forks 192 (observed 2026-08-28T04:08:18.448229+00:00)

## What it is
Jet is a Go library providing a type-safe SQL query builder with code generation from database schemas and automatic mapping of query results into Go structs. It supports PostgreSQL, MySQL, SQLite, CockroachDB, and MariaDB, and is explicitly not an ORM.

## Use cases
- write type-safe SQL queries in Go with compile-time checking
- generate Go code from database schema for query building
- map SQL query results into nested Go structs automatically
- build complex SELECT, INSERT, UPDATE, DELETE queries without raw SQL strings
- get code completion for SQL queries in Go IDEs
- query PostgreSQL, MySQL, or SQLite from a Go application

## When to choose
- you want type-safe SQL in Go without ORM magic
- you prefer writing SQL-like queries with IDE completion and compile-time safety
- you need automatic mapping of query results into complex object compositions
- you use PostgreSQL, MySQL, SQLite, CockroachDB, or MariaDB

## When to avoid
- you want a full ORM with associations, migrations, and lifecycle hooks
- you need database engines beyond the SQL dialects Jet supports
- you prefer hand-written raw SQL without code generation steps

## Facets
- artifact type: library
- maturity: active
- function: orm, database, database-driver, serialization
- domain: databases, backend, developer-tools, web-development
- platform: go, windows, cross-platform
- tags: sql-builder, code-generation, type-safe, query-builder, data-mapping, postgresql, mysql, sqlite, cockroachdb, mariadb, linux, macos

## Member repositories
- go-jet/jet (main) score 86

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:08:18.448229+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:27:45.124482+00:00, confidence not recorded.
  - readme: https://github.com/go-jet/jet (fetched 2026-08-28T04:08:18.448229+00:00, sha 8bcfd00a7b33)
- Data as of 2026-08-30T08:39:29.467469+00:00.