XiYan MCP Server

by XGenerationLab

Data/Databases text-to-sql natural language query database XiYan-SQL

XiYan MCP Server is a Model Context Protocol (MCP) server that enables natural language queries to databases. It is powered by XiYan-SQL, a state-of-the-art text-to-SQL model.

View on GitHub

Last updated: N/A

What is XiYan MCP Server?

XiYan MCP Server provides a natural language interface for retrieving data from a database. It converts natural language into SQL using a built-in model and queries the database to return the results.

How to use XiYan MCP Server?

Install the server using pip or Smithery.ai. 2. Configure the server by creating a YML config file with LLM and database settings. 3. Launch the server and integrate it with tools like Claude Desktop, Cline, Goose, or Cursor by providing the appropriate command and environment variables.

Key features of XiYan MCP Server

Fetch data by natural language through XiYanSQL
Support general LLMs (GPT, qwenmax) and Text-to-SQL SOTA model
Support pure local mode (high security)
List available MySQL tables as resources
Read table contents

Use cases of XiYan MCP Server

Querying databases using natural language
Integrating natural language database queries into applications
Providing a user-friendly interface for database interaction
Securely querying databases in local mode

FAQ from XiYan MCP Server

What is the recommended model to use?

XiYanSQL-qwencoder-32B is the recommended SOTA model for text-to-SQL.

How do I get the API key for the Dashscope version?

Send an email to [email protected] with your name, email, and organization to request a key.

What are the requirements for running the local model?

A PC/Mac with at least 16GB RAM and 6GB disk space is required.

What databases are supported?

Currently, only MySQL is supported, but more dialects will be supported soon.

Where can I find help if the server doesn't work?

Contact the developers through the Ding Group or follow them on Weibo.