execute_custom_query
Run SQL-like queries on session data to analyze user behavior, track errors, or measure performance metrics using custom search parameters.
Instructions
Execute a custom query on the session data (supports SQL-like syntax for ClickHouse)
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| parameters | No | Query parameters | |
| query | Yes | Custom query to execute |
Implementation Reference
- src/index.ts:475-487 (handler)The handler function that implements the core logic for the 'execute_custom_query' tool. It destructures the args and returns a standardized MCP response indicating that custom queries are not supported.private async executeCustomQuery(args: any) { // OpenReplay doesn't expose direct query access, but we can use the search with complex filters const { query, parameters } = args; return { content: [ { type: "text", text: "Custom queries are not directly supported. Please use the specific search and filter tools instead.", }, ], }; }
- src/index.ts:256-262 (schema)The input schema definition for the 'execute_custom_query' tool, specifying the expected input parameters: a required 'query' string and optional 'parameters' object.inputSchema: { type: "object", properties: { query: { type: "string", description: "Custom query to execute" }, parameters: { type: "object", description: "Query parameters" } }, required: ["query"]
- src/index.ts:253-264 (registration)The tool registration in the listTools handler, defining the name, description, and input schema for 'execute_custom_query'.{ name: "execute_custom_query", description: "Execute a custom query on the session data (supports SQL-like syntax for ClickHouse)", inputSchema: { type: "object", properties: { query: { type: "string", description: "Custom query to execute" }, parameters: { type: "object", description: "Query parameters" } }, required: ["query"] } }
- src/index.ts:294-295 (registration)The dispatch case in the CallToolRequestSchema handler that routes calls to the executeCustomQuery method.case "execute_custom_query": return await this.executeCustomQuery(args);