Schema | mcp-server-mysql-schema

mcp-server-mysql-schema

Describes the environment variables required to run the server.

Name	Required	Description	Default
`MYSQL_HOST`	No	MySQL host	127.0.0.1
`MYSQL_PASS`	No	MySQL password
`MYSQL_PORT`	No	MySQL port	3306
`MYSQL_USER`	No	MySQL user	root
`MYSQL_DEFAULT_DB`	No	Default database for resource URIs

Features and capabilities supported by this server

Capability	Details
`tools`	{}
`resources`	{}

Functions exposed to the LLM to take actions

Name	Description
schema_databasesA	List all non-system MySQL databases with charset and collation
schema_tablesA	List all tables in a database with engine, row count, size estimates, and comments
schema_viewsB	List all views in a database
schema_table_detailB	Show columns, types, defaults, nullable, keys, and comments for a table
schema_foreign_keysB	List foreign key relationships for a database or specific table (incoming + outgoing)
schema_indexesA	List all indexes for a table with columns, uniqueness, and type
schema_relationshipsB	Full relationship map across all tables in a database: primary keys, foreign keys, and references
schema_searchB	Search across table and column names in a database

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/rendi-febrian/mcp-server-mysql-schema'

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