Function createSearchDatabaseObjectsToolHandler

src/tools/search-objects.ts:619–739

(sourceId?: string)

 * Create a search_database_objects tool handler
 */
export function createSearchDatabaseObjectsToolHandler(sourceId?: string) {
  return async (args: any, extra: any) => {
    const {
      object_type,
      pattern = "%",
      schema,
      table,
      detail_level = "names",
      limit = 100,
    } = args as {
      object_type: DatabaseObjectType;
      pattern?: string;
      schema?: string;
      table?: string;
      detail_level: DetailLevel;
      limit: number;
    };

    const startTime = Date.now();
    const effectiveSourceId = getEffectiveSourceId(sourceId);
    let success = true;
    let errorMessage: string | undefined;

    try {
      // Ensure source is connected (handles lazy connections)
      await ConnectorManager.ensureConnected(sourceId);

      const connector = ConnectorManager.getCurrentConnector(sourceId);

      // Tool is already registered, so it's enabled (no need to check)

      // Validate table parameter
      if (table) {
        if (!schema) {
          success = false;
          errorMessage = "The 'table' parameter requires 'schema' to be specified";
          return createToolErrorResponse(errorMessage, "SCHEMA_REQUIRED");
        }
        if (!["column", "index"].includes(object_type)) {
          success = false;
          errorMessage = `The 'table' parameter only applies to object_type 'column' or 'index', not '${object_type}'`;
          return createToolErrorResponse(errorMessage, "INVALID_TABLE_FILTER");
        }
      }

      // Validate schema if provided
      if (schema) {
        const schemas = await connector.getSchemas();
        if (!schemas.includes(schema)) {
          success = false;
          errorMessage = `Schema '${schema}' does not exist. Available schemas: ${schemas.join(", ")}`;
          return createToolErrorResponse(errorMessage, "SCHEMA_NOT_FOUND");
        }
      }

      let results: any[] = [];

      // Route to appropriate search function