Code Generation Templates

sqldoc generates typed code from your SQL schema using templates. Run sqldoc codegen to generate code for any of the supported languages and frameworks.

sqldoc codegen

Templates read your SQL schema (via Atlas) and produce typed output files -- interfaces, models, query helpers, and more.

TypeScript

typescript

Drizzle Schema

PostgreSQL schema name override

typescript

Knex Table Types

How to represent date/time types

typescript

Kysely Database

How to represent date/time types

typescript

TypeScript Interfaces

How to represent date/time types

typescript

z.string()

How to represent date/time types

Go

go

Go Structs

Generate plain Go structs with json struct tags from SQL schema

go

GORM Models

Generate Go structs with GORM struct tags from SQL schema

go

sqlc Models

Generate Go structs matching sqlc naming conventions with sql.Null types

Python

python

Pydantic Models

Generate Pydantic BaseModel classes with Field validators from SQL schema

python

Python Dataclasses

Generate Python @dataclass classes from SQL schema

python

String

Generate SQLAlchemy ORM model classes with Column definitions from SQL schema

Java

java

Java Records

Generate Java record classes from SQL schema

java

JPA Entities

Generate JPA @Entity classes with annotations from SQL schema

Kotlin

kotlin

Kotlin Data Classes

Generate Kotlin data classes from SQL schema

Rust

rust

Rust Structs

Generate Rust structs with serde derives from SQL schema

rust

Text

Generate Diesel table! macros and Queryable structs from SQL schema

C#

csharp

C# Records

Generate C# record types from SQL schema

csharp

EF Core Entities

Generate Entity Framework Core entity classes with data annotations from SQL schema

JSON / Schema

json

JSON Schema

Output one file per table or a single bundled file (default: bundled)

XML

xml

xs:string

Generate XML Schema Definition types from SQL schema

Protocol Buffers

protobuf

string

Generate Protocol Buffers message definitions from SQL schema

SQL

sql

String

Database provider (default: postgresql)

COBOL

COcobol

COBOL Copybook

Generate COBOL copybook record definitions from SQL schema