#151151st of 275 in Backends, databases and hosting
sqlc
SQL compiler that generates type-safe application code from SQL queries
- Stars
- 18.5k
- License
- MIT
- Last commit
- Oct 2026
- Last release
- Apr 2026
- Language
- Go
17,288 on 28 Apr 202618,469 on 17 Nov 2026
From GitHub's daily star counts.
Checked on GitHub.
Overview
sqlc reads SQL queries and generates type-safe code with interfaces to those queries, so application code calls generated functions instead of hand-written database glue. Go, Kotlin, Python and TypeScript are supported through separate sqlc-gen plugins, and other languages can be added as community plugins. It is written in Go and has a browser playground.
Who it is for: Developers who want typed database access code generated from raw SQL
Strengths
- Queries stay in plain SQL; generated code gives typed interfaces to them
- Language backends are plugins: Go, Kotlin, Python and TypeScript, plus community ones
- Browser playground at play.sqlc.dev for trying it without installing
- MIT licensed, written in Go, with downloads and docs published
Weaknesses
- Not a database or backend; it only generates client code for SQL you write
- Language support lives in separate plugin repositories, each with its own maturity
- README does not describe how schemas or database engines are configured
What it needs
- no GPU
- Docker + Compose
- Compose runs MySQL, PostgreSQL, ClickHouse
What changed
From the release notes. No flag means the note does not say so, not that the upgrade is safe.
Known problems
Open now, reported in the last 90 days
Reported, then fixed by a linked change
- `go run` fails because of replace directive ↗ (opens in a new tab)8 reactions · closed 21 Apr 2026Fixed by Remove go.mod replace directive that breaks 'go install ...@latest' ↗ (opens in a new tab)
- MySQL engine doesn't support: CREATE TRIGGER, CREATE FUNCTION, CREATE PROCEDURE ↗ (opens in a new tab)3 reactions · closed 21 Aug 2026Fixed by Upgrade marino to v0.3.0 ↗ (opens in a new tab)
- Support for MySQL POINT Spatial Data Type in Schema Parsing ↗ (opens in a new tab)2 reactions · closed 21 Aug 2026Fixed by Upgrade marino to v0.3.0 ↗ (opens in a new tab)
- SQL queries are truncated when Chinese comments are present ↗ (opens in a new tab)2 reactions · closed 18 Aug 2026Fixed by endtoend: pin sqlite query text with multi-byte UTF-8 comments ↗ (opens in a new tab)
- MySQL 8.0.19+ ... AS alias ... ON DUPLICATE KEY syntax parsing problem ↗ (opens in a new tab)1 reactions · closed 21 Aug 2026Fixed by Upgrade marino to v0.3.0 ↗ (opens in a new tab)
Titles are the reporters' own words, taken from the project's GitHub issues and ranked by reactions. We have not tried to reproduce any of them.
Also in Backends, databases and hosting
See all 275| Rank | Project | Score |
|---|---|---|
| 1 | bunJavaScript and TypeScript runtime with bundler, test runner and package manager | 94 out of 100 |
| 2 | coolifySelf-hosted Heroku and Vercel alternative that deploys apps and databases over SSH | 93 out of 100 |
| 3 | traefikHTTP reverse proxy and load balancer that auto-discovers routes from orchestrators | 93 out of 100 |
| #4 | appwriteBackend with auth, databases, storage, functions and an MCP server for agents | 93 out of 100 |
| #5 | medusaNode.js commerce platform with modular products, carts, orders and payments | 93 out of 100 |