DB ETL Pipeline

Query PostgreSQL, summarize transformation logic, and push cleaned data summaries to Sheets.

⚡ POWER LEVEL

MODERATE

TRUST SCORE73 / 100

◈ Use Case

Run SQL extraction, transform insights with Claude, then report completion in Slack.

◈ Skill Pipeline (4 nodes)

1. Postgres QueryInput

2. Claude AnalyzeLLM

3. Google Sheets AppendOutput

4. Slack Post MessageOutput

◈ Dependencies (3)

pg-query→claude-analyze· raw dataset

claude-analyze→google-sheets-append· transformed output

google-sheets-append→slack-post· etl complete

Pipeline Graph

React Flow

≪ ◈ COOKBOOK ◈ ≫

▸ QUICK START

# install the CLI
npm install -g rune-hub-cli

# set up auth
rune auth pg
rune auth anthropic
rune auth telegram

# run it
rune install db-etl-pipeline
rune run db-etl-pipeline

▸ INGREDIENTS — 4 SKILLS

01⚙️Postgres QueryInput

02🧪Claude AnalyzeLLM

03⚙️Google Sheets AppendOutput

04💬Slack Post MessageOutput

▸ WHAT YOU'LL NEED

ANTHROPIC_API_KEY↗ console.anthropic.com

Est. cost per run: ~$0.03–0.08

◈ Skill Breakdown — 4 Skills

Avg Safety73/100

⚙️Postgres QueryInput

pg-query

Moderate

🧪Claude AnalyzeLLMClaude

claude-analyze

Perform deep analysis on data or text using Claude.

High Safety

↗ Docs

⚙️Google Sheets AppendOutput

google-sheets-append

Moderate

💬Slack Post MessageOutputSlack

slack-post

Post a message to a Slack channel or thread.

Moderate

↗ Docs

Pipeline Safety Score

73/100 — Moderate

4 skills analyzed