yooztech_mcp_mysql

Official

Enables secure read-only access to MySQL databases with automatic database inference from project co...

78 views

0 installs

Updated Jan 30, 2026

Not audited

Enables secure read-only access to MySQL databases with automatic database inference from project context. Provides safe querying capabilities with built-in security features like parameterized queries, whitelisting, and rate limiting.

打开 FastMCP 连接界面并点击 “Install Now”
在 FastMCP 的连接界面中使用已准备好的 “Install Now” 按钮开始添加环境变量（ENVs）。你将在该界面看到可以填写环境变量的表单字段 —— 接下来的值都要填写到那里。
准备 DB_HOST（数据库地址）
- 本地 MySQL：填写 127.0.0.1 或 localhost（如果 FastMCP 与数据库在同一台机器或通过本地端口转发）。
- 云数据库（RDS/Cloud SQL/Azure 等）：在云控制台找到实例的连接端点（endpoint / hostname），将该值填写为 DB_HOST（示例：mydb.xxxxxx.region.rds.amazonaws.com）。
- 容器/私有网络：填写容器或内网的 IP/主机名；若通过 SSH 隧道或端口映射，填写隧道本地监听地址（例如 127.0.0.1）和映射端口。
  将得到的主机名或 IP 填到 FastMCP 表单的 DB_HOST 字段。
确认 DB_PORT（数据库端口）
- 默认 MySQL 端口为 3306。若数据库使用自定义端口，请在云控制台/数据库配置中查到实际端口并填写到 DB_PORT 字段。
- 示例：DB_PORT = 3306
准备 DB_USER 和 DB_PASS（只读账号与密码）
- 推荐创建最小权限的只读账号。示例 SQL（在数据库管理员账户下运行）：
```
CREATE USER 'mcp_tool'@'10.0.%' IDENTIFIED BY '<your-strong-pass>';
GRANT SELECT ON *.* TO 'mcp_tool'@'10.0.%';
FLUSH PRIVILEGES;
```
  - 把 <your-strong-pass> 替换为强密码。若 FastMCP 从公网连接，改用合适的主机匹配（例如具体 IP 或 '%）并结合防火墙规则。
  - 如需更严格权限，按库/表粒度只授予 SELECT（例如 GRANT SELECT ON mydb.* TO ...）。
- 在 FastMCP 表单中将用户名填写到 DB_USER，密码填写到 DB_PASS。
生成与保存强密码
- 使用密码管理器生成长度足够且随机的密码（例如 16+ 字符，包含大小写/数字/符号）。
- 将密码安全地保存到你的密码管理器；不要在 README 或代码仓库中明文提交密码。
确保网络/防火墙允许连接
- 在数据库服务器或云控制台中，将运行 FastMCP 的主机或 IP 列入允许连接的白名单（安全组、防火墙规则）。
- 如果不便开放端口，考虑使用 SSH 隧道或将 FastMCP 部署在与数据库同一私有网络中。
本地测试连接（可选，但强烈建议）
- 在可以访问数据库的主机上用 mysql 客户端测试：
```
mysql -h <DB_HOST> -P <DB_PORT> -u <DB_USER> -p
```
  然后输入密码并执行 SELECT 1; 或 SHOW DATABASES; 验证只读账号可用且权限正确。
在 FastMCP 连接界面填写并保存 ENV 值
- 把上面准备好的值填写到对应字段：
  - DB_HOST: <你的数据库地址>
  - DB_PORT: <端口，通常 3306>
  - DB_USER: <只读用户名，如 mcp_tool>
  - DB_PASS: <对应密码>
- 点击保存/安装（Install Now 完成后按界面提示保存配置）。
在 FastMCP 中验证 MCP 功能（运行最小查询）
- 在 FastMCP/客户端里调用本工具的轻量操作（例如 list_databases() 或 infer_database()）确认能正常列出数据库或返回推断结果。若报网络/认证错误，回到上述步骤检查主机、端口、防火墙与用户名/密码。
安全建议与维护
- 使用最小权限原则：只授予必要的 SELECT 权限，按库或表细化。
- 定期轮换 DB_PASS 并更新 FastMCP 配置。
- 如果可能，限制 mcp_tool 的连接来源 IP，并启用连接监控与审计。

How to Install yooztech_mcp_mysql

Install yooztech_mcp_mysql MCP server with one click through FastMCP. Choose your preferred AI development tool below:

Claude Desktop

Click "Claude Desktop" in Quick Start

Cursor IDE

Click "Cursor IDE" in Quick Start

VS Code

Click "VS Code" in Quick Start

yooztech_mcp_mysql is an officially maintained MCP server, verified by the FastMCP team.

Alternatives to yooztech_mcp_mysql

Looking for similar MCP servers? Browse other servers in the same categories on FastMCP, or check out the similar servers listed above.

Database MCP servers →

Compare side by side

yooztech_mcp_mysql vs Read MySQL yooztech_mcp_mysql vs MySQL Query yooztech_mcp_mysql vs MySQL Database Explorer yooztech_mcp_mysql vs MySQL

Quick Start

View on GitHub

More for Database

View All →

Supabase MCP Server

Official

Remote

Connect Supabase projects directly with AI assistants using the Model Context Protocol (MCP). This server standardizes communication between Large Language Models and Supabase, enabling AI to manage tables, query data, and interact with project features like edge functions, storage, and branching. Customize access with read-only or project-scoped modes and select specific tool groups to fit your needs. Integrated tools cover account management, documentation search, database operations, debugging, and more, empowering AI to assist with development, monitoring, and deployment tasks in your Supabase environment efficiently and securely.

Database

1.9k

1-Click Ready

DBHub (Universal Database Gateway)

Official

Provides a universal database gateway for connecting to PostgreSQL, MySQL, SQLite, and DuckDB, enabling table browsing, schema inspection, and read-only SQL queries with built-in safety checks

Database Developer Tools

913

1-Click Ready

MySQL Database

Enables direct SQL query execution and database connections to MySQL databases through a simple interface that returns results in JSON format.

Database

836

Svelte

Official

Remote

Official Svelte documentation access and code analysis server that provides up-to-date reference material, playground link generation, and intelligent autofixer capabilities for detecting common patterns, anti-patterns, and migration opportunities in Svelte 5 and SvelteKit projects.

Database Developer Tools

824

1-Click Ready

PostgreSQL Multi-Schema

Provides read-only access to PostgreSQL databases with enhanced multi-schema support, enabling schema inspection, query execution, and isolation across multiple namespaces.

Database Analytics and Data

495

Odoo ERP

Connects to Odoo ERP systems via XML-RPC to enable searching, reading, creating, updating, and deleting business records with smart field optimization and comprehensive access controls for business process automation and data analysis workflows.

Productivity Database

790

AWS Athena

Integrates with AWS SDK to execute SQL queries against Athena databases, enabling large-scale data analysis and business intelligence for AWS data lakes.

Database Cloud Platforms

708

PostgreSQL

Provides a bridge to PostgreSQL databases for executing SQL queries, managing tables, and inspecting schemas with support for prepared statements and multiple parameter styles

Database

525

Neo4j

Integrates with Neo4j graph databases to enable natural language querying, node creation, and complex graph operations for knowledge exploration and data relationship modeling.

Database Analytics and Data

724

InfluxDB

Connects to InfluxDB time-series databases for querying measurements, writing data, and managing buckets through a bridge that exposes database functionality via tools and resources.

Database Analytics and Data

595

Similar MCP Servers

Read MySQL

Secure read-only MySQL database access to execute queries and analyze data patterns.

Database Monitoring

534

MySQL Query

Provides a secure, read-only bridge to MySQL databases, enabling natural language querying across multiple environments with strict validation and comprehensive error handling.

Database

314

MySQL Database Explorer

Provides secure, read-only access to MySQL databases for exploring schemas and executing SELECT queries with built-in safeguards against SQL injection, query timeouts, and row limits.

Database

318

MySQL

Provides secure MySQL database access for LLMs, enabling read/write operations with transaction support and security features for AI-assisted data management tasks.

Database

310

Report Issue

Operating System

Client

Client Name

Issue

Please describe the issue

Thank you! Your issue report has been submitted successfully.

yooztech_mcp_mysql

How to Install yooztech_mcp_mysql