stephenafamo/bob
SQL query builder and ORM/Factory generator for Go with support for PostgreSQL, MySQL and SQLite observed · 2026-08-28
Health v2 · maintenance only
98/100
- Activity 98
- Release rhythm 97
- Longevity 100
How is this computed?
round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-03. Adoption (stars, forks) is never an input.
- gap_med: 6
- age_days: 1596
- days_rel: 23
- days_push: 16
- n_releases_24m: 30
Adoption not part of the score
1777 stars · 113 forks observed · 2026-08-28
What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded
Bob is a Go SQL access toolkit providing a fluent, dialect-aware query builder for PostgreSQL, MySQL, and SQLite, plus a database-first ORM with code generation of typed models, factories, and sqlc-style query code. It emphasizes progressive enhancement from raw SQL strings to fully typed queries.
Use cases
- build type-safe SQL queries in Go without an ORM
- generate Go models and factories from an existing database schema
- replace GORM or SQLBoiler with a database-first ORM
- generate typed code for hand-written SQL queries like sqlc
- write dialect-specific queries for Postgres, MySQL, or SQLite
- eager-load related models based on foreign keys
- generate test fixtures for database-backed Go code
When to choose
- you prefer a database-first workflow with schema-driven code generation
- you want progressive adoption from raw SQL to typed models
- you need strong typing and full autocomplete for queries
- you want sqlc-like query codegen plus ORM features in one toolkit
When to avoid
- you want a migration tool to create your schema (Bob expects the schema to already exist)
- you prefer a code-first ORM that defines models in Go
- your project does not use PostgreSQL, MySQL, or SQLite
Facets
library · maturity active
orm database database-driver databases backend developer-tools go windows cross-platform query-builder sql postgresql mysql sqlite code-generation database-first sqlc-alternative factory-pattern linux macos
10 sources
- readme: https://github.com/stephenafamo/bob · fetched 2026-08-28 · 13b795ef0176
- homepage: https://bob.stephenafamo.com · fetched 2026-08-29 · a25e114229bc
- site_page: https://bob.stephenafamo.com/docs/query-builder/intro · fetched 2026-08-29 · 7036fe702b4d
- site_page: https://bob.stephenafamo.com/docs/query-builder/psql/how-to-use · fetched 2026-08-29 · e0b0cbbf952b
- site_page: https://bob.stephenafamo.com/docs/query-builder/mysql/how-to-use · fetched 2026-08-29 · f8d87532b974
- site_page: https://bob.stephenafamo.com/docs/query-builder/sqlite/how-to-use · fetched 2026-08-29 · 1377aa0f47f6
- site_page: https://bob.stephenafamo.com/docs/code-generation/intro · fetched 2026-08-29 · 7dcf50c1976d
- site_page: https://bob.stephenafamo.com/docs/code-generation/configuration · fetched 2026-08-29 · 4c4dc12d2458
- site_page: https://bob.stephenafamo.com/docs/code-generation/psql · fetched 2026-08-29 · 50e2eac59791
- site_page: https://bob.stephenafamo.com/docs/code-generation/mysql · fetched 2026-08-29 · b4a13d9dc678
Member repositories
| Repository | Role | Health v2 |
|---|---|---|
| stephenafamo/bob | main | 98 |
For agents
markdown · JSON · MCP: product_card(name="stephenafamo/bob")
Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem