Brewdata provides an AI‑powered VS Code extension that indexes dbt projects to deliver context‑aware code generation, instant explanations, and automated schema documentation. The tool lets data engineers and analysts generate models, tests, and YAML files on demand and execute dbt commands directly from the editor, reducing context switching and speeding up development.
Funding
Funding not disclosed
Founders
Product
Problem
Data engineers and analysts using dbt often struggle with manual schema documentation, repetitive test creation, and context switching between IDEs, terminals, and database consoles, which slows development and increases the risk of errors.
Solution
Brewdata offers an AI-powered VS Code extension that deeply indexes a dbt project to provide context-aware code generation, explanations, and automated documentation. The extension can generate model code, schema.yml files, and test cases on demand, and it allows users to execute dbt commands (run, test, compile) directly from the editor. Integrated visual lineage and reference exploration give instant insight into model dependencies, while instant command execution lets users apply suggested fixes with a single click, keeping the workflow within the IDE.
Target Audience
Primary users are data engineers and analysts who develop and maintain dbt projects and need an integrated, AI‑enhanced environment to accelerate coding, testing, and documentation.
Features
- Project-specific indexing that understands dbt naming conventions, dependencies, and architecture for precise AI assistance
- Prompt-based generation of dbt models, schema.yml definitions, field descriptions, and smart test suggestions
- In-editor explanations of SQL snippets and transformation logic with a right‑click context menu
- One‑click execution of dbt commands (run, test, compile, preview) on Snowflake directly from VS Code, with results shown in the terminal and sidebar
- Automatic updating of documentation and YAML files as models evolve
- Interactive visual lineage graph with upstream/downstream navigation and ref usage indicators
- Support for dbt Core, dbt Fusion, and Snowflake; additional platforms (Databricks, BigQuery, Redshift) announced