AmbiSQL: Interactive Ambiguity Detection and Resolution for Text-to-SQL
Not on the map. Why?
Abstract (arXiv)
Text-to-SQL systems translate natural language questions into SQL queries, providing substantial value for non-expert users. While large language models (LLMs) show promising results for this task, they remain error-prone. Query ambiguity has been recognized as a major obstacle in LLM-based Text-to-SQL systems, leading to misinterpretation of user intent and inaccurate SQL generation. To this end, we present AmbiSQL, an interactive system that automatically detects query ambiguities and guides users through intuitive multiple-choice questions to clarify their intent. It introduces a fine-grained ambiguity taxonomy for identifying ambiguities arising from both database elements and LLM reasoning, and subsequently incorporates user feedback to rewrite ambiguous questions. In this demonstration, AmbiSQL is integrated with XiYan-SQL, our commercial Text-to-SQL backend. We provide 40 ambiguous queries collected from two real-world benchmarks that SIGMOD'26 attendees can use to explore how disambiguation improves SQL generation quality. Participants can also apply the system to their own databases and natural language questions. The codebase and demo video are available at: https://github.com/JustinzjDing/AmbiSQL and https://www.youtube.com/watch?v=rbB-0ZKwYkk.
Key facts. Cited by 11 papers in the map (data through 14 Oct 2026). Builds on 15 of its 26 references that are in the map. First posted on arXiv 21 Aug 2025.
Builds on
15 of 26 references.
References · 15
- 2018Spider: A Large-Scale Human-Labeled Dataset for Complex and Cross-Domain Semantic Parsing and Text-to-SQL Taskcited by 1,139
- 2023Can LLM Already Serve as A Database Interface? A BIg Bench for Large-Scale Database Grounded Text-to-SQLscited by 688
- 2023DIN-SQL: Decomposed In-Context Learning of Text-to-SQL with Self-Correctioncited by 477
- 2023MAC-SQL: A Multi-Agent Collaborative Framework for Text-to-SQLcited by 164
- 2024Aligning Language Models to Explicitly Handle Ambiguitycited by 56
- 2024AMBROSIA: A Benchmark for Parsing Ambiguous Questions into Database Queriescited by 35
- 2023Benchmarking and Improving Text-to-SQL Generation under Ambiguitycited by 34
- 2024Understanding the Effects of Noise in Text-to-SQL: An Examination of the BIRD-Bench Benchmarkcited by 34
- 2024Text2SQL is Not Enough: Unifying AI and Databases with TAGcited by 34
- 2023Evaluating Cross-Domain Text-to-SQL Models and Benchmarkscited by 32
- 2023Text-to-SQL Error Correction with Language Models of Codecited by 21
- 2025Reliable Text-to-SQL with Adaptive Abstentioncited by 20
3 more
- 2024PRACTIQ: A Practical Conversational Text-to-SQL dataset with Ambiguous and Unanswerable Queriescited by 19
- 2025Disambiguate First, Parse Later: Generating Interpretations for Ambiguity Resolution in Semantic Parsingcited by 13
- 2025SQLens: An End-to-End Framework for Error Detection and Correction in Text-to-SQLcited by 12
Built on by
Citing papers per year: 2025: 2; 2026: 9.
11 papers.
- 2025BIRD-INTERACT: Re-imagining Text-to-SQL Evaluation for Large Language Models via Lens of Dynamic Interactionscited by 19
- 2026PV-SQL: Synergizing Database Probing and Rule-based Verification for Text-to-SQL Agentscited by 5
- 2025Reasoning about Intent for Ambiguous Requestscited by 4
- 2026CLARITY: A Framework and Benchmark for Conversational Language Ambiguity and Unanswerability in Interactive NL2SQL Systemscited by 2
- 2026Generative AI for Managerial Decision-Making under Ambiguity and Sycophancycited by 1
- 2026Boundary-Aware NL2SQL: Integrating Reliability through Hybrid Reward and Data Synthesiscited by 0
- 2026PleaSQLarify: Visual Pragmatic Repair for Natural Language Database Queryingcited by 0
- 2026Interactive Clarification for Cloud Infrastructure-as-Code Synthesiscited by 0
- 2026SOMA-SQL: Resolving Multi-Source Ambiguity in NL-to-SQL via Synthetic Log and Execution Probingcited by 0
- 2026Beyond Static Rules: Automated Discovery of Latent Vulnerabilities in Text-to-SQLcited by 0
- 2026Beyond Correctness: Resolving Underspecification in Agentic Text-to-SQLcited by 0
- 2026Beyond Correctness: Resolving Underspecification in Agentic Text-to-SQL2 Oct 2026
- 2026Beyond Static Rules: Automated Discovery of Latent Vulnerabilities in Text-to-SQL4 Jul 2026
- 2026SOMA-SQL: Resolving Multi-Source Ambiguity in NL-to-SQL via Synthetic Log and Execution Probing9 Jun 2026
- 2026CLARITY: A Framework and Benchmark for Conversational Language Ambiguity and Unanswerability in Interactive NL2SQL Systems24 Apr 2026
- 2026PV-SQL: Synergizing Database Probing and Rule-based Verification for Text-to-SQL Agents19 Apr 2026
- 2026Interactive Clarification for Cloud Infrastructure-as-Code Synthesis1 Apr 2026
- 2026Generative AI for Managerial Decision-Making under Ambiguity and Sycophancy4 Mar 2026
- 2026PleaSQLarify: Visual Pragmatic Repair for Natural Language Database Querying2 Mar 2026
- 2026Boundary-Aware NL2SQL: Integrating Reliability through Hybrid Reward and Data Synthesis15 Jan 2026
- 2025Reasoning about Intent for Ambiguous Requests13 Nov 2025
- 2025BIRD-INTERACT: Re-imagining Text-to-SQL Evaluation for Large Language Models via Lens of Dynamic Interactions6 Oct 2025
Similar, not cited
Close in wording, no citation either way
- 2024Evaluating and Enhancing LLMs for Multi-turn Text-to-SQL with Multiple Question Types
- 2024Lucy: Think and Reason to Solve Text-to-SQL
- 2025Weaver: Interweaving SQL and LLM for Table Reasoning
- 2026Diversity is Not Ambiguity: Toward Accurate and Efficient Ambiguity Detection for Open-Domain QA
- 2025LLMSQL: Upgrading WikiSQL for the LLM Era of Text-to-SQL
- 2025SLM-SQL: An Exploration of Small Language Models for Text-to-SQL
- 2024Multi-Turn Interactions for Text-to-SQL with Large Language Models
- 2026Integrating Reasoning and Generalization in Text-to-SQL via Self-Enhanced Fine-Tuning