Rosetta DataBase Transformation Studio is an open-source desktop application that simplifies your data transformation journey with dbt Core™ and brings the power of AI into your analytics engineering workflow.
Whether you're just getting started with dbt Core™ or looking to streamline your transformation logic with AI assistance, DBT Studio offers an intuitive interface to help you build, explore, and maintain your data models efficiently.
- Multi-Warehouse Support: Connect seamlessly to traditional data warehouses (including PostgreSQL, SQLite, and more).
- Data Lake Native (DuckLake): Direct connection to your data lakes with dedicated schema views and native Parquet export capabilities.
- Connection Management: Easily clone, switch, and manage multiple connections directly from the UI.
- Staging Layer Generator: Automatically create staging models based on RAW tables.
- Enhanced Layer Generator: Build intermediate models to enrich and prepare your data.
- Business Models with AI: Describe the business logic, and let the AI assist you in generating robust business models.
- AI-Generated Analytical Queries: Generate analysis-ready queries and dashboard datasets using natural language.
- SQL Editor: Explore your data using an in-app SQL editor with auto-run, formatting, and result preview.
- AI SQL Assistant: Chat with an AI agent directly inside the SQL Editor — ask questions in natural language, generate queries, inspect results, and iterate without leaving the editor.
- SQL Notebooks: Interactive notebooks featuring SQL cells, state persistence, import/export capabilities, and data pagination.
- Smart Editor: Full dbt™ autocomplete, Jinja-SQL syntax highlighting, and intelligent language features.
- File Explorer: Intuitive file tree with drag-and-drop support and external file import.
- Pipeline Visualiser: Visualize your
pipeline.ymlconfigurations with a live, interactive split-pane viewer.
- Use the built-in Git explorer with Select All feature to easily commit and manage project changes.
- Compile, test, run, and document dbt™ projects directly from the UI—no terminal needed.
Leverage AI to:
- Automatically draft dbt™ models from descriptions or table schemas.
- Generate joins, transformations, and aggregations with minimal input.
- Translate business questions into SQL queries for analysis.
- Chat inside the SQL Editor: Ask the AI to write, explain, or debug queries against your live connection — results appear directly in the editor.
DBT Studio includes an integrated Python environment to:
- Install and manage dbt™ without external setup.
- Seamlessly configure and run dbt™ from within the application.
DBT Studio embeds the open-source Rosetta CLI tool to support metadata-driven dbt™ development:
- Model generation aligned with your naming conventions and standards.
- Reusable templates and YAML documentation support.
Get a quick overview of Rosetta DBT Studio in action:
💡 More tutorials and walkthroughs are available on our YouTube Channel.
Download the latest release for your OS from the Releases Page and follow the instructions to get started.
No prior Python or dbt™ installation required.
cd project-dir
npm installStart the app in the dev environment:
npm startTo package apps for the local platform:
npm run packageThe build files after packaging can be found at: /release/build
AGPL-3.0 - See LICENSE for details.