Skip to content
프로젝트

rayakame/sqlc-gen-better-python

GitHub에서 보기

rayakame/sqlc-gen-better-python has 44 GitHub stars and 5 forks. GitHot measured 0 stars in 24 hours and +1 in 7 days. Last checked 2026-11-19 04:00 UTC. Last push 2026-11-18.

이 수치를 측정하는 방법

What you can do

  • Four model types - dataclass, attrs, msgspec, or pydantic (docs).
  • Nine drivers - asyncpg, psycopg_async, and psycopg_sync for PostgreSQL, aiosqlite and sqlite3 for SQLite, asyncmy and pymysql for MySQL, plus experimental turso_async and turso_sync for Turso (docs).
  • Typed query functions - one module per query file, one function per query (docs).
  • PostgreSQL enum types and MySQL enum columns as enum.StrEnum classes (docs).

측정된 스타 증가

in 24h
0
in 7 days
+1
in 15 days
기록 수집 중
in 1 month
기록 수집 중

서로 겹치는 기간의 순증가량이며 일별 합계가 아닙니다. 측정값이 없으면 비워 둡니다. 스타는 관심도를 나타내며 품질을 보장하지 않습니다.

소개

A sqlc plugin that generates modern, type-safe Python from SQL

데이터

README.md

Original

sqlc-gen-better-python

Codecov Go coverage Python coverage Python Version from PEP 621 TOML Ruff CI

sqlc-gen-better-python is a sqlc plugin that turns your SQL schema and queries into modern, fully typed Python database code: models, typed query functions, and enums. You keep writing SQL; the Python stays in sync with it.

You write:

-- name: GetUser :one
SELECT * FROM users WHERE id = $1;

and get back:

async def get_user(conn: ConnectionLike, *, id_: int) -> models.User | None:
    row = await conn.fetchrow(GET_USER, id_)
    if row is None:
        return None
    return models.User(id_=row[0], name=row[1])

No ORM, no hand-written row unpacking. Generated code targets Python 3.12 or newer and passes pyright (strict) and ruff.

Documentation

https://sqlc-gen-better-python.rayakame.dev/

  • Getting Started - install the plugin and generate your first models.
  • Guide - every feature, each with real generated output.
  • Reference - all options, type mappings, and per-driver feature support.

Questions or feedback? Join the Discord.

Features

  • Four model types - dataclass, attrs, msgspec, or pydantic (docs).
  • Nine drivers - asyncpg, psycopg_async, and psycopg_sync for PostgreSQL, aiosqlite and sqlite3 for SQLite, asyncmy and pymysql for MySQL, plus experimental turso_async and turso_sync for Turso (docs).
  • Typed query functions - one module per query file, one function per query (docs).
  • PostgreSQL enum types and MySQL enum columns as enum.StrEnum classes (docs).
  • Type overrides and converters - swap a column's Python type, or plug in your own encode/decode functions (overrides, converters).
  • Typed JSON columns via msgspec structs (docs).
  • Optional docstrings in google, numpy, or pep257 convention (docs).

Every sqlc macro is supported. Which query commands are available depends on the driver - see the feature support matrix.

Example config

# filename: sqlc.yaml
version: "2"
plugins:
  - name: python
    wasm:
      url: https://github.com/rayakame/sqlc-gen-better-python/releases/download/v0.9.0/sqlc-gen-better-python.wasm
      sha256: d1787aa32e61f2e73c81a4f93b3e5a9beeec918952cff3183fb96313057f58a8
sql:
  - engine: "postgresql"
    queries: "query.sql"
    schema: "schema.sql"
    codegen:
      - out: "app/db"
        plugin: python
        options:
          package: "db"
          emit_init_file: true
          sql_driver: "asyncpg"
          model_type: "msgspec"

[!TIP] No sqlc yet? Besides the official installation methods, uv add --dev sqlc-bin (or pip install sqlc-bin) installs sqlc-bin, the unmodified official binaries as a pinnable Python package - no Go toolchain required.

More options at the sqlc config reference, and the full plugin option list in the configuration reference.

Used by

nMarkov logo

nMarkov - a Discord chatbot that learns from your server's messages and generates its own.

Using sqlc-gen-better-python in your project? Open an issue to get listed here.

Development

Contributions are very welcome, for more information and help please read the contribution guidelines.

Changelog

Can be found here

Credits

Special thanks to tandemdude for answering my questions on discord.