Does XiYan offer a secure, local option?

Yes! XiYan offers a local mode, ensuring enhanced security by processing queries without relying on external API calls.

XiYan is a tool that converts natural language queries into SQL, allowing you to easily retrieve data from databases without writing complex SQL code.

Can XiYan use general LLMs?

Yes, XiYan can use general LLMs like GPT, but also supports specialized Text-to-SQL models for optimal performance.

Which databases does XiYan support?

XiYan currently supports MySQL and PostgreSQL databases. More database integrations are planned for the future.

How do I install XiYan?

You can install XiYan using pip: `pip install xiyan-mcp-server`. Configuration via a YAML file is required after installation.

XiYan

Name: XiYan
Author: XGenerationLab

byXGenerationLab

•

232

•

Data Science & ML

API Development

Database Management

Enables natural language queries to retrieve data from databases by converting them into SQL.

The XiYan MCP Server acts as a bridge between natural language and structured databases. It allows users to query databases using natural language, which is then translated into SQL queries using a text-to-SQL model. The server supports various LLMs, including general models like GPT and Qwen, as well as specialized text-to-SQL models. It offers both remote and local modes, catering to different security and performance needs, and supports MySQL and PostgreSQL databases. The tool provides a natural language interface, enabling users to easily retrieve data without needing to write SQL code manually.

Key Features

01Fetches data from databases using natural language queries.

02Supports general LLMs and specialized Text-to-SQL models.

03Lists available tables as resources and reads table contents.

04Offers a local mode for enhanced security.

05Supports MySQL and PostgreSQL databases.

Use Cases

01Providing a user-friendly interface for data retrieval without SQL knowledge.

02Building local data assistants that can respond to natural language queries.

03Integrating natural language querying into existing applications.