A Metadata Change Proposal (MCP) server for retrieving MySQL database schema information using the [FastMCP](https://github.com/jlowin/fastmcp)
If you want an AI assistant working directly with MCP First, the mcp first mcp server is the bridge. A Metadata Change Proposal (MCP) server for retrieving MySQL database schema information using the FastMCP framework.
A Metadata Change Proposal (MCP) server for retrieving MySQL database schema information using the FastMCP framework.
Once connected, the assistant can call these 5 tools directly:
databases — List all databasestables — List all tables in a databaseschema — Get the schema (columns, indexes, and foreign keys) for one or more tablesindexes — Get the indexes for a specific tableforeign_keys — Get the foreign keys for a specific tableSetup follows the standard MCP pattern: clone or install the server, then register it in your client's configuration file and restart the client. The configuration snippets on this page cover Claude Desktop, Claude Code and Cursor.
The server reads one environment variable: MYSQL_HOST. Keep credentials in your client's env block or a secrets manager rather than committing them.
Database servers turn schema archaeology and ad-hoc reporting into conversation, which is why they tend to be the second or third server people install. MCP First sits in that group, and the shape of its toolset — databases, tables, schema among others — tells you what it is really for. Worth comparing against the other databases servers in this directory before you commit to one, since several overlap in scope but differ sharply in setup cost and permissions.
| Tool | What it does |
|---|---|
| databases | List all databases |
| tables | List all tables in a database |
| schema | Get the schema (columns, indexes, and foreign keys) for one or more tables. |
| indexes | Get the indexes for a specific table |
| foreign_keys | Get the foreign keys for a specific table |
#### Docker MCP Configuration
```json
{
"mcpServers": {
"mysql-schema": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"-e",
"MYSQL_HOST=host.docker.internal",
"-e",
"MYSQL_USER=your_username",
"-e",
"MYSQL_PASSWORD=your_password",
"mysql-mcp-server"
],
"alwaysAllow": [
"databases",
"tables",
"schema",
"indexes",
"foreign_keys"
]
}
}
}Configuration as documented by the project. Restart the client after saving.
| Variable | Description | Required |
|---|---|---|
| MYSQL_HOST | Endpoint or connection string the server talks to. | Optional |
Read-only SQL access to Postgres — let your assistant inspect schemas and answer questions from real data.
Manage your whole Supabase project in conversation — database, auth, storage, Edge Functions and branches.
Query, modify and analyse local SQLite databases in conversation — the fastest way to chat with a data file.
Metabase ships its own MCP endpoint — search your BI content, build and run queries, and save questions and dashboards without leaving the chat.
Official MongoDB server covering data, schemas and Atlas management — from find queries to spinning up clusters.
Serverless Postgres with database branching — point your assistant at Neon and let it work on disposable copies.