XiYan
CreatedXGenerationLab
Enables natural language queries to retrieve data from databases by converting them into SQL.
About
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
- 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.
Use Cases
- 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.