Skip to main content
Glama

MySQL ReadOnly MCP Server

by zhaojw-php

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
MYSQL_HOSTNoMySQL server addresslocalhost
MYSQL_PORTNoMySQL server port3306
MYSQL_USERYesMySQL username
MYSQL_SSL_CANoSSL CA certificate path
MYSQL_SSL_KEYNoSSL client key path
MYSQL_DATABASENoDefault database to connect to
MYSQL_PASSWORDYesMySQL password
MYSQL_SSL_CERTNoSSL client certificate path
MYSQL_SSL_REJECT_UNAUTHORIZEDNoWhether to reject unauthorized SSL certificatestrue

Tools

Functions exposed to the LLM to take actions

NameDescription
mysql_query

Execute a read-only SQL query on MySQL database

mysql_list_tables

List all tables in the database

mysql_describe_table

Get table structure and column information

mysql_list_databases

List all available databases

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Latest Blog Posts

MCP directory API

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

curl -X GET 'https://glama.ai/api/mcp/v1/servers/zhaojw-php/mysql-readonly-mcp'

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