sqlc

Type-safe SQL for Go.

Visit website ↗

Console’s review

· Reviewed by David Mytton

What we like

Generates idiomatic Go code based on your database schema and desired queries. Translates SQL to type-safe Go code. Interface to the generated code feels like proper Go. Can run static analysis on schema changes to detect breaking changes across the codebase. Useful tools to help ensure codegen is up to date and highlights SQL anti-patterns. Open source.

Tradeoffs

No support for cloud databases like BigQuery or ClickHouse (there is currently a waitlist). Primarily supports Go, but has some experimental plugins for Python and TypeScript.

Console is a free weekly newsletter with short reviews of developer tools, covering strengths and tradeoffs. This review reflects our assessment at publication. Read our selection criteria and learn about Console.

Discover your next favorite tool

Independent devtool reviews and the latest betas, in your inbox every Thursday. Free.