search_tables
Search database schema by name pattern to locate tables or columns when exact names are unknown. Uses SQL LIKE wildcards and pagination to prevent token overflow.
Instructions
Search for tables or columns by name pattern. Useful for finding specific tables or columns when you don't know the exact name. Paginated to prevent token overflow.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| page | No | Page number for pagination (1-indexed). Default: 1 | |
| type | No | Search type: "tables", "columns", or "all" | all |
| limit | No | Number of results per page. Default: 50, Max: 1000 | |
| compact | No | Use compact format with abbreviated field names to reduce token usage. Default: false | |
| pattern | Yes | The search pattern (supports SQL LIKE wildcards) |