search_objects
Search and explore database objects like schemas, tables, columns using SQL LIKE patterns. Choose from three detail levels to balance token usage with metadata completeness.
Instructions
Search and explore database objects (schemas, tables, views, columns, indexes) with progressive disclosure for token efficiency. Use SQL LIKE pattern (% matches any sequence, _ matches one character) to match names. Three detail levels: 'names' (most token-efficient), 'summary' (default, key metadata), 'full' (includes comments and full type info). For column/index search, narrow with schema (and optionally table) to avoid the per-call table cap.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| pattern | Yes | SQL LIKE pattern to match object names. Use '%' to match all, '%user%' for substring, '_d' for single-char wildcard. | |
| object_types | No | Types of objects to search. Defaults to all 5 types. Restricting types is faster. | |
| detail_level | No | Response verbosity. 'names' returns just identifiers (cheapest), 'summary' adds key metadata, 'full' includes comments and type details. | summary |
| schema | No | Restrict search to a specific schema. Strongly recommended when searching columns or indexes. | |
| table | No | Restrict column/index search to a specific table. Without `schema`, matches a table of that name in any schema. | |
| limit | No | Max items to return (1-1000). Total match count is reported separately in 'total_found'. |