Supports deployment as a Docker container, making it easy to run the MCP server in containerized environments with proper isolation and dependency management.
Enables configuration through environment variables stored in .env files, allowing users to securely store database connection details and other configuration options.
Provides database interaction capabilities through MySQL, enabling SQL query execution, table creation, and database schema exploration with tools for reading data, writing data, creating tables, listing tables, and describing table schemas.
Leverages SQLAlchemy as the database abstraction layer for connecting to and interacting with MySQL databases, handling database connections and query execution.
项目结构
本项目包含三个主要文件夹,分别实现了不同功能:
- doc: MCP (Model Context Protocol) 的详细解读文档和说明
- mysql: 使用 stdio 模式实现的 MySQL MCP 服务
- weather: 使用 HTTP SSE 模式实现的天气 MCP 服务示例
MCP Inspector 界面展示
This server cannot be installed
A Model Context Protocol server that enables AI models to interact with MySQL databases through natural language, supporting SQL queries, table creation, and schema exploration.
Related MCP Servers
- AsecurityAlicenseAqualityA Model Context Protocol server that enables AI models to interact with MySQL databases, providing tools for querying, executing statements, listing tables, and describing table structures.Last updated -5965MIT License
- AsecurityFlicenseAqualityA Model Context Protocol server that enables AI models to interact with MySQL databases through a standardized interface, providing tools for querying, executing commands, and managing database schemas.Last updated -7JavaScript
- AsecurityAlicenseAqualityA Model Context Protocol server that enables AI models to interact with both MySQL and MongoDB databases through a standardized interface, supporting comprehensive database operations including queries, schema management, and CRUD operations.Last updated -146JavaScriptMIT License
- AsecurityFlicenseAqualityA Model Context Protocol server that allows AI agents to execute SQL queries against a MySQL database, supporting operations like reading data, creating tables, inserting, updating, and deleting records.Last updated -68346JavaScript