Hanzo ORM - Go Generics ORM with Auto-Serialization

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

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: "alice@hanzo.ai", 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

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`

hanzo/hanzo-database.md - Database configuration

hanzo/go-sdk.md - Go SDK patterns

Hanzo ORM - Go Generics ORM with Auto-Serialization

On this page