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)
- List tables or AI schema narration — table and column names before SQL.
- Inspect database — schema snapshot for the connected database.
- Read, search, or execute — never guess column names.
Two credential field setups
| Setup | Fields | Routing |
|---|
| Remote MySQL | host, port, database, user, password (+ SSL for cloud) | Direct TCP/TLS |
| Local MySQL on this machine | database, user, password, port (+ desktop tunnel) | MCPBundles Desktop to localhost |
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).
