Skip to content
OpenAgentSkill
Browsing is open · Catalog captured 2026-11-21 · Automatic updates and account services are paused.
Data & analytics

Aqueduct

LLM-driven data engineering agent that automates SQL generation and ETL workflows from natural language requirements.

JohnnyQ-commits · AI review on file

Installation

Read the source and dependencies before running a command. Copying does not install or execute anything.

npx skills add JohnnyQ-commits/Aqueduct

About this skill

Aqueduct

Data Engineering Automation Agent Framework

English | 中文


Overview

The problem: Data engineers spend 60-70% of their time on repetitive work — understanding requirements, writing boilerplate SQL, creating DDL, writing DQC tests, generating documentation. The creative part (business logic) is small; the mechanical part is huge.

Aqueduct automates the mechanical part.

Give it a requirement document. Get back 11 standardized deliverables: DDL, ETL SQL, DQC test cases, field-level lineage, design documents, and a comprehensive report.

Requirement (.md) --> Design (.md) --> DDL (.sql) --> SQL (.sql) --> Review --> DQC (.sql) --> Report (.md) --> Deliverables (11 files)

What makes it different

PrincipleWhat it means
Framework, not toolEmbed into Claude Code, LangChain, or your own app via from aqueduct import Aqueduct
7-layer architectureClean separation: MCP / LLM / Tools / Skills / Engine / Memory / Config
Platform agnosticConnects to any data platform via standard MCP protocol (.mcp.json)
Ontology knowledgeBusiness domains modeled as typed JSON — entities, relationships, metrics, axioms
DAG orchestrationStateGraph-based workflow with interactive checkpoints and error recovery
Review-fix loopCode review finds bugs → auto-fix SQL → re-review → production-ready quality
Full observabilityPer-task log files, phase timing, LLM call tracing, tool execution audit
Prompt-code decoupledPrompts as .tpl.md files — edit without touching code