XiYan

关于

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.

主要功能

• Fetches data from databases using natural language queries.
• Supports general LLMs and specialized Text-to-SQL models.
• Lists available tables as resources and reads table contents.
• Offers a local mode for enhanced security.
• Supports MySQL and PostgreSQL databases.

使用案例

• Providing a user-friendly interface for data retrieval without SQL knowledge.
• Building local data assistants that can respond to natural language queries.
• Integrating natural language querying into existing applications.