Xiyan Mcp Server

Created By

XGenerationLab9 months ago

Overview

What is Xiyan MCP Server?

Xiyan MCP Server is a Model Context Protocol server that allows users to perform natural language queries on databases, powered by XiYan-SQL, a state-of-the-art text-to-SQL model.

How to use Xiyan MCP Server?

To use the Xiyan MCP Server, install it via pip, configure a YAML file with your database connection details, and run the server using Python. You can then send natural language queries to retrieve data from your database.

Key features of Xiyan MCP Server?

🌐 Natural language interface for database queries using XiYan-SQL.
🤖 Support for various LLMs and text-to-SQL models.
💻 Option to run in a secure local mode without API keys.
📝 Compatibility with MySQL and PostgreSQL databases.
🔧 Ability to list available tables and read their contents.

Use cases of Xiyan MCP Server?

Enabling non-technical users to query databases using natural language.
Integrating with applications that require dynamic data retrieval.
Assisting data analysts in quickly accessing information without writing SQL queries.

FAQ from Xiyan MCP Server?

Can I use Xiyan MCP Server with any database?

Currently, it supports MySQL and PostgreSQL, with plans for more in the future.

Is there a local mode for enhanced security?

Yes, Xiyan MCP Server can be run in a local mode that does not require an API key.

How do I install Xiyan MCP Server?

You can install it using pip with the command pip install xiyan-mcp-server.

Server Config

{
  "mcpServers": {
    "xiyan-mcp-server": {
      "command": "python",
      "args": [
        "-m",
        "xiyan_mcp_server"
      ],
      "env": {
        "YML": "PATH/TO/YML"
      }
    }
  }
}

Recommend Servers

TraeBuild with Free GPT-4.1 & Claude 3.7. Fully MCP-Ready.

Visual Studio Code - Open Source ("Code - OSS")Visual Studio Code

MCP AdvisorMCP Advisor & Installation - Use the right MCP server for your needs

AiimagemultistyleA Model Context Protocol (MCP) server for image generation and manipulation using fal.ai's Stable Diffusion model.

TimeA Model Context Protocol server that provides time and timezone conversion capabilities. This server enables LLMs to get current time information and perform timezone conversions using IANA timezone names, with automatic system timezone detection.

ChatWiseThe second fastest AI chatbot™

Zhipu Web SearchZhipu Web Search MCP Server is a search engine specifically designed for large models. It integrates four search engines, allowing users to flexibly compare and switch between them. Building upon the web crawling and ranking capabilities of traditional search engines, it enhances intent recognition capabilities, returning results more suitable for large model processing (such as webpage titles, URLs, summaries, site names, site icons, etc.). This helps AI applications achieve "dynamic knowledge acquisition" and "precise scenario adaptation" capabilities.

WindsurfThe new purpose-built IDE to harness magic

EdgeOne Pages MCPAn MCP service designed for deploying HTML content to EdgeOne Pages and obtaining an accessible public URL.

BlenderBlenderMCP connects Blender to Claude AI through the Model Context Protocol (MCP), allowing Claude to directly interact with and control Blender. This integration enables prompt assisted 3D modeling, scene creation, and manipulation.

Baidu Map百度地图核心API现已全面兼容MCP协议，是国内首家兼容MCP协议的地图服务商。