Schema | mysql-db-reader

mysql-db-reader

Describes the environment variables required to run the server.

Name	Required	Description
`PORT`	No	HTTP server port (default 3002)
`MYSQL_URL`	No	MySQL connection URL, e.g. mysql://user:password@localhost:3306/mydb
`DATABASE_URL`	No	Generic database URL (also accepted for MySQL)
`MYSQL_CONNECTION_STRING`	No	Alternative MySQL connection string

Features and capabilities supported by this server

Capability	Details
`tools`	{ "listChanged": true }

Functions exposed to the LLM to take actions

Name	Description
mysql_explain_queryA	Run EXPLAIN on a SELECT query to show the query execution plan. Use this to analyze query performance and identify missing indexes.
mysql_get_table_schemaA	Get table column definitions, primary key, indexes, and constraints. Use this to understand table structure before writing queries.
mysql_list_databasesA	List available databases (schemas) on the MySQL server. Use this first to discover what databases exist before querying tables.
mysql_list_tablesA	List tables (and optionally views) in a database. Use this after mysql_list_databases to discover available tables before querying or inspecting schema.
mysql_preview_tableA	Preview first N rows from a table with optional ordering. Use this to quickly inspect sample data without writing SQL.
mysql_queryA	Run a read-only SQL query with optional positional parameters. For complex queries or when you need JOINs, aggregations, or filtering. Results are limited to 10,000 rows; use LIMIT for large tables.

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/riefer02/mysql-db-reader'

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