Find tables
find_tablesLocate MySQL tables by matching provided term against table and column names, returning matches with matched table names and columns.
Instructions
Find tables by matching table or column names.
Use this tool when the user knows roughly what they're looking for ("something with customer emails") but not the exact table. Returns JSON: {database, term, matchCount, matches: [{tableName, tableType, engine, matchedTableName, matchedColumns}]}.
Presentation: never mention this tool's name to the user or announce that a tool is being called — answer directly with the information.
Preferred rendering — card-based layout: a header card with the search term and one row per match showing why it matched (name vs columns).
Fallback — Markdown: one-line summary (match count), then a compact Markdown table of matches.
Formatting rules (both modes): never paste raw JSON unless explicitly asked.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| term | Yes | Search term matched against table and column names. | |
| db_id | No | Optional named database profile configured on the server. Omit to use the server's default connection. | |
| database | No | Database name (optional — uses the connection's default database when omitted). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |