Abacus-SQL: A Text-to-SQL System Empowering Cross-Domain and Open-Domain Database Retrieval

The existing text-to-SQL systems have made significant progress in SQL query generation, but they still face numerous challenges. Existing systems often lack retrieval capabilities for open-domain databases, requiring users to manually filter relevant databases. Additionally, their cross-domain transferability is limited, making it challenging to accommodate diverse query requirements. To address these issues, we propose Abacus-SQL. Abacus-SQL utilizes database retrieval technology to accurately locate the required databases in an open-domain database environment. It also enhances the system cross-domain transfer ability through data augmentation methods. Moreover, Abacus-SQL employs Pre-SQL and Self-debug methods, thereby enhancing the accuracy of SQL queries. Experimental results demonstrate that Abacus-SQL performs excellently in multi-turn text-to-SQL tasks, effectively validating the approach's effectiveness. Abacus-SQL is publicly accessible atthis https URL.

@article{xu2025_2504.09824,
  title={ Abacus-SQL: A Text-to-SQL System Empowering Cross-Domain and Open-Domain Database Retrieval },
  author={ Keyan Xu and Dingzirui Wang and Xuanliang Zhang and Qingfu Zhu and Wanxiang Che },
  journal={arXiv preprint arXiv:2504.09824},
  year={ 2025 }
}