Summary of XiYan MCP Server README

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.