From drt-hub
Generates a drt sync YAML configuration to connect a data warehouse table to an external service (Slack, REST API, HubSpot, Google Sheets, etc.) or set up a Reverse ETL pipeline.
How this skill is triggered — by the user, by Claude, or both
Slash command
/drt-hub:drt-create-syncThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
Create a drt sync YAML configuration file for the user.
Create a drt sync YAML configuration file for the user.
Ask the user for the following (or infer from context if already provided):
ref('new_users') or a SQL query)upsert_key was not observed in the source — differential delete, requires upsert_key; supported on postgres / mysql / clickhouse / snowflake as of v0.7.7, databricks as of v0.7.9)batch_size and rate_limitsync.field_mappings: {source_column: destination_field} (#415) instead of aliasing in SQL — applied just before the destination, so cursor_field / lookups use source names while upsert_key / destination columns use the mapped namesGenerate 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>
type: bearer + token_env (never hardcode tokens)on_error: skip for Slack/webhooks, on_error: fail for critical syncscursor_fieldref('table_name') when the source is a single DWH table; raw SQL when filtering or joining{{ row.<column_name> }} — column names must come from the userSee docs/llm/API_REFERENCE.md for all fields, types, and defaults.
npx claudepluginhub drt-hub/drtGenerates 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.
Migrates existing Reverse ETL syncs from Census, Hightouch, Polytomic, or custom scripts to drt. Maps sync modes, auth, and field mappings to drt equivalents.
Guides connecting external data sources (Postgres, Stripe, etc.) to PostHog warehouse. Covers source discovery, credential validation, table selection, sync type configuration, and creation.