@cano721/mysql-mcp-server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MYSQL_HOST | Yes | Database server hostname | |
| MYSQL_PORT | No | Database server port | 3306 |
| MYSQL_USER | Yes | Database username | |
| MYSQL_DATABASE | No | Default database name | |
| MYSQL_MAX_IDLE | No | Maximum idle connections | 10 |
| MYSQL_PASSWORD | No | Database password | |
| MYSQL_QUEUE_LIMIT | No | Maximum queued connection requests | 0 |
| MYSQL_IDLE_TIMEOUT | No | Idle timeout in milliseconds | 60000 |
| MYSQL_ALLOW_ANALYZE | No | Allow ANALYZE queries | true |
| MYSQL_ALLOW_EXPLAIN | No | Allow EXPLAIN queries | true |
| MYSQL_QUERY_TIMEOUT | No | Query timeout in milliseconds | 60000 |
| MYSQL_CONNECT_TIMEOUT | No | Connection timeout in milliseconds | 10000 |
| MYSQL_CONNECTION_LIMIT | No | Maximum connections in pool | 1 |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Features and capabilities supported by this server
Protocol revision2025-11-25
| Capability | Details |
|---|---|
| tools | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| list_databasesB | List all accessible databases on the MySQL server. 한글: 데이터베이스 목록, DB 목록, 데이터베이스 조회 |
| list_tablesA | List all tables in a specified database. 한글: 테이블 목록, 테이블 조회, 테이블 리스트 |
| describe_tableB | Show the schema for a specific table. 한글: 테이블 스키마, 테이블 구조, 컬럼 정보, 테이블 설명 |
| execute_queryA | Execute a read-only SQL query. 한글: 쿼리 실행, SQL 실행, 조회 쿼리 |
| get_related_tablesA | Find all related/connected/associated tables linked to a specific table through foreign keys. Discovers table relationships and dependencies with depth traversal. Use this when asked to find related tables, connected tables, associated tables, or table relationships. 한글: 연관 테이블, 관련 테이블, 연결된 테이블, 테이블 관계, 참조 테이블, FK 관계 |
| explain_queryB | Analyze query execution plan using EXPLAIN. 한글: 쿼리 실행 계획, 쿼리 분석, EXPLAIN |
| analyze_queryB | Analyze query performance and statistics using ANALYZE. 한글: 쿼리 성능 분석, 쿼리 통계, ANALYZE |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
TDQS
Scored across 7 tools
Each tool has a distinct purpose: listing databases, listing tables, describing table schemas, executing read-only queries, analyzing performance, explaining execution plans, and discovering table relationships. No overlap between tools.
All tool names follow a consistent verb_noun pattern in snake_case (e.g., list_databases, describe_table, execute_query), making it predictable and easy for an agent to infer functionality.
With 7 tools, the server covers the essential operations for a MySQL read-only analysis server: exploration (databases, tables, schema), query execution, performance analysis (EXPLAIN, ANALYZE), and relationship discovery. The count is well-scoped.
The tool set provides full lifecycle coverage for read-only database analysis: listing, describing, querying, analyzing, and relating. There are no obvious gaps for the intended purpose.