di-agent-query-optimization

What problem does it solve?

This Skill rewrites Substrait plans into a compact full-pushdown form so data integration agents can execute more work inside the database instead of splitting logic across systems.

Core Features & Use Cases

• Pushdown Classification: Distinguishes full SQL pushdown from partial pushdown and stops when the plan cannot be fully preserved.
• Plan-to-SQL Validation: Converts the original plan to SQL, checks that every relation and read is preserved, and confirms same-connection eligibility.
• Optimized Plan Generation: Produces a DataStage-ready Substrait structure with canonical output names, connection metadata, and a trailing SQL SELECT for downstream execution.
• Use Case: A user provides a natural-language data flow request or an existing Substrait plan, and the Skill returns the optimized full-pushdown version that can feed the next DataStage workflow step.

Quick Start

Ask the skill to optimize the attached Substrait plan for full SQL pushdown and return the rewritten plan.