ACTS-SQL: Agentic and Critic-Oriented Tree-Structured SQL Correctness with Large Language Models
On the map: LLM agents and tool use → Web, search, and research agents
Abstract (arXiv)
Large Language Models (LLMs) have been increasingly adopted in Text-to-SQL systems, yet SQL errors remain a major obstacle in real-world Text-to-SQL inference pipelines. Existing SQL correction approaches either rely on large-scale, high-quality training data with substantial overhead, or adopt single-path agentic workflows that are brittle to early mistakes and prone to error propagation. To develop a practical SQL correctness system for industrial scenarios, we present a training-free framework that formulates SQL correction as a plan-guided, tree-structured debugging process. By maintaining multiple correction strategies and enabling backtracking, the framework mitigates error accumulation during iterative refinement. We further integrate execution-based verification and clause-level diagnostic tools to support strategy pruning and precise error localization. We evaluate the system on the BIRD-Critic benchmark and observe consistent accuracy gains over strong LLM backbones and representative agent-based baselines, achieving a 9.42% improvement over the previous state-of-the-art method. The framework is also deployed in the Torch Log Service (TLS) of Volcano Engine to support an online Text-to-TLS API. In production, it improves execution accuracy from 36.77% to 53.61% on real user queries with a representative strong LLM backbone (GPT-5). These results demonstrate the effectiveness and stability of our approach in real-world deployments.
Key facts. No citing papers in the map yet (data through 7 Oct 2026). Placed in Web, search, and research agents, one of 16 directions in LLM agents and tool use. Builds on 21 of its 46 references that are in the map. First posted on arXiv 15 Aug 2026.
Builds on
21 of 46 references.
Closest ancestors · 3
Same direction, newest first
- 2025A Survey of Data Agents: Emerging Paradigm or Overstated Hype?27 Oct
- 2025Rethinking Agentic Workflows: Evaluating Inference-Based Test-Time Scaling Strategies in Text2SQL Tasks13 Oct
- 2024MAG-SQL: Multi-Agent Generative Approach with Soft Schema Linking and Iterative Sub-SQL Refinement for Text-to-SQL15 Aug
Other references · 18
- 2024DeepSeek-Coder: When the Large Language Model Meets Programming -- The Rise of Code Intelligencecited by 1,154
- 2024CodeAgent: Enhancing Code Generation with Tool-Integrated Agent Systems for Real-World Repo-level Coding Challengescited by 278
- 2024RepairAgent: An Autonomous, LLM-Based Agent for Program Repaircited by 225
- 2024Spider 2.0: Evaluating Language Models on Real-World Enterprise Text-to-SQL Workflowscited by 223
- 2024CodeS: Towards Building Open-source Language Models for Text-to-SQLcited by 183
- 2025XiYan-SQL: A Novel Multi-Generator Framework For Text-to-SQLcited by 40
- 2024CYCLE: Learning to Self-Refine the Code Generationcited by 39
- 2024LeDex: Training LLMs to Better Self-Debug and Explain Codecited by 39
- 2025CodeCoR: An LLM-Based Self-Reflective Multi-Agent Framework for Code Generationcited by 33
- 2025NL2SQL-BUGs: A Benchmark for Detecting Semantic Errors in NL2SQL Translationcited by 31
- 2025QualityFlow: An Agentic Workflow for Program Synthesis Controlled by LLM Quality Checkscited by 22
- 2025CSC-SQL: Corrective Self-Consistency in Text-to-SQL via Reinforcement Learningcited by 15
6 more
- 2024CoE-SQL: In-Context Learning for Multi-Turn Text-to-SQL with Chain-of-Editionscited by 13
- 2025SQLens: An End-to-End Framework for Error Detection and Correction in Text-to-SQLcited by 10
- 2024E2ETune: End-to-End Knob Tuning via Fine-tuned Generative Language Modelcited by 9
- 2025AdaCoder: An Adaptive Planning and Multi-Agent Framework for Function-Level Code Generationcited by 8
- 2024DAC: Decomposed Automation Correction for Text-to-SQLcited by 6
- 2020SQLCheck: Automated Detection and Diagnosis of SQL Anti-Patternscited by 1
Built on by
Not cited yet.
Similar, not cited
Close in wording, no citation either way
- 2025SQLCritic: Correcting Text-to-SQL Generation via Clause-wise Critic
- 2025SQL-of-Thought: Multi-agentic Text-to-SQL with Guided Error Correction
- 2024Tool-Assisted Agent on SQL Inspection and Refinement in Real-World Scenarios
- 2025SHARE: An SLM-based Hierarchical Action CorREction Assistant for Text-to-SQL
- 2024SQLFixAgent: Towards Semantic-Accurate Text-to-SQL Parsing via Consistency-Enhanced Multi-Agent Collaboration
- 2025BAPPA: Benchmarking Agents, Plans, and Pipelines for Automated Text-to-SQL Generation
- 2025ReFoRCE: A Text-to-SQL Agent with Self-Refinement, Consensus Enforcement, and Column Exploration
- 2025SWE-SQL: Illuminating LLM Pathways to Solve User SQL Issues in Real-World Applications