Goldziher

Goldziher / scythe

Public

SQL-to-code generator for 10 languages and 3 databases

goldziher.github.ioscythe codegen database sql sqlc type-safe
23
0
100% credibility
Found Apr 07, 2026 at 23 stars -- GitGems finds repos before they trend. Get early access to the next one.
Sign Up Free
AI Analysis
Rust
AI Summary

Scythe turns annotated SQL queries into type-safe code for 10 languages across PostgreSQL, MySQL, and SQLite, with built-in linting and formatting.

How It Works

1
📖 Discover Scythe

You hear about Scythe, a friendly helper that turns your plain SQL questions into safe, ready-to-use code for any programming language.

2
🛠️ Set it up

Install Scythe on your computer in moments, like adding a new app.

3
✏️ Note your questions

Take your SQL database questions and add simple notes, like naming them and saying if they return one item or many.

4
📝 Share your setup

Tell Scythe where your database blueprint and questions live, plus your favorite language.

5
🚀 Make the magic

Hit go, and Scythe creates perfect, error-proof code that matches your SQL exactly.

6
💻 Use your new code

Drop the code into your project and connect to your database safely.

✅ Perfect results

Your app now chats with the database reliably, catching mistakes early for smooth, bug-free work.

Sign up to see the full architecture

5 more

Sign Up Free

Star Growth

See how this repo grew from 23 to 23 stars Sign Up Free
Repurpose This Repo

Repurpose is a Pro feature

Generate ready-to-use prompts for X threads, LinkedIn posts, blog posts, YouTube scripts, and more -- with full repo context baked in.

Unlock Repurpose
AI-Generated Review

What is scythe?

Scythe is a Rust CLI tool that compiles annotated SQL queries into type-safe code for 10 languages—Rust, Python, TypeScript, Go, Java, Kotlin, C#, Elixir, Ruby, PHP—targeting 25 drivers across PostgreSQL, MySQL, and SQLite. Write plain SQL with @name and @returns tags, run `scythe generate`, and get structs, functions, and precise types handling nulls from JOINs or COALESCE. It bundles 93 lint rules and SQL formatting via sqruff, plus a sqlc migration command for easy onboarding.

Why is it gaining traction?

Unlike sqlc's Go/Rust focus or jOOQ's Java DSL, Scythe works across stacks without ORMs, inferring complex types like enums, arrays, and ranges natively. Devs love the zero-boilerplate workflow: no more manual row mapping or SQL bugs slipping through. Check goldziher.github.io/scythe (github scythe io) for sharp vs-ORM comparisons and quickstarts—it's a sql code generator that feels like sqlc but polyglot.

Who should use this?

Backend teams mixing Rust microservices with Python APIs or Go workers, needing consistent SQL handling without language silos. Ideal for SQL-first devs ditching ORMs like Diesel or SQLAlchemy for raw performance, or polyglots evaluating sql code generator ai free alternatives before committing to paid tools.

Verdict

Worth a spin for multi-lang SQL codegen—docs are polished, CI passes, and it lints like a pro—but 23 stars and 1.0% credibility score signal early days; test on real schemas before prod. Pair with `scythe lint` in CI for quick wins.

Sign up to read the full AI review Sign Up Free

Similar repos coming soon.