u/Wide_Importance_8559

Rosetta DBT Studio is the local-first, open-source desktop workspace for dbt teams - build models, explore SQL, trace lineage, manage Git, preview cloud data, and work with AI agents from one app.

v1.5.7 is all about giving analytics engineers one place to build, understand, and ship dbt work without bouncing between terminals, browsers, and disconnected tools.

AI Agent for dbt - ask the agent to explain models, generate SQL, update YAML, run dbt commands, inspect project context, and help reason through lineage and grain before you make a change.

Project-aware SQL editor - write queries with Monaco autocomplete, schema browsing, saved queries, result previews, and export workflows across DuckDB and supported warehouses.

End-to-end dbt lineage - trace models, sources, and downstream impact so you can understand what a change touches before it reaches production.

SQL Notebooks with AI - work in a cell-based notebook that combines SQL, markdown, results, and AI-assisted iteration in one analysis flow.

Cloud Explorer with DuckDB-powered preview - browse and preview files from S3, Azure Blob, GCS, and compatible object storage without leaving the Studio.

DuckLake and lakehouse tooling - explore schemas, tables, snapshots, and metadata from one workspace, then query them directly in the SQL editor and notebooks.

Built-in Git workflows - review local changes, manage branches, and keep project version control close to the editor instead of split across tools.

Multi-provider AI - use OpenAI, Anthropic, Gemini, Ollama, LM Studio, and OpenAI-compatible providers with project context.

Plus secure credential storage, multi-database connections, Rosetta CLI integration, cloud profile sync, and a full desktop workflow for local dbt development.

100% open source, local-first, and yours.

GitHub - https://github.com/rosettadb/dbt-studio

Watch the Rosetta DBT Studio AI Agent build the classic Jaffle Shop dbt project from scratch in under two minutes. From importing the repository to generating staging models, mart models, and tests, see how autonomous AI accelerates your data engineering workflow.

🔍 Topics covered in this video:
• One-click import: Cloning the Jaffle Shop repository directly from GitHub
• Connecting to your database (DuckDB, PostgreSQL, Snowflake, and more)
• Prompting the AI Agent to autonomously generate staging and mart models
• Watching the Agent write clean SQL, create YAML configs, and add descriptions/tests
• Real-time validation: The Agent automatically runs dbt compile to ensure your code works
• Exploring the final project structure and ready-to-run DAG

⚙️ Powered by the Vercel AI SDK with support for OpenAI, Anthropic, Gemini, and Ollama (local models).

📥 Download Rosetta DBT Studio (macOS, Windows, Linux):
https://rosettadb.io/download-dbtstudio
⭐ Star us on GitHub:
https://github.com/rosettadb/dbt-studio

📺 More tutorials and walkthroughs:
u/rosettadb
---
#AIAgent #dbt #DataEngineering #AnalyticsEngineering #JaffleShop #OpenSource #RosettaDBT #LLM #DuckDB #DataPlatform #DataStack #Ollama #Anthropic #OpenAI

Hey everyone,

We just shipped a major update to Rosetta DBT Studio — an open-source desktop workspace for dbt teams — and wanted to share what we've been building.

The new AI Agent isn't a chatbot wrapper. It's a tool-loop engine that:

- 📂 Lists your project directories and reads your schema files for real context

- ✍️ Writes dbt model SQL and YAML directly into your project

- ▶️ Runs dbt commands (compile, run, test) and reads the logs

- 📑 Auto-opens every file it writes as an editor tab so you can review instantly

**Security first:** The Agent never runs a terminal command without showing you exactly what it wants to execute and waiting for your explicit Allow or Deny. No surprises.

**Extensibility:**

- Skills Library — import Markdown-based skills from GitHub to teach it your team's conventions

- MCP Servers — built-in support for Rosetta CLI, dbt Core, DuckDB, and DuckLake

**Model support:** OpenAI, Anthropic, Gemini, and Ollama (local models) — via the Vercel AI SDK.

🎬 Full walkthrough: https://www.youtube.com/watch?v=Pva94GLAN90

📥 Download (macOS, Windows, Linux): https://rosettadb.io/download-dbtstudio

⭐ GitHub: https://github.com/rosettadb/dbt-studio

Happy to answer any questions about how the tool-loop works, the MCP integration, or the security model. Would love feedback from the community!

🎬 Watch: https://youtu.be/PU3-mqbnfuM

Rosetta DBT Studio is an open-source desktop workspace for modern data teams. This presentation walks through the full DuckLake workflow — from creating and importing lakehouse instances to exploring metadata, running SQL queries, and building reusable SQL Notebooks — all inside one focused interface.

🔍 Topics covered in this video: • Connecting databases and cloud storage (S3, Azure Blob, Google Cloud Storage) • Creating and importing DuckLake instances with the guided setup wizard • Browsing tables, views, schemas, statistics, Parquet files, partitions, and snapshot history • DuckLake operations: schema evolution, row updates, deletes, and data imports • SQL Editor with Monaco autocomplete, query execution, result p

https://www.youtube.com/watch?v=twUizXBnfXs

Experience a unified desktop workspace built for modern data teams.

dbt Studio brings DuckLake management, SQL exploration, and repeatable analytics into one powerful interface. In this video, we walkthrough the complete DuckLake workflow—from connecting cloud storage and setting up new lakehouses to running advanced SQL queries and documenting analysis in SQL Notebooks.

Key Features: • Unified Connections: Manage databases and cloud object storage (S3, Azure Blob, GCS). • DuckLake Wizard: Guided setup for creating new or importing existing DuckLake instances. • Visual Control Center: Inspect schemas, table statistics, partitions, and snapshot history. • Monaco-Powered SQL Editor: Full autocomplete, pagination, and dataset exports. • SQL Notebooks: Combine SQL and Markdown for repeatable analysis.

🚀 DOWNLOAD DBT STUDIO: https://rosettadb.io/download-dbtstudio

⭐ STAR US ON GITHUB: https://github.com/rosettadb/dbt-studio

#dbtStudio #DuckLake #DuckDB #DataEngineering #Lakehouse #SQL #DataAnalytics