MySQL MCP Server

MySQL

MySQL access uses a standard connection URI or discrete host/port/database credentials—mirror the PostgreSQL mental model. Use bounded table reads, structured search, or parameterized SQL execution for mutating work.

Data Model

• Tables — discover names before writing migrations or ad hoc queries.
• Parameterized reads — filter and paginate rows, run structured search, or execute read SQL.
• Ad hoc execution — DDL/DML when the integration exposes an execute surface.
• Connectivity — mysql:// URIs; loopback hosts use the local desktop setup.

Operational order (unfamiliar schema)

1. List tables or AI schema narration — table and column names before SQL.
2. Inspect database — schema snapshot for the connected database.
3. Read, search, or execute — never guess column names.

Two credential field setups

Gotchas

• Read vs write: Keep exploratory reads on guarded paths; wrap destructive statements in transactions.
• TLS: Managed clouds expect SSL modes in the DSN.
• Single-row reads: Filter on the primary key with a bounded row read or execute parameterized SQL — not colon mysql:row:… tokens (removed).