xiyan_mcp_server
If you are the rightful owner of xiyan_mcp_server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
XiYan MCP Server is a Model Context Protocol server that enables natural language queries to databases, powered by XiYan-SQL, a state-of-the-art text-to-SQL model.
The XiYan MCP Server is designed to facilitate natural language interactions with databases, leveraging the advanced capabilities of XiYan-SQL. This server supports both general language models and specialized text-to-SQL models, providing a robust solution for converting natural language queries into SQL commands. It offers high security with a pure local mode and supports popular databases like MySQL and PostgreSQL. The server can be configured to operate in either a remote or local mode, with the latter offering enhanced security by eliminating the need for an API key. The server's architecture allows for seamless integration into various projects, and it has been evaluated to perform exceptionally well on the MCPBench benchmark, outperforming other MCP servers by a significant margin.
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
Tools
get_data
Provides a natural language interface to retrieve data from a database
{dialect}://{table_name}
Get some sample data of the specified table in the database
{dialect}://
List the name of the current database
