XiYan MCP Server
A Model Context Protocol (MCP) server that enables natural language queries to databases
powered by XiYan-SQL, SOTA of text-to-sql on open benchmarks
💻 XiYan-mcp-server |
🌐 XiYan-SQL |
📖 Arxiv |
🏆 XiYanSQL Model |
📄 PapersWithCode
🤗 HuggingFace |
🤖 ModelScope |
🌕 析言GBI
English | 中文 | 日本語
Ding Group钉钉群|
Follow me on Weibo
Table of Contents
- Features
- Preview
- Architecture
- Best Practice
- Tools Preview
- Installation
- Installing from pip
- Installing from Smithery.ai
- Configuration
- LLM Configuration
- General LLMs
- Text-to-SQL SOTA model
- Local Model
- Database Configuration
- MySQL
- PostgreSQL
- LLM Configuration
- Launch
- Claude Desktop
- Cline
- Goose
- Cursor
- It Does Not Work
- Citation
Features
- 🌐 Fetch data by natural language through XiYanSQL
- 🤖 Support general LLMs (GPT,qwenmax), Text-to-SQL SOTA model
- 💻 Support pure local mode (high security!)
- 📝 Support MySQL and PostgreSQL.
- 🖱️ List available tables as resources
- 🔧 Read table contents
Preview
Architecture
There are two ways to integrate this server in your project, as shown below: The left is remote mode, which is the default mode. It requires an API key to access the xiyanSQL-qwencoder-32B model from service provider (see Configuration). Another mode is local mode, which is more secure. It does not require the API key.







