https://sqlc.dev/

Logo Docs Changelog Playground Newsletter Stars 11973 Discord logo
Sign up

Compile SQL to type-safe code; catch failures before they happen.

Get started
Talk to an engineer

How it works

sqlc generates fully type-safe idiomatic code from SQL.

 1. You write SQL queries
 2. You run sqlc to generate code that presents type-safe interfaces
    to those queries
 3. You write application code calling the methods sqlc generated.

Seriously, it's that easy. You don't have to write any boilerplate
SQL querying code ever again. See the current list of supported
programming languages and databases.

 Verify schema changes 

Schema updates and poorly-written queries often bring down production
databases. That's bad.

When a schema change is proposed, existing queries and code running
in production might fail when the schema change is applied. Enter
sqlc verify, which analyzes existing queries against new schema
changes and errors if there are any issues.

See it in action here or talk to an engineer.

Ready to try it out?
Download the latest release now.

Linux
macOS (AMD64)
macOS (ARM64)
Windows

Used by these lovely companies

Coder
Cerbos
Coder
Riza
ngrok
Scaleway

From the blog

release notes

Managed databases for any PostgreSQL server

August 5, 2024

sqlc is a command line tool that generates type-safe code from SQL.
Today we released sqlc v1.27.0 with support for local managed
databases.

release notes

Mainly a bug fix release

March 28, 2024

sqlc is a command line tool that generates type-safe code from SQL.
Today we released sqlc v1.26.0, mainly a bug fix release.

release notes

Removing our cgo dependency in v1.25.0

January 4, 2024

sqlc is a command line tool that generates type-safe code from SQL.
Today we released sqlc v1.25.0, a smaller release that removes our
reliance on cgo.

(c) Copyright 2024 Riza, Inc.
Use of this site is governed by the Riza, Inc. Terms of Service and
Privacy Policy.