Documentation
Strata SQL is a tool for visualising and developing physical data models, linked to logical and conceptual models and to a semantic layer of metrics, with governance at every level and a full version history. A model is a plain file, so it lives in Git like code. Use it as a VS Code extension, from the command line (the @stratasql/strata-sql npm package) or in a browser (the live view, also served by a Docker image).
New here? Start with the Quick start.
Guides#
| Guide | What it covers |
|---|---|
| Quick start | Install, create a project, add tables, govern, save, in about ten minutes |
| Projects and files | The folder layout, every file, the terminal commands, databases, domains |
| Import from dbt | Start from manifest.json; re-sync without losing your work |
| Import from SQL scripts | Cold start from DDL and queries in eleven dialects |
| Levels and alignment | Conceptual, logical, physical and semantic, and how they link |
| Governance | Tags, policies, owners, classification and domains |
| Semantic layer | Metrics, calculations, grain |
| Impact and load order | What breaks if I change this, what loads first, SLAs |
| Versions and Git | Version streams, the tamper-evident log, what to commit, merging |
| Share and AI | Live view, HTML export, ETL code, embeddings and assistants |
| Shortcuts | Keyboard, mouse and Command Palette |
Conventions#
- Strata SQL is the product name on this site. The commands in VS Code start with
Strata SQL:, and the terminal command isstrata-sql(ornode cli.jsfrom a source checkout). - Shortcuts use Cmd on Mac and Ctrl on Windows and Linux.
- These pages are written from the product's own help. The in-editor help (Cmd/Ctrl + F1) is the complete reference.
- Nothing on this site runs your SQL or connects to your warehouse, and neither does Strata SQL.