llms.txt
# Bruin
> Bruin is an open-source, AI-powered data platform. Its Apache 2.0 CLI handles data ingestion (with ingestr), SQL and Python pipelines, quality checks, column-level lineage, catalog, and orchestration; on top of that governed data, an AI data analyst answers questions in Slack, Microsoft Teams, Google Chat, WhatsApp, Discord, Telegram, email, or the browser, builds dashboards from a prompt, and runs scheduled agents. Pipelines are plain files in your own Git repository and data stays in your own warehouse; Bruin Cloud is the optional managed layer.
## Core pages
- [Home](https://getbruin.com/): AI data analyst and end-to-end data platform overview.
- [AI data analyst](https://getbruin.com/ai-data-analyst/): Ask data questions, build dashboards, and investigate issues from chat.
- [Slack AI data analyst](https://getbruin.com/ai-data-analyst/slack/): Ask governed company data questions from Slack.
- [Product overview](https://getbruin.com/platform/): Ingestion, pipelines, checks, lineage, governance, and AI analysis in one platform.
- [Ingestion](https://getbruin.com/product/ingestion/): Move data from SaaS tools, databases, files, and APIs with Bruin and ingestr.
- [Security](https://getbruin.com/security/): SOC 2, GDPR, warehouse-native execution, RBAC, audit logs, and private connectivity.
## Open-source tools
- [Bruin CLI docs](https://getbruin.com/docs/bruin/): Build data pipelines in SQL and Python, run checks, and manage assets locally or in CI.
- [ingestr docs](https://getbruin.com/docs/ingestr/): Open-source ingestion CLI for moving data from many sources into warehouses and lakes.
- [GitHub: bruin](https://github.com/bruin-data/bruin): Open-source Bruin CLI repository.
- [GitHub: ingestr](https://github.com/bruin-data/ingestr): Open-source ingestr repository.
## Learn
- [Bruin Academy](https://getbruin.com/learn/): Hands-on tutorials for AI analysts, Bruin Cloud, pipelines, and data apps.
- [Bruin Cloud tutorial](https://getbruin.com/learn/bruin-cloud/): Create projects, connect data, enable pipelines, and use AI agents.
- [AI data analyst tutorial](https://getbruin.com/learn/ai-data-analyst/): Build an AI data analyst connected to company data.
- [SEO optimizer agent tutorial](https://getbruin.com/learn/seo-optimizer-agent/): Build a scheduled GA and GSC analysis agent.
- [Data Engineering Zoomcamp Bruin companion guide](https://getbruin.com/learn/zoomcamp/): Unofficial companion for the free DataTalks.Club course, showing learners how to build a portfolio-ready Bruin pipeline with ingestr, SQL/Python transforms, checks, and lineage.
- [Migrate Fivetran connectors to Bruin ingestr](https://getbruin.com/learn/fivetran-to-bruin-ingestr/): A staged, agent-assisted migration with a read-only Fivetran importer, review gates, and parallel validation.
## Comparisons and intent pages
- [Alternatives to Airflow](https://getbruin.com/alternatives/airflow-alternative/): Compare Bruin with Apache Airflow for modern data workflows.
- [Claude Dashboards vs Bruin](https://getbruin.com/comparisons/claude-dashboards-vs-bruin/): Claude Dashboards (beta, October 2026) writes a SQL query per chart on the warehouse you connect; Bruin builds AI dashboards on the pipeline, checks, lineage, and shared metric definitions behind it.
- [ChatGPT vs Bruin](https://getbruin.com/comparisons/chatgpt-vs-bruin/): ChatGPT's Data agent and Dots query what you connect them to; Bruin runs the pipeline, checks, and lineage behind every answer, in Slack, Teams, and WhatsApp.
- [dbt vs Bruin](https://getbruin.com/comparisons/dbt-vs-bruin/): Compare transformation-only workflows with Bruin's ingestion, orchestration, checks, and AI layer.
- [AI data analyst by team](https://getbruin.com/use-cases/teams/): Which AI data analyst fits marketing, sales, RevOps, finance, customer success, product, operations, support, founders and small data teams, with the shortlist compared and how to set it up.
- [AI data analyst by industry](https://getbruin.com/use-cases/industries/): Which AI data analyst fits ecommerce, SaaS, mobile gaming, consumer apps, fintech, marketplaces, agencies and more, and what tools each industry uses for business analytics.
- [Integrations](https://getbruin.com/integrations/): Browse supported data sources and destinations.
- [Project showcase](https://getbruin.com/project-showcase/): Example data projects and community submissions.
## Explainers (definitions with worked Bruin examples)
- [What is a data quality check](https://getbruin.com/blog/what-is-a-data-quality-check/): Check types, where a check should run, and how to add blocking checks to a pipeline.
- [What is data freshness](https://getbruin.com/blog/what-is-data-freshness/): Freshness and completeness, SLAs, and how to check both inside the pipeline.
- [What is a data contract](https://getbruin.com/blog/what-is-a-data-contract/): What a contract contains and how to enforce it with policies and blocking checks.
- [What is column-level lineage](https://getbruin.com/blog/what-is-column-level-lineage/): Parsed-from-code versus query-log lineage, impact analysis before a schema change.
- [What is pipelines as code](https://getbruin.com/blog/what-is-pipelines-as-code/): Every part of a pipeline as files in git, validated on pull request, deployed on merge.
- [What is an AI data analyst](https://getbruin.com/blog/what-is-an-ai-data-analyst/): How it differs from a BI tool and from ChatGPT on a spreadsheet, and what makes answers accurate.
- [What is agentic data engineering](https://getbruin.com/blog/what-is-agentic-data-engineering/): AI coding agents building, testing and repairing pipelines through MCP.
- [What is a data orchestrator](https://getbruin.com/blog/what-is-a-data-orchestrator/): What Airflow, Dagster and Prefect do, and when a pipeline framework removes the layer.
- [What does a modern data stack cost](https://getbruin.com/blog/what-does-a-modern-data-stack-cost/): Per-row, per-seat, per-credit and per-hour pricing with vendor list prices.
- [What is headless BI](https://getbruin.com/blog/what-is-headless-bi/): Semantic layer separated from the front end; code-first BI tools compared.
- [What is a data catalog](https://getbruin.com/blog/what-is-a-data-catalog/): What a catalog holds, crawled versus derived from the pipeline, when a small team needs one.
- [Data quality and testing strategies](https://getbruin.com/blog/data-quality-testing-strategies-data-pipelines/): Open-source and enterprise DQ tools, automated checks, data contracts.
- [How to build a context layer for AI-ready pipelines](https://getbruin.com/blog/how-to-build-a-context-layer-for-ai-ready-data-pipelines/): Automated documentation, lineage, and a semantic layer agents read over MCP.
- [How to build your first ELT pipeline with SQL and Python](https://getbruin.com/blog/how-to-build-your-first-elt-pipeline-sql-python/): Public API to DuckDB in ten minutes, then Snowflake, BigQuery or Databricks.
- [What is ELT](https://getbruin.com/blog/what-is-elt/): ELT vs ETL, why warehouses made ELT the default, and how Bruin covers both the load and the transform.
- [What is data observability](https://getbruin.com/blog/what-is-data-observability/): The five signals, how observability differs from testing, and how Bruin runs both from the pipeline.
- [What is an MCP server for data tools](https://getbruin.com/blog/what-is-an-mcp-server-for-data/): How AI agents query pipelines and warehouses through MCP, and what Bruin's server exposes.
- [What is impact analysis for a schema change](https://getbruin.com/blog/what-is-impact-analysis-for-a-schema-change/): Finding what breaks before a column rename, with column-level lineage from the CLI.
- [What is dashboards as code](https://getbruin.com/blog/what-is-dashboards-as-code/): Code-first BI, why teams switch, and how Bruin generates dashboard files from a prompt.
- [How to onboard an AI data agent like a new hire](https://getbruin.com/blog/onboard-ai-data-agent-like-a-new-hire/): Four phases to build agent context - orientation, onboard, internship, hire - with the evidence that ends each one.
- [The best context is no context](https://getbruin.com/blog/best-context-is-no-context/): What context to write for AI agents - reuse, reduce, recycle; one fact, one home; why a conflict is worse than a gap.
- [How to keep an AI context layer from going stale](https://getbruin.com/blog/keep-ai-context-layer-current/): Local review, CI, scheduled audits, and channel feedback that turn drift into reviewed changes.
## Migration and ownership
- [How hard is it to migrate to Bruin](https://getbruin.com/blog/how-to-migrate-to-bruin/): Tool-by-tool path with bruin import database, Jinja for dbt models, the Fivetran migration template, and running Bruin from Airflow.
- [Does Bruin lock you in](https://getbruin.com/blog/does-bruin-lock-you-in/): What you own (files in your git, data in your warehouse, Apache 2.0 CLI), what Cloud adds, and how you would leave.
- [Which data tools have a built-in MCP server](https://getbruin.com/blog/data-tools-with-mcp-servers-2026/): Bruin, dbt, Snowflake, Databricks, ClickHouse, and the cloud vendors' official servers.
## Useful articles
- [Build your own AI data analyst](https://getbruin.com/blog/build-your-own-ai-data-analyst/): Architecture and implementation guide for AI analysts.
- [Best AI data analyst tools 2026](https://getbruin.com/blog/best-ai-data-analyst-tools-2026/): Comparison of AI tools for data analysis.
- [Claude Dashboards vs Bruin AI dashboards](https://getbruin.com/blog/claude-dashboards-vs-bruin-ai-dashboards/): What Anthropic's Claude Dashboards beta does, where it stops for team dashboards, and when to use Bruin, or both.
- [Can Claude Dashboards replace your BI tool?](https://getbruin.com/blog/can-claude-dashboards-replace-bi/): The four jobs a BI tool does, which one Claude Dashboards covers, and where an AI dashboard on a governed platform like Bruin fits.
- [The best Claude Dashboards alternatives in 2026](https://getbruin.com/blog/claude-dashboards-alternatives-2026/): Bruin, Hex, Omni, Sigma, Lightdash, the ChatGPT Data agent, Basedash, and Looker, with what each is best for.
- [ChatGPT Dots, Meta Muse, and the ChatGPT Data agent vs an AI data analyst](https://getbruin.com/blog/chatgpt-dots-meta-muse-vs-ai-data-analyst/): What the September 2026 agent launches can and cannot do with company data, compared with Bruin.
- [Best semantic layer tools 2026](https://getbruin.com/blog/semantic-layer-tools/): Compare dbt Semantic Layer, Cube, Looker, Power BI, Tableau, AtScale, Lightdash, and Bruin CLI / DAC for BI, reusable metrics, dashboards, and AI agents.
- [What is CDC in data engineering?](https://getbruin.com/blog/what-is-cdc-change-data-capture/): Change data capture explained for data pipelines, including CDC vs ETL, incremental loading, popular CDC tools, Bruin and ingestr CDC support, and when to use CDC.
- [What is CDC streaming?](https://getbruin.com/blog/what-is-cdc-streaming/): Change data capture guide covering database log streaming, Kafka, batch CDC, and Bruin CDC streaming support.
- [How to choose an incremental data loading strategy](https://getbruin.com/blog/how-to-choose-the-right-incremental-strategy/): Decision guide for full refresh, append, merge, delete+insert, time_interval, SCD2, late-arriving data, source deletes, and CDC.
- [Best data pipeline tools 2026](https://getbruin.com/blog/best-data-pipeline-tools-2026/): Compare Airflow, Dagster, Prefect, Mage, and Bruin for data pipelines.
- [Best reverse ETL tools 2026](https://getbruin.com/blog/best-reverse-etl-data-activation-tools-2026/): Segment vs Hightouch vs Census reverse ETL comparison, plus Bruin and other data activation tools.
- [What is reverse ETL?](https://getbruin.com/blog/what-is-reverse-etl/): Practical definition of reverse ETL, common destinations, sync risks, and when to use a tool.
- [Fivetran vs Bruin](https://getbruin.com/blog/fivetran-vs-bruin/): Compare managed ELT with an open-source-first data platform.
- [Migrate from Fivetran to Bruin](https://getbruin.com/blog/migrate-from-fivetran-to-bruin/): Postgres-to-BigQuery migration guide for reducing Fivetran MAR costs with Bruin and ingestr.
- [Export Firebase data to BigQuery](https://getbruin.com/blog/exporting-firebase-data-to-bigquery/): Practical notes for Firebase Analytics BigQuery export.
## Optional full index
- [Full LLM index](https://getbruin.com/llms-full.txt): A longer crawl guide with extra docs, tutorials, and comparison pages.