Schema | @cano721/mysql-mcp-server

@cano721/mysql-mcp-server

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

Features and capabilities supported by this server

Capability	Details
`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

Interactive templates invoked by user choice

Name	Description
No prompts

Contextual data attached and managed by the client

Name	Description
No resources

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/cano721/mysql-mcp-server'

If you have feedback or need assistance with the MCP directory API, please join our Discord server