Skill

drt-create-sync

Generates drt sync YAML configuration files for Reverse ETL pipelines, syncing data warehouse tables via dbt refs or SQL to destinations like Slack, APIs, databases, or Jira.

dbt

data-engineering

npx claudepluginhub drt-hub/drt

Tool Access

This skill uses the workspace's default tool permissions.

Preview

Create a drt sync YAML configuration file for the user.

SKILL.md

Similar Skills

drt-create-sync

Generates drt sync YAML configuration files for Reverse ETL pipelines, connecting data warehouse tables via dbt refs or SQL to destinations like Slack, Discord, REST APIs, HubSpot, GitHub Actions, Google Sheets, PostgreSQL, or MySQL.

drt

drt-migrate

Migrates Reverse ETL syncs from Census, Hightouch, Polytomic, or custom scripts to drt by mapping sources, destinations, schedules, and generating sync YAML configs.

drt-hub

setting-up-a-data-warehouse-source

Guides connecting data warehouse sources like Postgres, MySQL, Stripe, HubSpot, MongoDB, Salesforce, BigQuery, Snowflake to PostHog via wizard, credential validation, table discovery, sync selection, and creation.

1 file

posthog

Stats

Stars22

Forks32

Last CommitApr 16, 2026

Actions

View Source View Plugin View on GitHub View README

Help us improve

Share bugs, ideas, or general feedback.

Create a drt sync YAML configuration file for the user.

Steps

Ask the user for the following (or infer from context if already provided):
- Source table or SQL: what data to sync (e.g. ref('new_users') or a SQL query)
- Destination: where to send it (Slack, Discord, Microsoft Teams, REST API, HubSpot, GitHub Actions, Google Sheets, PostgreSQL, MySQL, ClickHouse, Parquet, CSV/JSON/JSONL, Jira, Linear, SendGrid, Staged Upload (async bulk APIs), or other)
- Sync mode: full (every run), incremental (watermark-based, needs cursor column), upsert (dedup by key), or replace (TRUNCATE + INSERT for full table refresh)
- Frequency intent: helps set batch_size and rate_limit
Generate a valid sync YAML using the exact field names from docs/llm/API_REFERENCE.md.
Output the YAML in a code block and suggest where to save it: syncs/<name>.yml

Show the command to validate and run it:

drt validate
drt run --select <name> --dry-run
drt run --select <name>

Rules

Use type: bearer + token_env (never hardcode tokens)
Default on_error: skip for Slack/webhooks, on_error: fail for critical syncs
For incremental mode, always include cursor_field
Use ref('table_name') when the source is a single DWH table; raw SQL when filtering or joining
Jinja2 templates use {{ row.<column_name> }} — column names must come from the user

Reference

See docs/llm/API_REFERENCE.md for all fields, types, and defaults.