A modern web-based user interface for dbt-core projects.

The easiest way to run dbt UI is using Docker:

# Clone the repository
git clone https://github.com/data-diving/dbt-ui.git
cd dbt-ui

# Run with Docker Compose
docker-compose up --build

# Or use existing git repositories from your computer
GIT_REPOS_PATH=/path/to/your/repos docker-compose up --build

Set GIT_REPOS_PATH to point to your existing repos folder to work with local repositories.

Open your browser and navigate to http://localhost

The backend API is available at http://localhost:8000

This application consists of two parts:

• Frontend: React + TypeScript web application (Vite) - served via nginx
• Backend: FastAPI Python server for file system operations

• Project Browser: Browse your dbt project structure with an intuitive tree view
• Code Editor: Edit SQL models, YML configurations, tests, and macros with Monaco Editor
• Lineage Graph: Visualize model dependencies and data lineage
• Quick Actions: Run dbt commands, compile models, and manage your project
• Local File Access: No file uploads - backend reads files directly from your filesystem
• Git Integration: View modified files, stage changes, commit, push/pull, and switch branches
• MetaDV: Visual Data Vault modeling - map source columns to entities and generate Data Vault 2.0 models using metadv package

Note: Only git-based dbt projects are supported. The project must be a git repository.

Like dbt-ui and want to help make it even better? Check out our Contributing Guide to get started with discussions, issues, and pull requests. Your contributions help improve the experience for everyone!

dbt-ui/
├── frontend/           # React frontend application
├── backend/            # FastAPI backend server
├── docker/             # Docker configuration
├── docker-compose.yml
└── README.md

This project is licensed under the MIT License.

This project uses open-source libraries under various permissive licenses (MIT, Apache-2.0, BSD-3-Clause, ISC).

When you install dependencies via npm install and pip install or build a Docker image their license files are placed in:

• Frontend: node_modules/ (view with npm ls)
• Backend: Python site-packages (view with pip list)

For license texts and copyright information, check each package's GitHub repository

• dbt, dbt Core, and dbt Labs are trademarks of dbt Labs, Inc.
• Docker and the Docker logo are trademarks or registered trademarks of Docker, Inc.

This project is not affiliated with, endorsed by, or sponsored by dbt Labs, Inc. or Docker, Inc.