Xiyan Mcp Server
Overview
What is Xiyan MCP Server?
Xiyan MCP Server is a Model Context Protocol server that allows users to perform natural language queries on databases, powered by XiYan-SQL, a state-of-the-art text-to-SQL model.
How to use Xiyan MCP Server?
To use the Xiyan MCP Server, install it via pip, configure a YAML file with your database connection details, and run the server using Python. You can then send natural language queries to retrieve data from your database.
Key features of Xiyan MCP Server?
- 🌐 Natural language interface for database queries using XiYan-SQL.
- 🤖 Support for various LLMs and text-to-SQL models.
- 💻 Option to run in a secure local mode without API keys.
- 📝 Compatibility with MySQL and PostgreSQL databases.
- 🔧 Ability to list available tables and read their contents.
Use cases of Xiyan MCP Server?
- Enabling non-technical users to query databases using natural language.
- Integrating with applications that require dynamic data retrieval.
- Assisting data analysts in quickly accessing information without writing SQL queries.
FAQ from Xiyan MCP Server?
- Can I use Xiyan MCP Server with any database?
Currently, it supports MySQL and PostgreSQL, with plans for more in the future.
- Is there a local mode for enhanced security?
Yes, Xiyan MCP Server can be run in a local mode that does not require an API key.
- How do I install Xiyan MCP Server?
You can install it using pip with the command
pip install xiyan-mcp-server.
Server Config
{
"mcpServers": {
"xiyan-mcp-server": {
"command": "python",
"args": [
"-m",
"xiyan_mcp_server"
],
"env": {
"YML": "PATH/TO/YML"
}
}
}
}Project Info
Created At
a year agoUpdated At
a year agoAuthor Name
XGenerationLabStar
-Language
-License
-Category
research-and-data
Recommend Servers
View AllMcp Server Chatsum
@chatmcp
summarize chat message
typescript
a year ago
Playwright Mcp
@microsoft
Playwright MCP server
TypeScript
10 months ago
Tavily Mcp
@tavily-ai
JavaScript
a year ago