Skip to main content
Glama
Emenowicz

Hybris MCP Server

by Emenowicz

flexible_search

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

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

  • src/index.ts:194-211 (registration)
    Registers the 'flexible_search' tool in the MCP tools list, including name, description, and input schema definition.
    {
      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'],
      },
    },
  • MCP server tool call handler for 'flexible_search': validates input arguments and delegates to HybrisClient.executeFlexibleSearch.
    case 'flexible_search':
      result = await hybrisClient.executeFlexibleSearch(
        validateString(args, 'query', true),
        validateNumber(args, 'maxCount', { min: 1, max: 10000 })
      );
      break;
  • Core implementation of flexible search: sends POST request to Hybris HAC FlexibleSearch endpoint with query and maxCount, returns FlexibleSearchResult.
    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,
        }
      );
    }
  • Type definition for the output of flexible_search: array of result objects and total count.
    export interface FlexibleSearchResult {
      results: Record<string, unknown>[];
      count: number;
    }

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/Emenowicz/hybris-mcp'

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