广告合作
MCP.so
登录

XiYan MCP Server

@XGenerationLab

代码仓库

基本信息

分类

其他

许可证

Apache-2.0

传输方式

stdio

作者

XGenerationLab

关于 XiYan MCP Server

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

#database#mcp#text-to-sql

XiYan MCP Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

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

XiYan MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is XiYan MCP Server?

A Model Context Protocol (MCP) server that enables natural language queries to databases. It is powered by XiYan-SQL, the state-of-the-art text-to-SQL system on open benchmarks, and is intended for developers and data analysts who want to query databases using natural language through MCP-compatible clients (e.g., Claude Desktop, Cursor).

How to use XiYan MCP Server?

Install the server with pip install xiyan-mcp-server, then provide a YAML configuration file specifying the LLM model, API key, database credentials, and transport protocol (stdio or sse). Launch the server with YML=path/to/yml python -m xiyan_mcp_server and connect it to a supported MCP client.

Key features of XiYan MCP Server

  • Query databases using natural language via XiYanSQL
  • Supports general LLMs (GPT, Qwen-max) and a SOTA text-to-SQL model
  • Runs in pure local mode for high security
  • Works with MySQL and PostgreSQL databases
  • Lists available tables and reads table contents as resources

Use cases of XiYan MCP Server

  • Build a local data assistant that answers questions from a database
  • Enable non-technical users to explore data via chat interfaces
  • Integrate natural-language database access into MCP-compatible IDEs or tools

常见问题

1

What databases does XiYan MCP Server support?

MySQL and PostgreSQL are currently supported. More dialects are planned.

2

Do I need an API key to use the server?

It depends on the model. General LLMs require an API key from the provider (e.g., OpenAI, Alibaba Cloud). The SOTA model can be used via Modelscope (requires a free API-inference key) or via Dashscope (key provided by email for trial). Local mode requires no API key.

3

Can I run the server entirely offline?

Yes. You can deploy the XiYanSQL-QwenCoder model locally and set the configuration to point to your local endpoint, achieving a fully local and high-security setup.

4

What transport protocols are supported?

The server supports both `stdio` (default) and `sse` transport protocols, making it compatible with a variety of MCP clients.

5

How do I get a trial key for the Dashscope‑hosted SOTA model?

Send an email to godot.lzl@alibaba-inc.com with your name, email, and organization to request a key. The key expires after one month or 200 queries.

评论

其他 分类下的更多 MCP 服务器

Blender

ahujasid

Open-source MCP to use Blender with any LLM

23.6K

Volley.sh

Volley

A good sequence diagram can solve almost any communication problem in engineering. Volley lets your agent write them as plain text, with the real request and response payloads on every arrow. It checks its own syntax wi

P

PickFu MCP

PickFu MCP is a Model Context Protocol (MCP) server that connects AI assistants, developers, marketers, product managers, and AI agents to PickFu's consumer research platform. It enables users to create surveys, conduct

The Living Bread

The Living Bread

A free remote MCP server for The Living Bread. Bible passages read word for word from a stored public domain text with an evidence label, keyword search and cross references, real churches, gatherings and prayer groups w

Soar Flight Booking MCP

Soar Flight Booking MCP is a remote MCP server available at https://mcp.soar.flights.

广告合作