Awesome MCPDatabases

XGenerationLab/xiyan_mcp_server

⭐ 240 Python added to this list on 2025-04-09 repository created 2025-03-13

The XiYan MCP Server is a Model Context Protocol (MCP) server designed to enable natural language queries to databases by converting text inputs into SQL queries. It leverages state-of-the-art models such as XiYan-SQL, which is recognized as a leading text-to-SQL model on open benchmarks. The server supports both remote and local deployment modes, allowing users to choose between convenience and security. In remote mode, the server accesses the XiYanSQL-QwenCoder-32B model via an API key from a service provider, while the local mode offers a high-security option without requiring an API key. The server supports popular databases like MySQL and PostgreSQL, providing features such as listing available tables and reading table contents. It offers a natural language interface for data retrieval, converting user queries into SQL commands that are executed on the connected database. The architecture supports integration into projects either remotely or locally, catering to different deployment needs. XiYan MCP Server is highly configurable through a YAML configuration file, allowing users to specify transport protocols (stdio or SSE), model details (including model name, API key, and URL), and database connection parameters. It supports various large language models (LLMs) including general-purpose models like GPT and qwenmax, as well as specialized text-to-SQL models from Modelscope and Dashscope. The server also supports local LLMs for enhanced security. The project includes comprehensive documentation, installation instructions via pip or from source, and examples of best practices. It has been evaluated on the MCPBench benchmark, demonstrating superior performance compared to other MCP servers for MySQL and PostgreSQL. The server is open-source under the Apache 2.0 license and integrates with platforms like HuggingFace and ModelScope for model hosting. Overall, XiYan MCP Server provides a powerful and flexible solution for enabling natural language database queries using advanced AI models, making database interaction more accessible and efficient for users.

https://github.com/XGenerationLab/xiyan_mcp_server

apache-2.0apache-2.0-licenseapi-keydashscopedata-retrievaldatabasedatabase-queryingdatabasesgptlarge-language-modelsllmlocal-deploymentlocal-modemcpmcp-servermcpbenchmodel-context-protocolmodelscopemysqlnatural-language-queriesopen-sourcepostgresqlpython-3.11+qwenmaxremote-deploymentremote-modesql-conversionsql-generationtext-to-sqlxiyan-sqlyaml-configuration

Also in Databases

dolthub/dolt

Dolt is a SQL database with Git-like version control capabilities, enabling users to manage, version, and collaborate on data and schemas as easily as code in Git repositories.

t8y2/dbx

DBX is a lightweight, cross-platform database client supporting over 70 databases, featuring a built-in AI assistant, MCP Server, and available as desktop, Docker, or CLI.

Canner/WrenAI

Open-source generative BI engine that exposes governed text-to-SQL, a semantic layer and dashboard generation to AI agents through an MCP server and CLI across more than twenty data sources.

googleapis/mcp-toolbox

MCP Toolbox for Databases is an open-source Model Context Protocol (MCP) server that connects AI agents, IDEs, and applications directly to enterprise databases, offering both pre-built and custom ...

makenotion/notion-mcp-server

The Notion MCP Server is an official MCP server implementation that enables secure, programmatic interaction with Notion content through MCP commands, optimized for AI agents and supporting multiple deployment options.

bytebase/dbhub

DBHub is a universal database gateway implementing the Model Context Protocol (MCP) server interface, enabling MCP clients to connect to and explore multiple database systems including MySQL, PostgreSQL, Oracle, SQL Server, MariaDB, and SQLite.

crystaldba/postgres-mcp

Postgres MCP Pro is an open-source Model Context Protocol server for PostgreSQL that provides advanced database health monitoring, index tuning, query plan analysis, and safe SQL execution to support AI agents and developers throughout the application lifecycle.

supabase-community/supabase-mcp

Supabase MCP Server connects Supabase projects to AI assistants using the Model Context Protocol, enabling LLMs to manage and query Supabase resources.