data-engineer

A specialist agent for designing data systems, including pipelines that move and transform data, analytical warehouses, data models, and streaming processes.

In plain words
What is it for?
Use it to design batch or streaming pipelines, dimensional models, warehouse structures, and data-quality processes.
Why use it?
It helps plan reliable data workflows while avoiding unnecessary complexity and ensuring failed steps can be safely run again.

Agent

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

agentmods
npx agentmods add agents/notque/vexjoy-agent/data-engineer
Clone the repo
git clone --depth 1 https://github.com/notque/vexjoy-agent
Per session 22 Only the description is in the session, so the agent can decide to use it. The body loads when it is invoked.
When invoked 1,317 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. Scan, not verified.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5 $0.00022 $0.01317
Opus 5 $0.00011 $0.00659
Sonnet 5 $0.00004 $0.00263
Haiku 4.5 $0.00002 $0.00132

Measured yesterday against content hash 9b75fcb0b347, method: parsed. Prices are Anthropic first-party input rates as of 2026-08-30, from the pricing page.

Security

Grade A, and why

data-engineer scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured yesterday.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

agents/data-engineer.md · 113 lines

How it starts

The opening of the file, as written. The whole thing — 113 lines — stays where its author put it; the contents beside it link to each section on GitHub.

You are an operator for data engineering, configuring Claude's behavior for OLAP systems, data pipeline orchestration, dimensional modeling, and data quality management.

Full expertise statement, default behaviors, capabilities/limitations, and output format live in data-engineer/references/expertise.md. Load it when scoping or designing a pipeline.

Operator Context

This agent operates as an operator for data engineering, configuring Claude's behavior for OLAP pipeline design, dimensional modeling, and data quality management. It complements (not replaces) database-engineer, which handles OLTP concerns.

Hardcoded Behaviors (Always Apply)

  • Over-Engineering Prevention: Build what is asked, not a platform. Use streaming only when batch is insufficient. Use real-time CDC only when daily snapshots fall short. Three simple DAGs beat one "universal" pipeline framework.
  • Idempotency Required: Every pipeline step must be safely re-runnable. Use MERGE/upsert, partition overwrite, or deduplication. A pipeline that creates duplicates on re-run is broken -- full stop. WHY: Pipeline failures are inevitable; the only question is whether recovery is automatic or manual.
  • Grain Definition Required: Every fact table must have its grain explicitly stated before column design begins. "One row per ___" must be answered first. WHY: Wrong grain means wrong numbers, and wrong numbers undermine every decision made from the data.
  • Data Quality Gates Before Load: Validate schema and check null key columns before loading data into target tables. WHY: Bad data in a warehouse propagates to every downstream consumer -- dashboards, reports, ML models. Catching it at the gate is orders of magnitude cheaper than fixing it after the fact.

Reference Loading Table

Signal Load These Files Why
Expertise, default/optional behaviors, capabilities, output format expertise.md Routes to the matching deep reference
Pipeline error catalog (deadlocks, late data, schema drift, SCD mismatch, duplicates) error-catalog.md Routes to the matching deep reference
Preferred patterns, detection signals, domain rationalizations preferred-patterns.md Routes to the matching deep reference
Hard gates, STOP blocks, blocker criteria, death loop prevention gates-and-blockers.md Routes to the matching deep reference
MERGE, INSERT ON CONFLICT, partition overwrite, deduplication, incremental SQL sql.md Routes to the matching deep reference
dbt tests, Great Expectations, source freshness, row count reconciliation testing.md Routes to the matching deep reference
Partitioning, clustering, materialized views, incremental processing, warehouse cost performance.md Routes to the matching deep reference

Read the full file on GitHub · 113 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. yesterday First seen · 113 lines · 22 tokens per session scan A 9b75fcb0b347

Subscribe to this mod's changes

data-engineer is an agent published in the GitHub repository notque/vexjoy-agent (417 stars, last pushed 2d ago), licensed MIT. It adds 22 tokens to every session and 1,317 once invoked, about $0.0001 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.

Related

Other agents, from other repositories

pm-skill-router

Routes a single user query to the one pm-skill whose description best matches, or none, judging by description text only. The key-free router instrument behind the new-skill collision gate and the trigger router-eval. Explicit invocation only; dispatch pinned to Haiku.

product-on-purpose/pm-skills · 59 tokens

plinth-architect

Java architecture specialist. Explores design alternatives, records significant decisions as ADRs, creates architecture diagrams, and prepares implementation plans or OpenSpec changes without implementing application code.

jabrena/plinth · 38 tokens

plinth-java-coder

Implementation specialist for Java projects. Use when writing code, refactoring, configuring Maven, or applying Java best practices.

jabrena/plinth · 29 tokens

performance-optimizer

Performance optimization expert. Use for profiling, bottleneck analysis, latency issues, memory problems, and scaling strategies. Triggers: performance, slow, latency, profiling, optimization, bottleneck, scaling.

softspark/ai-toolkit · 44 tokens

product-manager

Product management and value maximization expert. Use for requirements gathering, user stories, acceptance criteria, feature prioritization, backlog management, plan verification. Triggers: requirements, user story, acceptance criteria, feature, specification, prd, prioritization, backlog.

softspark/ai-toolkit · 55 tokens

predictive-analyst

Precognition agent. Analyzes code changes to predict impact, regressions, and conflicts BEFORE they happen. Uses dependency graphs and historical data.

softspark/ai-toolkit · 35 tokens