PV-SQL: Synergizing Database Probing and Rule-based Verification for Text-to-SQL Agents

Yuan Tian, Tianyi Zhang


Abstract
Text-to-SQL systems often struggle with deep contextual understanding, particularly for complex queries with subtle requirements.We present **PV-SQL**, an agentic framework that addresses these failures through two complementary components: **P**robe and **V**erify. The *Probe* component iteratively generates probing queries to retrieve concrete records from the database, resolving ambiguities in value formats, column semantics, and inter-table relationships to build richer contextual understanding. The *Verify* component employs a rule-based method to extract verifiable conditions and construct an executable checklist, enabling iterative SQL refinement that effectively reduces missing constraints. Experiments on the BIRD benchmarks show that PV-SQL outperforms the best text-to-SQL baseline by 5% in execution accuracy and 20.8% in valid efficiency score while consuming fewer tokens.
Anthology ID:
2026.findings-acl.1286
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:
25827–25845
Language:
URL:
https://preview.aclanthology.org/ingest-acl/2026.findings-acl.1286/
DOI:
Bibkey:
Cite (ACL):
Yuan Tian and Tianyi Zhang. 2026. PV-SQL: Synergizing Database Probing and Rule-based Verification for Text-to-SQL Agents. In Findings of the Association for Computational Linguistics: ACL 2026, pages 25827–25845, San Diego, California, United States. Association for Computational Linguistics.
Cite (Informal):
PV-SQL: Synergizing Database Probing and Rule-based Verification for Text-to-SQL Agents (Tian & Zhang, Findings 2026)
Copy Citation:
PDF:
https://preview.aclanthology.org/ingest-acl/2026.findings-acl.1286.pdf
Checklist:
 2026.findings-acl.1286.checklist.pdf