search_db_objects
Search database objects like schemas, tables, columns, and procedures on SQL Server using SQL LIKE patterns to locate specific elements within your database structure.
Instructions
Search database objects (schemas, tables, columns, procedures) on 'sqlserver_local'. Supports SQL LIKE patterns.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| object_type | No | Type of database object to search for | |
| pattern | No | Search pattern (SQL LIKE syntax, default: '%' for all) | |
| schema | No | Filter by schema name | |
| table | No | Filter by table name (for columns) |
Implementation Reference
- src/server.ts:143-151 (handler)Stub handler for the search_db_objects tool that returns a placeholder response indicating implementation is pending database connector integration.
}, async (args) => { // TODO: Implement actual database object search return createToolSuccessResponse({ message: `Database object search on '${sourceId}' not yet implemented`, filter: args, source_id: sourceId, note: "Database connector integration pending", }); - src/server.ts:137-142 (schema)Zod schema defining input parameters for the search_db_objects tool: object_type, pattern, schema, table.
{ object_type: z.enum(["schema", "table", "column", "procedure", "index"]).optional() .describe("Type of database object to search for"), pattern: z.string().optional().describe("Search pattern (SQL LIKE syntax, default: '%' for all)"), schema: z.string().optional().describe("Filter by schema name"), table: z.string().optional().describe("Filter by table name (for columns)"), - src/server.ts:135-153 (registration)Registration of the search_db_objects tool using McpServer.tool(), including name, description, input schema, and handler. Registered for each database source with optional suffix.
`search_db_objects${toolSuffix}`, `Search database objects (schemas, tables, columns, procedures) on '${sourceId}'. Supports SQL LIKE patterns.`, { object_type: z.enum(["schema", "table", "column", "procedure", "index"]).optional() .describe("Type of database object to search for"), pattern: z.string().optional().describe("Search pattern (SQL LIKE syntax, default: '%' for all)"), schema: z.string().optional().describe("Filter by schema name"), table: z.string().optional().describe("Filter by table name (for columns)"), }, async (args) => { // TODO: Implement actual database object search return createToolSuccessResponse({ message: `Database object search on '${sourceId}' not yet implemented`, filter: args, source_id: sourceId, note: "Database connector integration pending", }); } );