awesome-repositories.com
Blog
MCP
awesome-repositories.com

Discover the best open-source repositories with AI-powered search.

ExploreCurated searchesOpen-source alternativesSelf-hosted softwareBlogSitemap
ProjectMCP serverAboutHow we rankPress
LegalPrivacyTerms
© 2026 Bringes Technology SRL·VAT RO45896025·hello@awesome-repositories.com
kyleconroy avatar

kyleconroy/sqlc

0
View on GitHub↗
17,886 stars·1,057 forks·Go·MIT·21 viewssqlc.dev↗

Sqlc

sqlc is a SQL compiler and code generator that creates type-safe database client code from raw SQL queries. It transforms SQL statements into typed definitions and functions, eliminating the need for manual row mapping between database results and application structures.

The tool ensures compile-time safety by validating SQL queries against the database schema before the application is run. This workflow integrates the database schema directly into the application code, deriving types from the underlying SQL definitions to prevent runtime errors.

The system utilizes AST-based query analysis and dialect-specific parsers to handle various SQL flavors. It employs schema-driven type inference and template-based code generation to produce the final source code.

Features

  • Type-Safe Client Generators - Generates type-safe database client code from SQL queries to eliminate manual row mapping.
  • Type-Safe - Compiles raw SQL queries into strongly-typed application code to eliminate manual data mapping.
  • SQL-to-Language Generators - Transforms raw SQL statements into typed definitions and functions for various programming languages.
  • Type-Safe Database Clients - Ensures compile-time safety by generating strongly-typed interfaces for all database operations.
  • SQL Schema Integrations - Connects application code to database schemas by deriving types directly from SQL definitions.
  • Schema-Driven Type Inference - Automatically derives language-specific type definitions by analyzing the database schema and query projections.
  • SQL Query Validators - Verifies that SQL queries are syntactically and structurally correct against the database schema during compilation.
  • SQL Abstract Syntax Tree Parsing - Parses raw SQL queries into abstract syntax trees for structural analysis and type inference.
  • SQL Dialect Adapters - Provides distinct parsing logic to handle unique syntax variations across different SQL database dialects.
  • SQL-to-Code Workflows - Automates the process of turning raw SQL queries into corresponding typed functions and structures.
  • Source Code Templates - Injects inferred types and query parameters into templates to produce final type-safe source code.
  • SQL Query Builders - Tool to generate type-safe code from SQL.
  • Code Generation Tools - Generates type-safe Go code from SQL.

Star history

Star history chart for kyleconroy/sqlcStar history chart for kyleconroy/sqlc

How this analysis was created: This summary and feature list are AI-generated from collected project material and can contain mistakes. Stars, license and language are imported from GitHub. Inclusion does not mean that we have tested or audited this project. Check the source documentation for any feature you depend on. Learn more on our About page.

AI search

Explore more awesome repositories

Describe what you need in plain English — the AI ranks thousands of curated open-source projects by relevance.

Start searching with AI

Projects sharing features with Sqlc

These projects share indexed features with Sqlc. Shared tags can include platform or build tooling; verify the primary use case before treating a result as a replacement.
  • jooq/jooqjOOQ avatar

    jOOQ/jOOQ

    6,666View on GitHub↗

    jOOQ is a type-safe SQL query builder for Java that generates code from live database schemas, enabling compile-time validation of SQL syntax and data types. Its core identity is built around a fluent DSL that mirrors SQL structure, a code generator that maps tables, views, and routines to Java objects, and a multi-dialect engine that translates the same DSL into vendor-specific SQL for over 30 databases. The project also includes a SQL parser and transformer for refactoring or dialect conversion, reactive stream integration for non-blocking query execution, and a JDBC proxy diagnostics tool f

    Javacode-generatordatabasedb2
    View on GitHub↗6,666
  • digitallyinduced/ihpdigitallyinduced avatar

    digitallyinduced/ihp

    5,294View on GitHub↗

    ihp is a type-safe web framework and full-stack application orchestrator designed for PostgreSQL. It functions as a server-side rendering framework and a type-safe ORM that automatically generates record types from SQL schemas to ensure compile-time query validation. The platform distinguishes itself by verifying routing, database queries, and templates at compile time to prevent runtime crashes. It implements real-time web interfaces using WebSockets for instant data synchronization and employs server-driven hypermedia for partial DOM patching. The framework covers a broad range of integrat

    Haskellframeworkhacktoberfesthaskell
    View on GitHub↗5,294
  • simolus3/driftsimolus3 avatar

    simolus3/drift

    3,231View on GitHub↗

    Drift is a type-safe SQL persistence library and relational mapper that provides a structured way to map database tables to classes and execute SQL queries with build-time validation. It functions as a type-safe query builder and a wrapper for SQLite and PostgreSQL, eliminating manual result set parsing by binding query outputs to native objects. The project distinguishes itself through a build-time code generation system that produces type-safe APIs and validates raw SQL statements against database versions before execution. It features reactive query streaming, which transforms SQL queries

    Dartdartdart-build-systemflutter
    View on GitHub↗3,231
  • sqlc-dev/sqlcsqlc-dev avatar

    sqlc-dev/sqlc

    17,882View on GitHub↗

    sqlc is a code generation tool that compiles raw SQL queries into type-safe application code. By analyzing SQL statements against database schema definitions during the build process, it eliminates the need for manual data mapping and prevents runtime type errors. The project functions as a schema-aware generator that translates database column types into native language primitives. It distinguishes itself through a modular, plugin-based architecture that allows for the extension of the generation pipeline to support diverse programming languages and custom frameworks beyond its default capab

    Gocode-generatorgokotlin
    View on GitHub↗17,882
Compare all 30 related projects→

Frequently asked questions

What does kyleconroy/sqlc do?

sqlc is a SQL compiler and code generator that creates type-safe database client code from raw SQL queries. It transforms SQL statements into typed definitions and functions, eliminating the need for manual row mapping between database results and application structures.

What are the main features of kyleconroy/sqlc?

The main features of kyleconroy/sqlc are: Type-Safe Client Generators, Type-Safe, SQL-to-Language Generators, Type-Safe Database Clients, SQL Schema Integrations, Schema-Driven Type Inference, SQL Query Validators, SQL Abstract Syntax Tree Parsing.

Which projects share features with kyleconroy/sqlc?

Projects with overlapping indexed features include: jooq/jooq — jOOQ is a type-safe SQL query builder for Java that generates code from live database schemas, enabling compile-time… digitallyinduced/ihp — ihp is a type-safe web framework and full-stack application orchestrator designed for PostgreSQL. It functions as a… simolus3/drift — Drift is a type-safe SQL persistence library and relational mapper that provides a structured way to map database… sqlc-dev/sqlc — sqlc is a code generation tool that compiles raw SQL queries into type-safe application code. By analyzing SQL… tobymao/sqlglot — sqlglot is a SQL parser and transpiler that represents queries as abstract syntax trees to enable structural analysis,… masterminds/squirrel — Squirrel is a Go database library and SQL query builder that provides a programmatic interface for constructing and…