XiYan MCP Server is an MCP server that enables natural language queries to databases, powered by XiYanSQL, a state-of-the-art text-to-SQL model. It supports fetching data from databases by translating natural language into SQL queries via a built-in NL-to-SQL engine and returning results. The server offers two integration modes: remote mode (default) which requires an API key to access the xiyanSQL-qwencoder-32B-2412 model (Modelscope) or equivalent services, and local mode which runs entirely on your own infrastructure for higher security. It supports multiple LLM options, including general LLMs (GPT, qwenmax), and a SOTA text-to-SQL model XiYanSQL-QwenCoder-32B-2412 accessible via Modelscope, or Alibaba Cloud DashScope; local models are also supported. Database support currently includes MySQL and PostgreSQL, with configuration for host, port, user, password, and database, and dialect handling (PostgreSQL uses dialect: "postgresql"). The YAML config can specify mcp transport (stdio or SSE), model details (name, key, url), and database connection info. Launching via SSE is demonstrated with a command like: YML=path/to/yml python -m xiyan_mcp_server, and stdio-based usage is supported for MCP-integrations. The server exposes tooling and resources such as get_data to NL-query a database and functions like dialect://{table_name} to preview data or list databases.