xiyan_mcp_server

xiyan_mcp_server

138
databases

The XiYan MCP Server provides an interface that enables natural language queries to databases through its powerful Model Context Protocol. It supports various large language models and ensures high security with options for local deployment. The project emphasizes ease of integration and superior performance benchmarks.

XiYan MCP Server

Features

  • Retrieve data using natural language through XiYanSQL.
  • Support for general LLM models and Text-to-SQL SOTA model.
  • Operate in a highly secure, pure local mode.
  • Support for MySQL and PostgreSQL databases.
  • Ability to list available tables and read their contents.

Preview

Architecture

Two integration modes:

  • Remote: Requires API key to access xiyanSQL-qwencoder-32B model.
  • Local: More secure, no API key required.

Evaluation on MCPBench

XiYan MCP server outperforms MySQL and PostgreSQL MCP servers by 2-22 percentage points on the MCPBench benchmark.

Installation

  • Requires Python 3.11+
  • Install via pip: use specified GitHub repository or Smithery.ai for development version.

Configuration

  • Requires YAML config file for server and database settings.
  • Supports MySQL and PostgreSQL databases.

Launch

  • Server launch options available for both sse and stdio transport protocols.
  • Configurations available for popular clients like Claude Desktop, Cline, Goose, Cursor, and Witsy.

Support

Contact via Ding Group or Weibo for support.