A SQL transformation framework that automatically detects dependencies from your queries. Write pure SQL, get dependency graphs, column-level lineage, and incremental builds - no ref() functions or boilerplate required.

• Automatic Dependency Detection - Write standard SQL. LeapSQL parses your queries to build the DAG automatically from FROM, JOIN, subqueries, and CTEs.
• Column-Level Lineage - Track exactly how each field flows through your transformations, not just table-level dependencies.
• Starlark Templating - Use a Python-like language for safe, deterministic SQL generation. No more Jinja recursion errors.
• Single Binary - Distributed as a standalone Go binary. No Python environments or dependency management.
• Database-Backed State - Run history and metadata stored in SQLite, not scattered JSON artifacts.

/*---
name: customers
materialized: table
---*/

SELECT
    c.id,
    c.name,
    c.email,
    COUNT(o.id) as order_count,
    SUM(o.amount) as total_spent
FROM raw_customers c
LEFT JOIN raw_orders o ON c.id = o.customer_id
GROUP BY c.id, c.name, c.email

LeapSQL automatically detects that this model depends on raw_customers and raw_orders, tracks that order_count derives from orders.id, and ensures models build in the correct order.

Requires Go 1.21+:

go install github.com/leapstack-labs/leapsql/cmd/leapsql@latest

Download from the Releases Page, or:

# macOS / Linux
curl -L https://github.com/leapstack-labs/leapsql/releases/latest/download/leapsql-$(uname -s)-$(uname -m) -o leapsql
chmod +x leapsql
sudo mv leapsql /usr/local/bin/

# Create a new project
mkdir my-project && cd my-project
leapsql init --example

# Load seed data
leapsql seed

# View the dependency graph
leapsql dag

# Run all models
leapsql run

Run leapsql <command> --help for detailed usage.

Configure your adapter in leapsql.yaml:

adapter:
  type: duckdb
  path: ./warehouse.db

LeapSQL includes a Language Server Protocol (LSP) implementation providing:

• Autocomplete for models and macros
• Hover documentation
• Go-to-definition

A VS Code extension is available in the vscode-leapsql/ directory.

Full documentation: leapstack-labs.github.io/leapsql

• Installation Guide
• Core Concepts
• CLI Reference
• Templating

Contributions are welcome. To get started:

# Run tests
task test

# Run linter
task lint

# Run both
task check

See the Taskfile.yml for all available commands.

MIT License. See LICENSE for details.