MCP Metrics: Filtering

Filtering

Filters narrow down the rows that go into each aggregation and group. They are AND-combined; there is no OR-group support. The server enforces a per-field operator allow-list, so the exact subset of operators you can use depends on the field.

Filter object structure

Field filters
Metadata filters

For standard datasource fields, use fieldName:

{
    "fieldName": "method",
    "operator": "IN",
    "value": ["tools/call"]
}

For custom request-metadata keys, use metadataKey. Works on every datasource:

{
    "metadataKey": "environment",
    "operator": "IN",
    "value": ["production"]
}

Filterable fields

The MCP-specific string fields (mcpServerName, method, toolName) accept only a narrow set of string operators (IN, NOT_IN, STRING_CONTAINS, STRING_STARTS_WITH, STRING_ENDS_WITH). EQUAL and NOT_EQUAL are only supported on userEmail, virtualAccount, and conversationID.

Field	Type	Allowed operators
`mcpServerName`	string	`IN`, `NOT_IN`, `STRING_CONTAINS`, `STRING_STARTS_WITH`, `STRING_ENDS_WITH`
`method`	string	`IN`, `NOT_IN`, `STRING_CONTAINS`, `STRING_STARTS_WITH`, `STRING_ENDS_WITH`
`toolName`	string	`IN`, `NOT_IN`, `STRING_CONTAINS`, `STRING_STARTS_WITH`, `STRING_ENDS_WITH`
`userEmail`	string	full string operator set
`virtualAccount`	string	full string operator set
`team`	array	`ARRAY_HAS_ANY`, `ARRAY_HAS_NONE`
`latencyMs`	number	`GREATER_THAN`, `LESS_THAN`, `GREATER_THAN_EQUAL`, `LESS_THAN_EQUAL`, `BETWEEN`
`conversationID`	string	full string operator set
`metadataKey` / `metadata.<key>`	string	full string operator set

Filter operators

String field operators

Operator	Description	Example value
`EQUAL`	Exact match	`"alice@example.com"`
`NOT_EQUAL`	Not equal to value	`"bot@example.com"`
`IN`	Match any value in the list	`["tools/call", "tools/list"]`
`NOT_IN`	Exclude values in the list	`["initialize"]`
`STRING_CONTAINS`	Contains substring	`"github"`
`STRING_NOT_CONTAINS`	Does not contain substring	`"internal"`
`STRING_STARTS_WITH`	Starts with prefix	`"github-"`
`STRING_NOT_STARTS_WITH`	Does not start with prefix	`"internal-"`
`STRING_ENDS_WITH`	Ends with suffix	`"-mcp"`
`STRING_NOT_ENDS_WITH`	Does not end with suffix	`"-deprecated"`
`IS_NULL`	`true` matches rows where the field is unset; `false` matches rows where it is set	`true`

Numeric field operators

Operator	Description	Example value
`EQUAL`	Exact match	`1000`
`NOT_EQUAL`	Not equal to value	`0`
`IN`	Match any value in the list	`[100, 200, 300]`
`NOT_IN`	Exclude values in the list	`[0]`
`GREATER_THAN`	Strictly greater than	`1000`
`LESS_THAN`	Strictly less than	`5000`
`GREATER_THAN_EQUAL`	Greater than or equal to	`100`
`LESS_THAN_EQUAL`	Less than or equal to	`1000`
`BETWEEN`	Between two values (inclusive)	`[500, 5000]`
`IS_NULL`	`true` matches rows where the field is unset; `false` matches rows where it is set	`true`

Array field operators (used by `team`)

Operator	Description	Example value
`ARRAY_HAS_ANY`	Match if the array contains any of the values	`["team-alpha", "team-beta"]`
`ARRAY_HAS_NONE`	Match if the array contains none of the values	`["excluded-team"]`

Custom metadata filtering and grouping

Every datasource supports filtering and grouping by custom request-metadata keys:

Filter: { "metadataKey": "environment", "operator": "EQUAL", "value": "prod" }
Group: include "metadata.environment" in the groupBy array (string literal, prefix is metadata.).

Metadata fields are treated as strings; use the String field operators table.

Implicit team unnesting

When team is in groupBy (or used as the column of an aggregation), the server transparently UNNESTs the Teams array CTE before applying RBAC. Callers don’t need to do anything extra. Rows whose Teams array is NULL or empty drop out naturally.

Combining multiple filters

Filters are AND-combined:

{
    "startTs": "2026-04-21T00:00:00.000Z",
    "endTs": "2026-04-22T00:00:00.000Z",
    "datasource": "mcpMetrics",
    "type": "distribution",
    "filters": [
        {"fieldName": "method", "operator": "IN", "value": ["tools/call"]},
        {"fieldName": "mcpServerName", "operator": "IN", "value": ["github-mcp", "atlassian-mcp"]},
        {"fieldName": "latencyMs", "operator": "BETWEEN", "value": [100, 10000]},
        {"fieldName": "team", "operator": "ARRAY_HAS_ANY", "value": ["team-alpha"]}
    ],
    "groupBy": ["mcpServerName", "toolName"]
}

Get Started

LLM Gateway

MCP Registry and Gateway

Skills Registry

Prompt Registry

Guardrails and Security

Observability

Deployment

Admin Guide

Chat

Messages

Embeddings

Rerank

Responses

Image

Audio

Batch

Files

Fine-tuning

Moderations

Models

Filtering

Filter object structure

Filterable fields

Filter operators

String field operators

Numeric field operators

Array field operators (used by `team`)

Custom metadata filtering and grouping

Implicit team unnesting

Combining multiple filters

​Filtering

​Filter object structure

​Filterable fields

​Filter operators

​String field operators

​Numeric field operators

​Array field operators (used by team)

​Custom metadata filtering and grouping

​Implicit team unnesting

​Combining multiple filters

Filtering

Filter object structure

Filterable fields

Filter operators

String field operators

Numeric field operators

Array field operators (used by `team`)

Custom metadata filtering and grouping

Implicit team unnesting

Combining multiple filters