Skip to main content
Glama

flexible_search

Execute FlexibleSearch queries to retrieve data from SAP Commerce Cloud (Hybris) databases using FlexibleSearch syntax for product, order, and system data management.

Instructions

Execute a FlexibleSearch query against the Hybris database. Use FlexibleSearch syntax.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
queryYesFlexibleSearch query (e.g., "SELECT {pk}, {code} FROM {Product}")
maxCountNoMaximum number of results (default: 100)

Implementation Reference

  • The actual implementation of the executeFlexibleSearch logic which makes the API call to the Hybris HAC console.
    async executeFlexibleSearch(query: string, maxCount = 100): Promise<FlexibleSearchResult> {
      const formData = new URLSearchParams({
        flexibleSearchQuery: query,
        maxCount: maxCount.toString(),
      });
    
      return this.hacRequest<FlexibleSearchResult>(
        `${this.hacPrefix}/console/flexsearch/execute`,
        {
          method: 'POST',
          headers: {
            'Content-Type': 'application/x-www-form-urlencoded',
          },
          body: formData,
        }
      );
    }
  • MCP tool definition and input schema for flexible_search.
    {
      name: 'flexible_search',
      description: 'Execute a FlexibleSearch query against the Hybris database. Use FlexibleSearch syntax.',
      inputSchema: {
        type: 'object',
        properties: {
          query: {
            type: 'string',
            description: 'FlexibleSearch query (e.g., "SELECT {pk}, {code} FROM {Product}")',
          },
          maxCount: {
            type: 'number',
            description: 'Maximum number of results (default: 100)',
          },
        },
        required: ['query'],
      },
  • src/index.ts:416-421 (registration)
    The handler switch-case that dispatches the tool call to the Hybris client implementation.
    case 'flexible_search':
      result = await hybrisClient.executeFlexibleSearch(
        validateString(args, 'query', true),
        validateNumber(args, 'maxCount', { min: 1, max: 10000 })
      );
      break;

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/mcieunic/hybris-mcp-main'

If you have feedback or need assistance with the MCP directory API, please join our Discord server