收藏切换
SCoT-SQL: A Chain-of-Thought Guided Approach for Text-to-SQL Data Synthesis
收藏切换
Qianhao Ren1, Ruiheng Liu1, 2, Yu Zhang1, *
Journal of Computer Research and Development | 2026, 63(11) : 2939 - 2951
Less
收藏切换
Journal of Computer Research and Development | 2026, 63(11): 2939-2951
• Artificial Intelligence •
SCoT-SQL: A Chain-of-Thought Guided Approach for Text-to-SQL Data Synthesis
Full
Qianhao Ren1, Ruiheng Liu1, 2, Yu Zhang1, *
Affiliations
  • 1Research Center for Social Computing and Interactive Robotics, Harbin Institute of Technology, Harbin 150001
  • 2School of Intelligent and Control Engineering, Rocket Force University of Engineering, Xi’an 710025
  • born in 2003. Master candidate. His main research interests include natural language processing and natural language interface to databases

    born in 1997. PhD. His main research interests include natural language processing and semantic parsing

    born in 1972. PhD, professor. His main research interests include natural language processing, question answering systems, and information retrieval

About Author:

born in 2003. Master candidate. His main research interests include natural language processing and natural language interface to databases

born in 1997. PhD. His main research interests include natural language processing and semantic parsing

born in 1972. PhD, professor. His main research interests include natural language processing, question answering systems, and information retrieval

Published: 2026-11-01 doi: 10.7544/issn1000-1239.202550826
Outline
收藏切换

Traditional Text-to-SQL tasks typically require large scale annotated data for model training, which incurs significant time and labor costs. Consequently, data scarcity remains a critical bottleneck, particularly in domain specific applications. While data augmentation based on large language model (LLM) has emerged as a promising solution to this issue, most existing methods heavily rely on the distribution of original datasets and often generate synthetic data that lack reliability and interpretability. Addressing these challenges, we propose SCoT-SQL, a novel chain-of-thought guided data synthesis framework. This method effectively integrates natural language instructions with symbolic knowledge, specifically detailed database schema and table content, to guide LLM, thereby significantly reducing semantic errors during the generation process. To guarantee the high quality of synthetic data, SCoT-SQL incorporates a rigorous filtering mechanism that leverages both model self consistency voting and verification based on execution. Additionally, the framework employs a self feedback mechanism driven by chain-of-thought reasoning to calibrate synthetic data. This process not only rectifies logical inconsistencies in SQL queries but also generates explicit step by step reasoning trajectories, enhancing the interpretability of the dataset. Comprehensive experiments on the KaggleDBQA and ScienceBenchmark datasets demonstrate the efficacy of the proposed method. SCoT-SQL achieves execution accuracy improvements of 6.5% and 3% respectively, significantly outperforming previous state of the art data synthesis baselines and proving its effectiveness in low resource and complex scenarios.

natural language interface of database  /  data synthesis  /  data augmentation  /  chain of thought  /  self-correction
任千昊, 刘睿珩, 张宇. SCoT-SQL:一种基于思维链引导的Text-to-SQL数据合成方法. 计算机研究与发展, 2026 , 63 (11) : 2939 -2951 . DOI: 10.7544/issn1000-1239.202550826
Qianhao Ren, Ruiheng Liu, Yu Zhang. SCoT-SQL: A Chain-of-Thought Guided Approach for Text-to-SQL Data Synthesis[J]. Journal of Computer Research and Development, 2026 , 63 (11) : 2939 -2951 . DOI: 10.7544/issn1000-1239.202550826
Year 2026 volume 63 Issue 11
85
41
Cite this Article
BibTeX
Article Info
doi: 10.7544/issn1000-1239.202550826
  • Receive Date:2025-11-18
  • Online Date:2026-11-17
  • Published:2026-11-01
Article Data
Affiliations
History
  • Received:2025-11-18
  • Revised:2026-05-29
  • Accepted:2026-06-22
Affiliations
    1Research Center for Social Computing and Interactive Robotics, Harbin Institute of Technology, Harbin 150001
    2School of Intelligent and Control Engineering, Rocket Force University of Engineering, Xi’an 710025
References
Share
https://castjournals.cast.org.cn/joweb/jsjyjyfz/EN/10.7544/issn1000-1239.202550826
Share to
QR

Scan QR to access full text

Cite this article
BibTeX
Citations
表12种不同金属材料的力学参数
科
Family
属数
Number of
genus
种数
Number of
species
占总种数比例
Percentage of
total species (%)
属
Genus
种数
Number of
species
占总种数比例
Percentage of total
species (%)
鹅膏菌科Amanitaceae 2 11 5.26 鹅膏菌属 Amanita 10 4.78
小菇科 Mycenaceae 2 12 5.74 丝盖伞属 Inocybe 5 2.39
多孔菌科 Polyporaceae 8 14 6.70 蜡蘑属 Laccaria 5 2.39
红菇科 Russulaceae 3 23 11.00 小皮伞属 Marasmius 6 2.87
小菇属 Mycena 11 5.26
光柄菇属 Pluteus 5 2.39
红菇属 Russula 17 8.13
栓菌属 Trametes 5 2.39
关闭全屏
  • BibTeX
  • EndNote
  • RefWorks
  • TxT