SQLAgent: Learning to Explore Before Generating as a Data Engineer
Wenjia Jiang, Yiwei Wang, Boyan Han, Joey Tianyi Zhou, Chi Zhang
Abstract
Large Language Models have recently shown impressive capabilities in reasoning and code generation, making them promising tools for natural language interfaces to relational databases. However, existing approaches often fail to generalize in complex, real-world settings due to the highly database-specific nature of SQL reasoning, which requires deep familiarity with unique schemas, ambiguous semantics, and intricate join paths. To address this challenge, we introduce a novel two-stage LLM-based framework that decouples knowledge acquisition from query generation. In the Exploration Stage, the system autonomously constructs a database-specific knowledge base by navigating the schema with a Monte Carlo Tree Search–inspired strategy, generating triplets of schema fragments, executable queries, and natural language descriptions as usage examples. In the Deployment Stage, a dual-agent system leverages the collected knowledge as in-context examples to iteratively retrieve relevant information and generate accurate SQL queries in response to user questions. This design enables the agent to proactively familiarize itself with unseen databases and handle complex, multi-step reasoning. Extensive experiments on large-scale benchmarks demonstrate that our approach significantly improves accuracy over strong baselines, highlighting its effectiveness and generalizability.- Anthology ID:
- 2026.findings-acl.1959
- Volume:
- Findings of the Association for Computational Linguistics: ACL 2026
- Month:
- July
- Year:
- 2026
- Address:
- San Diego, California, United States
- Editors:
- Maria Liakata, Viviane P. Moreira, Jiajun Zhang, David Jurgens
- Venue:
- Findings
- SIG:
- Publisher:
- Association for Computational Linguistics
- Note:
- Pages:
- 39311–39331
- Language:
- URL:
- https://preview.aclanthology.org/ingest-acl/2026.findings-acl.1959/
- DOI:
- Cite (ACL):
- Wenjia Jiang, Yiwei Wang, Boyan Han, Joey Tianyi Zhou, and Chi Zhang. 2026. SQLAgent: Learning to Explore Before Generating as a Data Engineer. In Findings of the Association for Computational Linguistics: ACL 2026, pages 39311–39331, San Diego, California, United States. Association for Computational Linguistics.
- Cite (Informal):
- SQLAgent: Learning to Explore Before Generating as a Data Engineer (Jiang et al., Findings 2026)
- PDF:
- https://preview.aclanthology.org/ingest-acl/2026.findings-acl.1959.pdf