AI-Powered Data Engineering in VS Code

Accelerate your data workflows with our AI-driven VS Code extension.
Effortlessly create models, generate transformations, and deploy to Snowflake - all within your favorite code editor.

Intelligent Codebase Indexing: AI That Knows Your Project

Brew Code deeply understands your dbt project's unique architecture, naming conventions, and dependencies. It creates an intelligent index for hyper-relevant and immediately usable responses, tailored to your workflow.

Context-Aware Code Generation: Write dbt Code That Fits

Generate dbt models, macros, and tests from natural language prompts. Brew Code seamlessly integrates new code, adopting your project's naming conventions, materialization strategies, and custom macros.

Automated Schema Documentation: Goodbye, yml Tedium

Automatically generate comprehensive schema.yml files. Brew Code populates column names, suggests data types, and infers descriptions from your dbt models, keeping your project well-documented.

In-Editor Code Explanation: Understand Your dbt Faster

Ever stare at a complex dbt model wondering what it does? Brew Code lets you select any code snippet in your editor, right-click, and instantly get a clear, concise explanation.

Specialized AI Modes: The Right Tool for Every dbt Task

Brew Code offers four specialized AI modes: Generate for creating dbt assets, Plan for architectural design, Ask for codebase-specific answers, and Debug for troubleshooting. Each mode is supercharged by intelligent codebase indexing for focused efficiency.

Ask Mode

Get project-specific answers about dbt best practices

Plan Mode

Architect your dbt project and model dependencies

Generate Mode

Create dbt models, macros, and tests from natural language

Debug Mode

Systematically diagnose errors and performance issues

MCP Server

To enable database introspection and enrich Brewdata’s capabilities

Instant Command Execution: Act on Suggestions Instantly

Don't break your flow. When Brew Code suggests a fix, an optimization, or any dbt command, you can execute it directly from the chat interface. No more copying, pasting, or switching terminals. Just a single click to apply changes, run tests, or update your project, making your development process incredibly fluid and efficient.

Supported Platforms

dbt Core
dbt Fusion
Snowflake

Coming Soon

Databricks
BigQuery
RedShift

Built for Analysts & Data Engineers

AI Model Builder

Describe models, get SQL, refs, and docs instantly

Run & Deploy Faster

One-click dbt model runs on Snowflake

Stay in Your IDE

No context switching: code, test, run in one place