XiYan MCP Server is a Model Context Protocol server enabling natural language queries to databases, powered by XiYan-SQL, a state-of-the-art text-to-SQL system on open benchmarks. It offers various resources, including
The XiYan MCP (Model Context Protocol) Server enables natural language queries to databases, powered by XiYan-SQL. It supports fetching data via natural language, general LLMs (GPT, QwenMax), and Text-to-SQL SOTA models, with pure local mode for enhanced security. It supports MySQL and PostgreSQL databases, listing available tables as resources and reading table contents.
Installation is available via pip (pip install xiyan-mcp-server) or Smithery.ai. Configuration requires a YAML file specifying the model (name, key, URL) and database connection details (host, port, user, password, database). It supports general LLMs like GPT-3.5 and Qwen-max, as well as the XiYanSQL-QwenCoder-32B SOTA model via Modelscope or Alibaba Cloud DashScope. Local model deployment is also supported.
The server can be launched with Claude Desktop, Cline, Goose, Cursor, and Witsy, requiring specific configurations. The get_data tool provides a natural language interface for database queries.
XGenerationLab/xiyan_mcp_server
March 13, 2025
March 28, 2025
Python