search_schema
Search tables and columns in a Firebird database by name pattern using case-insensitive regex. Returns matching table names and column details.
Instructions
Search for tables or columns whose names match a pattern. Use this instead of listing all objects when you know part of a name — e.g. find every table containing 'ORDER', or every column named 'CUSTOMER_ID'. Returns {tables: ["NAME"], columns: [{table, column, type}]}.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | Yes | Database key from list_databases. | |
| pattern | Yes | Case-insensitive .NET regex pattern to search for. Applied to object/column names. | |
| scope | No | What to search: 'tables' (table/view names only), 'columns' (column names only), 'all' (default, both). | all |
| limit | No | Maximum number of results per category (tables and columns each). Defaults to 50. |