Skip to main content
Glama

mcp-mysql-lens

MIT License
152
  • Apple
  • Linux

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
MYSQL_HOSTYesMySQL server hostname
MYSQL_PORTYesMySQL server port3306
MYSQL_USERYesDatabase username
MYSQL_DATABASEYesDefault database to connect to
MYSQL_PASSWORDYesDatabase password

Schema

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Tools

Functions exposed to the LLM to take actions

NameDescription
list_databases

List all accessible databases on the MySQL server

list_tables

List all tables in a specified database

describe_table

Show the schema for a specific table

execute_query

Execute a read-only SQL query

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/Himanshu-Agg12/mcp-mysql-lens'

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