NL2SQL Core Engine — 6 Pillars

What problem does it solve?

This Skill helps you keep an NL2SQL multi-agent pipeline accurate and safe as your database schema, prompts, and LLM models evolve.

Core Features & Use Cases

• Schema Linking & Value Profiling: Maps user intent to the correct tables/columns and injects value profiles so generated SQL uses exact enum values.
• Ambiguity Detection: Tunes the Gatekeeper rules to correctly classify valid analytical questions vs unsafe/invalid requests.
• Generation Trace: Extends intermediate outputs so you can understand why the pipeline chose a specific query plan and SQL.
• Retry & Repair: Recovers from SQL dialect issues using a centralized repair/patch mechanism.
• Evaluation Suite (23-case): Runs an automated regression test set and produces a test_report.json to prevent prompt/schema regressions.

Quick Start

Use the NL2SQL Core Engine — 6 Pillars Skill when you change schema, prompts, synonyms, or the LLM, then run the evaluation suite to confirm 23/23 PASS and catch regressions early.