Skip to content
SPECIFICTION
Get listed

drt

github.com

Free plan WindowsmacOSLinuxSelf-hosted
Visit github.com
Spec score 8.1 #9 of 29 in Reverse ETL Tools

What it is

drt is a free reverse ETL tool for moving modeled warehouse data into team tools. Teams define syncs in YAML, version them in Git, install drt-core with pip, and run jobs from the terminal. A dry run with a diff previews rows due to be added, updated, or deleted before writing. The project lists 13 sources and 34 destinations, including BigQuery, Snowflake, Postgres, Slack, and Salesforce, across warehouses, SaaS APIs, cloud storage, files, and webhooks. drt can read dbt projects and use `ref()` models to follow model lineage. Its listed orchestration integrations include Dagster, Prefect, Airflow, and a dbt manifest reader; a GitHub Action supports scheduled or event-triggered syncs. An optional MCP server lets compatible clients validate configuration, run syncs, list them, and inspect status. Data moves directly from the user's warehouse to the destination without a drt-hosted intermediary. Syncs are batch-based, the core is self-hosted, and the project is licensed under Apache 2.0. RBAC, audit logging, plugins, and managed cloud hosting are outside drt-core.

Spec sheet

Purpose
drt moves modeled warehouse data into team tools as reverse ETL, with syncs defined in YAML and versioned in Git.Read 8 Oct 2026 · drt-hub.github.io
Intended users
The site describes drt as suited to teams that ship with dbt and Git and want reverse ETL pipelines managed in their repository.Read 8 Oct 2026 · drt-hub.github.io
Security
The security policy describes Dependabot, CodeQL, pip-audit, and CycloneDX SBOM generation for releases.Read 8 Oct 2026 · github.com
Support
The security policy asks vulnerability reports to be emailed and says receipt is acknowledged within 48 hours, with critical fixes or mitigations within 7 days.Read 8 Oct 2026 · github.com
License
The project is licensed under Apache 2.0.Read 8 Oct 2026 · github.com
AI integration
An optional MCP server lets compatible clients list syncs, run syncs, validate configuration, and inspect status.Read 8 Oct 2026 · github.com
CI/CD
The project provides a GitHub Action for scheduled or event-triggered syncs and documents structured status outputs.Read 8 Oct 2026 · github.com
Connectors
The project lists 13 sources and 34 destinations, including BigQuery, Snowflake, Postgres, Slack, and Salesforce.Read 8 Oct 2026 · drt-hub.github.io
Data handling
The README says data goes directly from the user's warehouse to the destination and never through a drt-hosted intermediary.Read 8 Oct 2026 · github.com
dbt lineage
drt can read dbt projects and use `ref()` models so activation follows the model lineage.Read 8 Oct 2026 · drt-hub.github.io
Enterprise boundary
The open-core document places RBAC, audit logging, plugin system, and managed cloud hosting outside drt-core.Read 8 Oct 2026 · github.com
Orchestration
The README lists integrations for Dagster, Prefect, Airflow, and a dbt manifest reader.Read 8 Oct 2026 · github.com
Preview
`drt run --dry-run --diff` previews which rows will be added, updated, or deleted before writing.Read 8 Oct 2026 · drt-hub.github.io
Telemetry
Telemetry is off by default; when enabled, the project says it collects sync metadata and does not transmit sync names, SQL, destination URLs, credentials, or project paths.Read 8 Oct 2026 · github.com
Workflow
Users install `drt-core` with pip and run syncs from the terminal using `drt run`.Read 8 Oct 2026 · github.com

Plans and prices

drt-core Free All connectors · sync engine · CLI · MCP server · self-hosted Read 8 Oct 2026 · github.com

Every drt plan and price →

Strong points and limits

Strong points

  • Free drt-core includes all connectors and the sync engine.
  • Dry runs preview row changes before writing.
  • Can follow dbt model lineage through `ref()` models.
  • Data passes directly from warehouse to destination.
  • GitHub Action supports scheduled or event-triggered syncs.

Limits

  • Sync frequency is batch.
  • Reverse sync is not supported.
  • RBAC and audit logging are outside drt-core.
  • Managed cloud hosting is outside drt-core.

Who it suits

drt is aimed at teams that work with dbt and Git and want reverse ETL syncs managed in their repository. It may suit teams comfortable installing and running a self-hosted command-line tool.

Verdict

drt offers repository-managed, batch reverse ETL with a broad listed connector set and previewable changes. Teams should note that core is self-hosted and does not include several enterprise features.

Where Specifiction places it

Alternatives to drtAll alternatives →