XGenerationLab_xiyan_mcp_server

XGenerationLab_xiyan_mcp_server

0
databases

XiYan MCP Server is a Model Context Protocol server designed to facilitate natural language database queries. It supports general LLMs and Text-to-SQL models, making it versatile for different use cases. The server can operate in a secure local mode and integrates easily with MySQL databases.

XiYan MCP Server

A Model Context Protocol (MCP) server enabling natural language queries to databases

Features

  • Fetch data using natural language with XiYanSQL.
  • Support for general LLMs like GPT and qwenmax, and Text-to-SQL SOTA model.
  • Offers pure local mode for high security.
  • Lists available MySQL tables and reads table contents.

Tool Preview

  • Convert natural language into SQL and retrieve data from databases.
  • Use mysql://{table_name} to obtain sample data from a table.

Installation

Installing from pip

  • Requires Python 3.11+.
  • Install via pip install xiyan-mcp-server.

Configuration

  • Requires a YAML config file for model and database settings.
  • Support for local and remote databases, currently only MySQL.

Launch

  • Compatible with multiple platforms: Claude Desktop, Cline, Goose, Cursor, and Witsy.

It Does Not Work

  • Contact via Ding Group or Weibo for support.