MySQL Query MCP Server
@devakone
MySQL Query MCP Server について
MySQL Query MCP server for AI assistants - execute read-only MySQL queries
基本情報
設定
以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。
{
"mcpServers": {
"mysql-query-mcp-server": {
"command": "npx",
"args": [
"mysql-query-mcp-server"
]
}
}
}ツール
ツールは検出されませんでした
ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。
概要
What is MySQL Query MCP Server?
A Model Context Protocol (MCP) server that provides read-only MySQL database queries for AI assistants. It enables AI-powered tools like Cursor IDE and Anthropic Claude to execute queries, explore database structures, and investigate data directly.
How to use MySQL Query MCP Server?
Install globally with npm install -g mysql-query-mcp-server or run instantly with npx mysql-query-mcp-server. Configure your AI tool’s MCP settings (e.g., .cursor/mcp.json) with environment variables for database credentials (LOCAL_DB_HOST, LOCAL_DB_USER, etc.). The server exposes three tools: query (read-only SQL), info (database metadata), and environments (list configured environments).
Key features of MySQL Query MCP Server
- Read-only MySQL queries (SELECT, SHOW, DESCRIBE)
- Predefined environments: local, development, staging, production
- SSL support for secure database connections
- Query timeout to prevent long-running operations
- Database information and metadata retrieval
- Lists available database environments
Use cases of MySQL Query MCP Server
- Investigate database structure and table schemas via AI assistants
- Run read-only analytical queries on production data without risk
- Explore development and staging databases for debugging
- List available database environments from configuration
- Retrieve database metadata such as version and connection status
FAQ from MySQL Query MCP Server
What types of queries can I execute?
Only read‑only SQL statements: SELECT, SHOW
「データベース」の他のコンテンツ
Redis MCP Server
redisThe official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently
mcp-server-duckdb
ktanaka101A Model Context Protocol (MCP) server implementation for DuckDB, providing database interaction capabilities
ClickHouse MCP Server
ClickHouseConnect ClickHouse to your AI assistants.
Chroma MCP Server
chroma-coreA Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma
Database Gateway
centralmindUniversal MCP-Server for your Databases optimized for LLMs and AI-Agents.
コメント