---
id: dbt-core-interface
version: "1.1.7"
license: MIT
license_treatment: permissive
maintenance: aging
---

# dbt-core-interface — Dbt Core Interface

License: permissive · Maintenance: aging · Downloads: 109.0K/mo

## What it is and what it does

dbt-core-interface wraps dbt-core (v1.8+) in a Python API that lets you compile, execute, and manage dbt projects entirely in memory without invoking the dbt CLI. It hydrates dbt's RuntimeConfig, resolves refs and sources, renders Jinja macros, and integrates SQLFluff for linting and formatting—all callable from Python code or exposed via a FastAPI server.

The package supports multiple projects simultaneously through DbtProjectContainer, background file watching for auto-reparsing, and direct dbt command passthrough (run, test, docs serve). It also includes data quality monitoring with check types like RowCountCheck and NullPercentageCheck, plus a generic test library for schema validation. Typical use cases include building custom dbt tooling, embedding dbt workflows in Python applications, and prototyping dbt extensions outside the core repository.

Use it for:

- Build a FastAPI service that compiles and lints dbt SQL on demand without spawning dbt CLI processes.
- Programmatically execute dbt models and tests from Python, capturing results for custom reporting or alerting.
- Manage multiple dbt projects in a single Python process, switching contexts and running checks across them.
- Integrate dbt compilation and macro rendering into a custom IDE or editor plugin.
- Implement automated data quality checks and webhook-based alerts on model outputs.

## Worth the install?

AI-flagged interpretation of the facts above — verify before relying.

Provides a lightweight Python interface to dbt-core (v1.8+) for in-memory SQL compilation, macro evaluation, and project management without leaving Python.

Yes, if you need to embed dbt workflows into Python applications or build custom dbt tooling. The low install friction, permissive license, and active repository make it a reasonable choice. However, maintenance is aging (215 days since release), so verify that the version supports your dbt-core release and that data quality features meet your stability requirements before relying on them in production.

## Install

pip install dbt-core-interface
uv add dbt-core-interface
poetry add dbt-core-interface

## Installing dbt-core-interface

Before you install: Low install friction with a pure-Python wheel. Depends on dbt-core, dbt-adapters, rich, typing-extensions, and requests. Maintenance status is aging (215 days since last release), though the repository remains active and unarchived.

License in practice: MIT license is permissive; you can use, modify, and distribute this package with minimal legal restriction, provided you include the license notice.

Quickstart:

pip install dbt-core-interface

from dbt_core_interface import DbtProject

project = DbtProject(project_dir="/path/to/dbt_project")
result = project.execute_sql("SELECT current_date AS today")
print(result.table)

Requires Python 3.10+ and dbt-core >= 1.8.0 to be installed and configured with a valid profiles.yml.

Verify before relying:

- Whether the package's data quality monitoring and generic test library features are production-ready or still experimental.
- Performance characteristics and scalability limits when managing many concurrent projects or large dbt manifests.
- Compatibility with dbt-core versions beyond 1.8 and any breaking changes in recent dbt releases.

## Package facts

- License: MIT (permissive)
- Python support: supports_current
- Install friction: low
- Maintenance: aging
- Downloads: 109.0K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

dbt core python interface, programmatic dbt sql compilation, dbt project in-memory execution, dbt fastapi server, dbt macro evaluation python, thread-safe dbt runtime, dbt multi-project management, dbt-integration, sql-compilation, data-quality

[View on SkillFed](https://skillfed.io/packages/dbt-core-interface) · [View on PyPI](https://pypi.org/project/dbt-core-interface/)