query-engine

Optimize and execute SQL queries with the Cascades query planner.

3|Updated Aug 4, 2025
One-click install
npx skills add https://github.com/birdayz/fdb-go --skill query-engine
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: query-engine
Source: https://github.com/birdayz/fdb-go/tree/main/.claude/skills/query-engine
Command: npx skills add https://github.com/birdayz/fdb-go --skill query-engine

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill addresses the complexity of optimizing and executing SQL queries within the Cascades query planner and optimizer, ensuring high-quality code and alignment with the Java reference implementation.

Core Features & Use Cases

  • Architectural Review: Ensures changes align with the Cascades framework and Java reference.
  • Code Quality: Reviews for dead code, logic holes, and incomplete conversions.
  • Determinism Checks: Ensures non-deterministic tests pass for consistent results.
  • Review Workflow: Requires approval from both architectural and code quality reviewers.
  • Use Case: When developing a new SQL query optimization rule, this Skill guides the process from initial implementation to final review and deployment.

Quick Start

Start by reading the Java source code for the corresponding SQL component. Implement the new rule with tests, then submit for review by both reviewers.

Frequently Asked Questions about query-engine

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize SQL queries using the Cascades query planner?

To optimize SQL queries using the Cascades query planner, implement new rules based on the Java reference implementation and submit them for architectural and code quality review. This process ensures changes align with the framework and pass determinism checks.

What is the best way to ensure my SQL query optimization rules pass code review?

The best way to pass code review for SQL query optimization rules is to eliminate dead code, fix logic holes, and complete conversions. Your implementation must pass both architectural alignment checks and non-deterministic test requirements.

How does the Cascades query planner handle architectural reviews for new SQL rules?

The Cascades query planner architectural review verifies that new SQL rules match the Java reference implementation and framework guidelines. It requires approval from designated architectural reviewers before deployment.

Why do my non-deterministic tests fail when developing Cascades SQL optimization rules?

Non-deterministic tests fail when SQL optimization rules contain logic holes or incomplete conversions. The Cascades framework requires these tests to pass consistently, ensuring reliable query execution and adherence to code quality standards.

Do I need to read the Java reference implementation before writing Cascades SQL optimization rules?

Yes, you need to read the Java reference implementation before writing Cascades SQL optimization rules. Reading the Java source code for the corresponding SQL component is the required starting point to ensure architectural consistency.

What limitations exist when modifying the Cascades query optimizer?

Modifications to the Cascades query optimizer are constrained by the requirement to align with the Java reference implementation. Changes must pass dual architectural and code quality reviews, preventing deviations from core framework standards.