explore
Unified tool for exploring database objects. Replaces list_tables, list_databases, list_stored_procedures and search_objects.
Parameters
Section titled “Parameters”| Parameter | Type | Description |
|---|---|---|
type | string | What to explore: tables (default), databases, procedures, search |
filter | string | Name filter (LIKE). Valid for tables and procedures |
schema | string | Schema filter. Only for procedures (optional) |
pattern | string | Search pattern. Required when type=search |
search_in | string | Where to search: name (default) or definition (source code) |
Usage modes
Section titled “Usage modes”List tables and views (default)
Section titled “List tables and views (default)”{ "name": "explore", "arguments": {} }With filter:
{ "name": "explore", "arguments": { "filter": "Order" } }List databases
Section titled “List databases”{ "name": "explore", "arguments": { "type": "databases" } }List stored procedures
Section titled “List stored procedures”{ "name": "explore", "arguments": { "type": "procedures" } }With name and schema filter:
{ "name": "explore", "arguments": { "type": "procedures", "schema": "dbo", "filter": "Truck" } }Search objects by name
Section titled “Search objects by name”{ "name": "explore", "arguments": { "type": "search", "pattern": "OrderTruck" } }Search inside procedure/view source code
Section titled “Search inside procedure/view source code”{ "name": "explore", "arguments": { "type": "search", "pattern": "OrderTruck", "search_in": "definition" } }Row limit
Section titled “Row limit”All results are capped at 500 rows. If there are more, the last element will include a _truncated warning key.