Rocky

A compiled SQL transformation engine built in Rust. Type-safe compilation, column-level lineage, AI-powered intent, and a language server — for data pipelines that don't break.

Get Started in 60 Seconds View on GitHub

Type-Safe Compiler

Column-level type inference, data contracts, and diagnostics with suggestions — errors caught before execution, not after.

Rocky DSL

Pipeline-oriented syntax with NULL-safe operators, window functions, and pattern matching. Or use standard SQL — your choice.

AI Intent Layer

Store intent as metadata. AI explains models, syncs them when upstream schemas change, and generates test assertions.

VS Code Extension

Full language server: completion, hover, go-to-definition, find references, rename, code actions, inlay hints, and lineage visualization.

Quality Checks

Row count, column match, freshness, null rate, anomaly detection, and custom SQL checks — inline with pipeline execution.

Dagster Integration

First-class integration via dagster-rocky. Auto-discover assets, emit materializations, and translate check results.

Get Started in 60 Seconds

curl -fsSL https://raw.githubusercontent.com/rocky-data/rocky/main/engine/install.sh | bash
rocky playground my-first-project
cd my-first-project
rocky compile    # Type-check all models
rocky test       # Run assertions locally
rocky run        # Execute the pipeline

No credentials needed — the playground uses DuckDB locally.

Coming from dbt? Step-by-step migration guide: import your dbt project, convert tests to contracts, and adopt incrementally.

Using Dagster? dagster-rocky provides auto-discovery, rich metadata, and check result integration.