dbt-osmosis
dbt-osmosis is a Python CLI and Streamlit workbench for automating dbt development workflows, focusing on schema YAML management, documentation inheritance, and interactive SQL development. It integrates with dbt Core 1.8+ and provides command families for generation, schema diffing, validation, and testing helpers.
Key facts
Objective fields from the source. Values we can't verify are shown as “Unknown” rather than guessed.
| Field | Value |
|---|---|
| Repository | z3z1ma/dbt-osmosis |
| Owner | z3z1ma |
| Primary language | Python |
| License | Apache-2.0 — OSI-approved |
| Stars | 632 |
| Forks | 83 |
| Open issues | 1 |
| Latest release | v1.5.0 (2026-07-05) |
| Last updated | 2026-07-05 |
| Source | https://github.com/z3z1ma/dbt-osmosis |
What dbt-osmosis is
A Python package exposing CLI commands and a Streamlit UI for dbt lineage-aware YAML orchestration, column-level documentation propagation, SQL compilation/execution, and optional LLM-assisted code generation. Targets Python 3.10–3.13 with dbt Core ≥1.8 and supports multiple database adapters via plugin architecture.
Get the dbt-osmosis source
Clone the repository and explore it locally.
git clone https://github.com/z3z1ma/dbt-osmosis.gitcd dbt-osmosis# follow the project's README for install & configurationNeed it deployed, integrated, or customized instead? DEV.co ships production installs.
Best use cases
Implementation considerations
- Set `+dbt-osmosis` routing in dbt_project.yml and optionally configure `dbt-osmosis.yml` with formatter and folder-level behavior before first run.
- Install optional extras (`[workbench]`, `[duckdb]`, `[openai]`, `[azure]`, `[proxy]`) depending on workflow—base install covers YAML and SQL commands.
- Audited dbt Core support is 1.8.x–1.11.x; newer minors use canary CI but are not yet officially supported; verify adapter compatibility in your environment.
- Pre-commit hook integration is supported; see hook example in README for YAML refactor automation in CI/CD pipelines.
- LLM features (natural-language generation, synthesis) require explicit optional dependencies and separate configuration; Azure OpenAI is supported via `[azure]` extra.
When to avoid it — and what to weigh
- dbt Core < 1.8 Required — The package explicitly targets dbt Core ≥1.8 with audited blocking support through 1.11.x. Older dbt versions are not supported.
- Python < 3.10 Environment — Requires Python 3.10–3.13. Legacy Python 2 or <3.10 environments cannot use this tool.
- Proxy Server Use Case — The experimental SQL proxy module is explicitly not hardened for production and should not be exposed to untrusted networks; it defaults to local-only MySQL-mimic behavior.
- Minimal Documentation & Governance — If your team does not manage dbt YAML or prioritize column-level documentation, the tool's primary value is underutilized.
License & commercial use
Apache License 2.0 (Apache-2.0) is a well-established OSI-approved permissive license allowing commercial use, modification, and distribution with standard attribution and liability disclaimers.
Apache-2.0 permits commercial use without explicit proprietary licensing fees. No source code review of Devco's commercial arrangement was conducted; typical OSI commercial use is permitted, but product integration and support terms should be verified with the maintainer if commercial support or indemnification is required.
DEV.co evaluation signals
Editorial assessment — not user reviews. Directional, with an explicit confidence level.
| Signal | Assessment |
|---|---|
| Maintenance | Active |
| Documentation | Strong |
| License clarity | Clear |
| Deployment complexity | Low |
| DEV.co fit | Good |
| Assessment confidence | High |
Standard considerations: (1) Streamlit workbench and proxy module have local-only threat model; proxy should never be exposed to untrusted networks. (2) LLM features transmit data to external APIs (OpenAI, Azure OpenAI); review data handling policies. (3) dbt adapter credentials are managed by dbt Core, not dbt-osmosis. (4) No security audit or penetration test results provided. (5) Dependency supply-chain: Python ecosystem dependencies should be monitored via standard OSS tools.
Alternatives to consider
dbt-docs / dbt Artifacts Browser
Native dbt documentation generation; lighter-weight but does not automate YAML management or provide interactive SQL workbench.
dbt Cloud IDE
Managed, hosted dbt environment with built-in editor and documentation; requires subscription and cloud-hosted dbt account; full feature parity differs.
Teams can build custom orchestration; requires engineering time and lacks dbt-osmosis's documentation inheritance and Streamlit UI.
Build on dbt-osmosis with DEV.co software developers
Explore dbt-osmosis's CLI, documentation, and Streamlit workbench. Check the docs site and quickstart to configure YAML routing and test changes safely in your dbt project.
Talk to DEV.coRelated on DEV.co
Explore the category and the services that help you build with it.
dbt-osmosis FAQ
Does dbt-osmosis modify or store dbt code or data?
Is the Streamlit workbench production-ready?
What happens if a new dbt Core minor is released?
Can I use dbt-osmosis with Snowflake/BigQuery/other adapters?
Software development & web development with DEV.co
DEV.co helps companies turn open-source tools like dbt-osmosis into production software. Our software development services cover the full lifecycle — architecture, web development, integration, and maintenance — delivered by software developers and web developers who ship. Engage our software development agency to implement or customize it for your open-source databases stack.
Ready to automate your dbt workflows?
Explore dbt-osmosis's CLI, documentation, and Streamlit workbench. Check the docs site and quickstart to configure YAML routing and test changes safely in your dbt project.