EUVIMEDEUVIMED entdecken
Crossref

SQL-Factory: A Multi-Agent Framework for High-Quality and Large-Scale SQL Generation

Jiahui Li, Tongwang Wu, Yuren Mao, Yunjun Gao, Yajie Feng, Huaizhong Liu

Proceedings of the VLDB Endowment · 01.11.2025 · 19 (3) · 292-305

DOI: 10.14778/3778092.3778093 ↗

Kurz gefasst

Fachartikel in der Zeitschrift Proceedings of the VLDB Endowment, online erschienen am 18.03.2026. Verfasst von Jiahui Li und 5 weiteren Autor:innen. Die Arbeit wurde bisher 3-mal zitiert (Crossref) und nennt 68 Literaturangaben.

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

High quality SQL corpus is essential for intelligent databases. For example, Text-to-SQL requires SQL queries and corresponding natural language questions as training samples. However, collecting such a query corpus remains challenging in practice due to the high cost of manual annotation, which highlights the importance of automatic SQL generation. Despite recent advances, existing generation methods still face limitations in achieving both diversity and cost-effectiveness. Besides, many methods also treat all tables equally, which overlooks schema complexity and leads to under-utilization of structurally rich tables. To address these issues, this paper proposes a multi-agent framework for high-quality and large-scale SQL generation, dubbed SQL-Factory. It decomposes the generation process into three collaborative teams: the Generation Team explores diverse query structures using a powerful language model, the Expansion Team scales promising patterns via a lightweight language model, and the Management Team adaptively schedules the workflow and evaluates the quality of synthesized queries. This modular framework ensures a balanced trade-off between diversity, scalability, and generation cost. We apply SQL-Factory to four widely used benchmarks and generate over 300,000 SQL queries with less than $200 API cost. Our generated queries achieve higher diversity compared to other methods, and extensive experiments demonstrate that the generated queries significantly improve model performance in various downstream tasks.

Zitieren

APA

Li, J., Wu, T., Mao, Y., Gao, Y., Feng, Y., & Liu, H. (2025). SQL-Factory: A Multi-Agent Framework for High-Quality and Large-Scale SQL Generation. Proceedings of the VLDB Endowment, 19(3), 292-305. https://doi.org/10.14778/3778092.3778093

Vancouver

Li J, Wu T, Mao Y, Gao Y, Feng Y, Liu H. SQL-Factory: A Multi-Agent Framework for High-Quality and Large-Scale SQL Generation. Proceedings of the VLDB Endowment. 2025;19(3):292-305. doi:10.14778/3778092.3778093

BibTeX
@article{Li2025,
  author = {Li, Jiahui and Wu, Tongwang and Mao, Yuren and Gao, Yunjun and Feng, Yajie and Liu, Huaizhong},
  title = {SQL-Factory: A Multi-Agent Framework for High-Quality and Large-Scale SQL Generation},
  journal = {Proceedings of the VLDB Endowment},
  year = {2025},
  volume = {19},
  number = {3},
  pages = {292--305},
  doi = {10.14778/3778092.3778093}
}
Kostenlos starten →