hanzo-orm

Hanzo ORM is a Go generics-based ORM with automatic serialization, KV caching, and zero code generation.

Hanzo ORM - Go Generics ORM with Auto-Serialization

Category: Hanzo Ecosystem Related Skills: hanzo/hanzo-database.md, hanzo/go-sdk.md

Overview

Hanzo ORM is a Go generics-based ORM with automatic serialization, KV caching, and zero code generation. 130 tests passing, supports SQLite (embedded) and ZAP (PostgreSQL/MongoDB/Redis/ClickHouse via sidecar).

Why Hanzo ORM?

• Zero codegen: Generics-based, no code generation step
• Auto-serialization: Struct ↔ DB mapping automatic
• KV cache layer: Built-in caching for hot paths
• Multi-backend: SQLite embedded + ZAP for production DBs
• Type-safe: Full Go generics type safety

When to use

• Go services needing database access
• Projects wanting ORM without code generation
• Embedded SQLite for simple apps
• Multi-backend with caching

Quick reference

| Item | Value | |------|-------| | Module | github.com/hanzoai/orm | | Version | v0.3.0 | | Go | 1.26.0 | | Tests | 130 passing (orm: 97, db: 21, val: 11) | | Docs | orm.hanzo.ai → hanzo.ai/docs/services/orm | | Repo | github.com/hanzoai/orm |

One-file quickstart

package main

import (
 "github.com/hanzoai/orm"
 ormdb "github.com/hanzoai/orm/db"
)

type User struct {
 ID int64 `orm:"pk,autoincr"`
 Name string `orm:"notnull"`
 Email string `orm:"unique,notnull"`
 Age int `orm:"default:0"`
}

func main() {
 db, _ := orm.OpenSQLite(&ormdb.SQLiteDBConfig{
 Path: "app.db",
 Config: ormdb.SQLiteConfig{BusyTimeout: 5000, JournalMode: "WAL"},
 })
 repo := orm.NewRepository[User](db)

 // Create
 user := User{Name: "Alice", Email: "[email protected]", Age: 30}
 repo.Create(&user)

 // Query
 found, _ := repo.FindByID(user.ID)
 all, _ := repo.FindAll(orm.Where("age > ?", 25))

 // Update
 found.Age = 31
 repo.Update(found)

 // Delete
 repo.Delete(found.ID)
}

ZAP Backend (PostgreSQL)

import (
 "github.com/hanzoai/orm"
 ormdb "github.com/hanzoai/orm/db"
)

db, _ := orm.OpenZap(&ormdb.ZapConfig{
 Endpoint: "localhost:5432",
 Database: "mydb",
})
repo := orm.NewRepository[User](db)
// Same API, production database

SQL Backend (PostgreSQL direct)

db, _ := orm.OpenSQL(&ormdb.SQLConfig{
 DSN: "postgresql://user:pass@localhost:5432/mydb",
})

Backends

All backends live in a single db package (github.com/hanzoai/orm/db):

| Backend | Use Case | Config Type | |---------|----------|-------------| | SQLite | Embedded, testing, small apps | ormdb.SQLiteDBConfig | | SQL (PostgreSQL) | Production RDBMS (direct) | ormdb.SQLConfig | | ZAP-PostgreSQL | Production RDBMS (via sidecar) | ormdb.ZapConfig | | ZAP-MongoDB | Document store (via sidecar) | ormdb.ZapConfig | | ZAP-Redis | KV cache layer (via sidecar) | ormdb.ZapConfig | | ZAP-ClickHouse | Analytics/OLAP (via sidecar) | ormdb.ZapConfig |

Related Skills

• hanzo/hanzo-database.md - Database configuration
• hanzo/go-sdk.md - Go SDK patterns

---

Last Updated: 2026-03-13 Category: Hanzo Ecosystem Related: orm, database, go, generics Prerequisites: Go generics, SQL basics