Developer-tools MCP server

Apache Pinot MCP Server

Version history of discovered tools, schemas, and declared agent authority.

View watchlist

DistributionDistribution: PyPI
Packagemcp-pinot-server
Latest analyzed version5.0.0
Current tool count18
Latest analysisNov 16, 2026
Package source

OBSERVED INTERFACE

Capability surface

Modelara’s observed declarations are shown separately from its derived effect classifications.

3 releases analyzed4.0.0 → 5.0.0Latest: 5.0.0
  • read13
  • write2
  • destructive3
  • unknown0

Unknown means Valyd could not determine the capability's effect confidently from the declared interface and static evidence. It is not treated as safe.

Package
mcp-pinot-server@5.0.0
Registry
pypi
Published
Oct 12, 2026
Integrity
sha256-+unWJw6pCILWbzuApVkHwg2H4bqO8jzBzBKG2DRZH5Q=
Analyzer
modelara v0.1.8 · policy not recorded
Repository
https://github.com/startreedata/mcp-pinot

18 capabilities

CapabilityTypeDerived effectFirst observed in Valyd coverageLast changed
begin_investigationstartreedata-mcp-pinot:tool:begin_investigation
Observed interface and hashes

Open an owner-bound, budgeted evidence run using a server-owned profile. Supply closed baseline/incident windows in epoch milliseconds. The server checks scope, windows, and authorization before issuing an opaque run ID. Failure recovery: Correct invalid scope/window inputs; expired runs require a new investigation.

Input schema

{
  "additionalProperties": false,
  "properties": {
    "baseline_start_ms": {
      "minimum": 0,
      "type": "integer"
    },
    "end_ms": {
      "minimum": 0,
      "type": "integer"
    },
    "profile_id": {
      "maxLength": 256,
      "minLength": 1,
      "type": "string"
    },
    "service": {
      "maxLength": 256,
      "minLength": 1,
      "type": "string"
    },
    "start_ms": {
      "minimum": 0,
      "type": "integer"
    }
  },
  "required": [
    "profile_id",
    "service",
    "baseline_start_ms",
    "start_ms",
    "end_ms"
  ],
  "type": "object"
}
sha256:dc2c712502a75e396d1aa6fad340345aef151f79ce1ec6fee922f2e15bed8f26

Output schema

{
  "properties": {
    "baseline_start_ms": {
      "type": "integer"
    },
    "deadline_seconds": {
      "type": "integer"
    },
    "end_ms": {
      "type": "integer"
    },
    "max_queries": {
      "type": "integer"
    },
    "profile_id": {
      "type": "string"
    },
    "run_id": {
      "type": "string"
    },
    "scope": {
      "default": "single_process_incident_evidence_assembly",
      "type": "string"
    },
    "service": {
      "type": "string"
    },
    "start_ms": {
      "type": "integer"
    }
  },
  "required": [
    "run_id",
    "profile_id",
    "service",
    "baseline_start_ms",
    "start_ms",
    "end_ms",
    "deadline_seconds",
    "max_queries"
  ],
  "type": "object"
}
sha256:2a75bab29441b6c0f5434e91b2eb5fc88c4cf8a4c32dc61043016b343095a568

Description hash: sha256:7cf0300d748ba3e3d566be814f4d10f344c5db7f5031ba46dade54242d1c7cfc

Interface hash: sha256:5b709aff68a9db6944590e26190f232a5fe221d317b0212288efcfc2516a61ef

Other observed Modelara metadata
{
  "id": "mcp:Pinot MCP Server/begin_investigation",
  "title": "Begin investigation",
  "source": {
    "type": "mcp",
    "server": "Pinot MCP Server",
    "operation": "begin_investigation"
  },
  "declared": {
    "read_only": "true",
    "destructive": "unknown",
    "idempotent": "false",
    "open_world": "true"
  },
  "safety": {
    "idempotent": "true",
    "retry_safe": "true"
  },
  "metadata": {
    "mcp.annotations": "present"
  },
  "fingerprint": "sha256:b855bccc561d0e02d9decf886290362698ed6680307a827d93a8b6285e7e7a85"
}
toolread5.0.05.0.0
create_schemastartreedata-mcp-pinot:tool:create_schema
Observed interface and hashes

Preview or create a new Pinot schema without replacing an existing schema. The default preview performs strict local structural validation and returns a short-lived confirmation token bound to the exact normalized schema. Pass that token with ``dry_run=false`` to apply. Replacement belongs in ``update_schema``. Failure recovery: Invalid JSON, missing ``schemaName``, and controller validation failures are non-retryable until corrected. Permission failures require access changes; retry transient controller failures only after connectivity is restored.

Input schema

{
  "additionalProperties": false,
  "properties": {
    "confirmation_token": {
      "anyOf": [
        {
          "maxLength": 4096,
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Token returned by a preview of this exact payload."
    },
    "dry_run": {
      "default": true,
      "description": "Preview safely (default); false requests application.",
      "type": "boolean"
    },
    "schema": {
      "additionalProperties": {},
      "description": "Structured Pinot schema. schemaName is required.",
      "properties": {
        "dateTimeFieldSpecs": {
          "items": {
            "additionalProperties": {},
            "description": "Typed Pinot column definition used by schema write tools.",
            "properties": {
              "dataType": {
                "enum": [
                  "INT",
                  "LONG",
                  "FLOAT",
                  "DOUBLE",
                  "BIG_DECIMAL",
                  "BOOLEAN",
                  "TIMESTAMP",
                  "STRING",
                  "BYTES",
                  "JSON"
                ],
                "type": "string"
              },
              "defaultNullValue": {
                "default": null
              },
              "name": {
                "maxLength": 128,
                "minLength": 1,
                "pattern": "^[A-Za-z0-9_-]+$",
                "type": "string"
              },
              "singleValueField": {
                "default": true,
                "type": "boolean"
              }
            },
            "required": [
              "name",
              "dataType"
            ],
            "type": "object"
          },
          "maxItems": 100,
          "type": "array"
        },
        "dimensionFieldSpecs": {
          "items": {
            "additionalProperties": {},
            "description": "Typed Pinot column definition used by schema write tools.",
            "properties": {
              "dataType": {
                "enum": [
                  "INT",
                  "LONG",
                  "FLOAT",
                  "DOUBLE",
                  "BIG_DECIMAL",
                  "BOOLEAN",
                  "TIMESTAMP",
                  "STRING",
                  "BYTES",
                  "JSON"
                ],
                "type": "string"
              },
              "defaultNullValue": {
                "default": null
              },
              "name": {
                "maxLength": 128,
                "minLength": 1,
                "pattern": "^[A-Za-z0-9_-]+$",
                "type": "string"
              },
              "singleValueField": {
                "default": true,
                "type": "boolean"
              }
            },
            "required": [
              "name",
              "dataType"
            ],
            "type": "object"
          },
          "maxItems": 10000,
          "type": "array"
        },
        "metricFieldSpecs": {
          "items": {
            "additionalProperties": {},
            "description": "Typed Pinot column definition used by schema write tools.",
            "properties": {
              "dataType": {
                "enum": [
                  "INT",
                  "LONG",
                  "FLOAT",
                  "DOUBLE",
                  "BIG_DECIMAL",
                  "BOOLEAN",
                  "TIMESTAMP",
                  "STRING",
                  "BYTES",
                  "JSON"
                ],
                "type": "string"
              },
              "defaultNullValue": {
                "default": null
              },
              "name": {
                "maxLength": 128,
                "minLength": 1,
                "pattern": "^[A-Za-z0-9_-]+$",
                "type": "string"
              },
              "singleValueField": {
                "default": true,
                "type": "boolean"
              }
            },
            "required": [
              "name",
              "dataType"
            ],
            "type": "object"
          },
          "maxItems": 10000,
          "type": "array"
        },
        "primaryKeyColumns": {
          "anyOf": [
            {
              "items": {
                "type": "string"
              },
              "maxItems": 100,
              "type": "array"
            },
            {
              "type": "null"
            }
          ],
          "default": null
        },
        "schemaName": {
          "maxLength": 128,
          "minLength": 1,
          "pattern": "^(?:[A-Za-z0-9_-]+\\.)?[A-Za-z0-9_-]+$",
          "type": "string"
        }
      },
      "required": [
        "schemaName"
      ],
      "type": "object"
    }
  },
  "required": [
    "schema"
  ],
  "type": "object"
}
sha256:b66d371d70c5b6233cf0e278451dfada1ed8fffb2137d2eeb5bd3d84e9271c3c

Output schema

{
  "additionalProperties": false,
  "description": "Result of a schema or table-config create/update operation.",
  "properties": {
    "applied": {
      "default": false,
      "description": "True only when Pinot accepted a mutating request.",
      "type": "boolean"
    },
    "confirmation_token": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Short-lived token bound to this exact preview; required to apply it."
    },
    "dry_run": {
      "default": false,
      "description": "True when no mutation was sent to Pinot.",
      "type": "boolean"
    },
    "message": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Human-readable detail, when provided."
    },
    "operation": {
      "description": "Stable operation identifier.",
      "enum": [
        "create_schema",
        "update_schema",
        "create_table",
        "update_table"
      ],
      "type": "string"
    },
    "resource_name": {
      "description": "Exact schema or table name targeted.",
      "type": "string"
    },
    "resource_type": {
      "description": "Kind of Pinot resource targeted by the operation.",
      "enum": [
        "schema",
        "table"
      ],
      "type": "string"
    },
    "response_summary": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Sanitized summary returned by the Pinot controller."
    },
    "status": {
      "default": "success",
      "description": "Whether the operation was previewed, applied, or rejected.",
      "enum": [
        "preview",
        "success",
        "rejected"
      ],
      "type": "string"
    },
    "verification_tool": {
      "description": "Read tool to call after a successful mutation.",
      "enum": [
        "get_schema",
        "get_table_config"
      ],
      "type": "string"
    },
    "warnings": {
      "description": "Safety or validation warnings.",
      "items": {
        "type": "string"
      },
      "type": "array"
    }
  },
  "required": [
    "operation",
    "resource_type",
    "resource_name",
    "verification_tool"
  ],
  "type": "object"
}
sha256:a1b69f42125d3d5beb369a44b6a20ebcbd0626d31fc6734368ec0f99995ac511

Description hash: sha256:0dcf330d258ab52362a62f688d5ee5fd33bc8c7703fcd931e3ceda9bb2a0ccf3

Interface hash: sha256:525ab4f07e67f7df00ee054bb7c66420caa6216d7da6574661f8f555a980b66e

Other observed Modelara metadata
{
  "id": "mcp:Pinot MCP Server/create_schema",
  "title": "Create schema",
  "source": {
    "type": "mcp",
    "server": "Pinot MCP Server",
    "operation": "create_schema"
  },
  "declared": {
    "read_only": "false",
    "destructive": "false",
    "idempotent": "false",
    "open_world": "true"
  },
  "safety": {
    "idempotent": "false",
    "retry_safe": "false"
  },
  "metadata": {
    "mcp.annotations": "present"
  },
  "fingerprint": "sha256:d2c730f58455a1b80cb124a6d4ccff6694bb649eeb06f3a1b636b7dd408060c7"
}
toolwrite4.0.05.0.0
create_table_configstartreedata-mcp-pinot:tool:create_table_config
Observed interface and hashes

Create a new Pinot table configuration. Accepts a typed table-config object. The default ``dry_run=true`` asks Pinot to validate the payload and returns a confirmation token without applying. Failure recovery: Invalid JSON, missing ``tableName``, and controller validation failures need a corrected payload; do not retry unchanged. Fix access failures first, and retry transient controller errors after connectivity is restored.

Input schema

{
  "additionalProperties": false,
  "properties": {
    "confirmation_token": {
      "anyOf": [
        {
          "maxLength": 4096,
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Token returned by a preview of this exact payload."
    },
    "dry_run": {
      "default": true,
      "description": "Preview safely (default); false requests application.",
      "type": "boolean"
    },
    "table_config": {
      "additionalProperties": {},
      "description": "Complete structured Pinot table configuration.",
      "properties": {
        "ingestionConfig": {
          "anyOf": [
            {
              "additionalProperties": {},
              "type": "object"
            },
            {
              "type": "null"
            }
          ],
          "default": null
        },
        "segmentsConfig": {
          "additionalProperties": {},
          "type": "object"
        },
        "tableIndexConfig": {
          "additionalProperties": {},
          "type": "object"
        },
        "tableName": {
          "maxLength": 128,
          "minLength": 1,
          "pattern": "^(?:[A-Za-z0-9_-]+\\.)?[A-Za-z0-9_-]+$",
          "type": "string"
        },
        "tableType": {
          "enum": [
            "OFFLINE",
            "REALTIME"
          ],
          "type": "string"
        },
        "tenants": {
          "additionalProperties": {},
          "type": "object"
        }
      },
      "required": [
        "tableName",
        "tableType",
        "segmentsConfig",
        "tableIndexConfig"
      ],
      "type": "object"
    }
  },
  "required": [
    "table_config"
  ],
  "type": "object"
}
sha256:8279e7612d04680a10d61d70d6004c2a45edbb898ffb837f3ed63618fe0ca1df

Output schema

{
  "additionalProperties": false,
  "description": "Result of a schema or table-config create/update operation.",
  "properties": {
    "applied": {
      "default": false,
      "description": "True only when Pinot accepted a mutating request.",
      "type": "boolean"
    },
    "confirmation_token": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Short-lived token bound to this exact preview; required to apply it."
    },
    "dry_run": {
      "default": false,
      "description": "True when no mutation was sent to Pinot.",
      "type": "boolean"
    },
    "message": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Human-readable detail, when provided."
    },
    "operation": {
      "description": "Stable operation identifier.",
      "enum": [
        "create_schema",
        "update_schema",
        "create_table",
        "update_table"
      ],
      "type": "string"
    },
    "resource_name": {
      "description": "Exact schema or table name targeted.",
      "type": "string"
    },
    "resource_type": {
      "description": "Kind of Pinot resource targeted by the operation.",
      "enum": [
        "schema",
        "table"
      ],
      "type": "string"
    },
    "response_summary": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Sanitized summary returned by the Pinot controller."
    },
    "status": {
      "default": "success",
      "description": "Whether the operation was previewed, applied, or rejected.",
      "enum": [
        "preview",
        "success",
        "rejected"
      ],
      "type": "string"
    },
    "verification_tool": {
      "description": "Read tool to call after a successful mutation.",
      "enum": [
        "get_schema",
        "get_table_config"
      ],
      "type": "string"
    },
    "warnings": {
      "description": "Safety or validation warnings.",
      "items": {
        "type": "string"
      },
      "type": "array"
    }
  },
  "required": [
    "operation",
    "resource_type",
    "resource_name",
    "verification_tool"
  ],
  "type": "object"
}
sha256:a1b69f42125d3d5beb369a44b6a20ebcbd0626d31fc6734368ec0f99995ac511

Description hash: sha256:649415ffeb8bbbc37898b3477ded740d4f1b2fde876aa24875cf76d4a9c39a64

Interface hash: sha256:022afb6e61070b6a6b0b0a063303aceeefbd4b5365f82308254815fbe080c0cc

Other observed Modelara metadata
{
  "id": "mcp:Pinot MCP Server/create_table_config",
  "title": "Create table config",
  "source": {
    "type": "mcp",
    "server": "Pinot MCP Server",
    "operation": "create_table_config"
  },
  "declared": {
    "read_only": "false",
    "destructive": "false",
    "idempotent": "false",
    "open_world": "true"
  },
  "safety": {
    "idempotent": "false",
    "retry_safe": "false"
  },
  "metadata": {
    "mcp.annotations": "present"
  },
  "fingerprint": "sha256:9501b96873a59afb023e88675ab56b4b8c8b89494b7445f16c87c3a0991ef04e"
}
toolwrite4.0.05.0.0
finish_investigationstartreedata-mcp-pinot:tool:finish_investigation
Observed interface and hashes

Close a run once with authentic citations and an unverified outcome. Choose proposed for an adequately supported candidate association, abstained when adequate evidence shows healthy, unrelated, or confounded observations, and incomplete when missing, sparse, stale, partial, or failed evidence prevents evaluating the association. Complete SQL execution can still yield insufficient observations. Missing matched controls in otherwise adequate observations can reveal confounding and support abstention. Proposed requires a hypothesis; proposed/abstained require complete citations. Incomplete requires a reason. Pending work blocks finishing. These semantic choices are caller judgments; finishing validates ownership, citations, and execution completeness. Evidence sufficiency, the semantic choice, hypotheses, and dataset coverage remain unvalidated. Failure recovery: Correct citation/status errors; a closed run cannot be reused.

Input schema

{
  "additionalProperties": false,
  "properties": {
    "citations": {
      "items": {
        "type": "string"
      },
      "maxItems": 64,
      "type": "array"
    },
    "hypothesis": {
      "anyOf": [
        {
          "additionalProperties": false,
          "description": "Unverified association supplied by a caller, never confirmed as a cause.",
          "properties": {
            "kind": {
              "enum": [
                "deployment",
                "traffic_switch",
                "experiment",
                "environment"
              ],
              "type": "string"
            },
            "service": {
              "anyOf": [
                {
                  "type": "string"
                },
                {
                  "type": "null"
                }
              ],
              "default": null
            },
            "version": {
              "anyOf": [
                {
                  "type": "string"
                },
                {
                  "type": "null"
                }
              ],
              "default": null
            },
            "zone": {
              "anyOf": [
                {
                  "type": "string"
                },
                {
                  "type": "null"
                }
              ],
              "default": null
            }
          },
          "required": [
            "kind"
          ],
          "type": "object"
        },
        {
          "type": "null"
        }
      ],
      "default": null
    },
    "reason": {
      "anyOf": [
        {
          "maxLength": 4096,
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null
    },
    "run_id": {
      "maxLength": 128,
      "minLength": 1,
      "type": "string"
    },
    "status": {
      "default": "proposed",
      "description": "Caller decision: proposed for an adequately supported unverified association; abstained for adequate evidence showing healthy, unrelated, or confounded observations; incomplete when required coverage or samples are missing, sparse, stale, partial, or failed.",
      "enum": [
        "proposed",
        "abstained",
        "incomplete"
      ],
      "type": "string"
    }
  },
  "required": [
    "run_id",
    "citations"
  ],
  "type": "object"
}
sha256:0958bcd055785a9024a2b5a0f12d5fa1f1c04d98f0953582ace0a8fd581f38fa

Output schema

{
  "properties": {
    "citations": {
      "additionalProperties": {
        "type": "string"
      },
      "type": "object"
    },
    "confirmed_cause": {
      "default": false,
      "type": "boolean"
    },
    "dataset_coverage_attested": {
      "default": false,
      "type": "boolean"
    },
    "failed_evidence_ids": {
      "items": {
        "type": "string"
      },
      "type": "array"
    },
    "hypothesis": {
      "anyOf": [
        {
          "additionalProperties": false,
          "description": "Unverified association supplied by a caller, never confirmed as a cause.",
          "properties": {
            "kind": {
              "enum": [
                "deployment",
                "traffic_switch",
                "experiment",
                "environment"
              ],
              "type": "string"
            },
            "service": {
              "anyOf": [
                {
                  "type": "string"
                },
                {
                  "type": "null"
                }
              ],
              "default": null
            },
            "version": {
              "anyOf": [
                {
                  "type": "string"
                },
                {
                  "type": "null"
                }
              ],
              "default": null
            },
            "zone": {
              "anyOf": [
                {
                  "type": "string"
                },
                {
                  "type": "null"
                }
              ],
              "default": null
            }
          },
          "required": [
            "kind"
          ],
          "type": "object"
        },
        {
          "type": "null"
        }
      ]
    },
    "hypothesis_validated": {
      "default": false,
      "type": "boolean"
    },
    "query_count": {
      "type": "integer"
    },
    "reason": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ]
    },
    "run_id": {
      "type": "string"
    },
    "scope": {
      "default": "evidence_assembly_without_rca_semantic_validation",
      "type": "string"
    },
    "status": {
      "enum": [
        "proposed",
        "abstained",
        "incomplete"
      ],
      "type": "string"
    }
  },
  "required": [
    "run_id",
    "status",
    "hypothesis",
    "citations",
    "reason",
    "query_count",
    "failed_evidence_ids"
  ],
  "type": "object"
}
sha256:1f88423f6724433328c5be7286461cfcf3a7150c8880cea2b5b78f890188328c

Description hash: sha256:8eefdb202c587c127286f7da2e14f8eea890c4906dd1c8268b37a6be7f191d85

Interface hash: sha256:e130c6979c535ded75e7acf7a27f5854d8310b3726d7763011661ae6edc74bb2

Other observed Modelara metadata
{
  "id": "mcp:Pinot MCP Server/finish_investigation",
  "title": "Finish investigation",
  "source": {
    "type": "mcp",
    "server": "Pinot MCP Server",
    "operation": "finish_investigation"
  },
  "declared": {
    "read_only": "true",
    "destructive": "unknown",
    "idempotent": "false",
    "open_world": "false"
  },
  "safety": {
    "idempotent": "true",
    "retry_safe": "true"
  },
  "metadata": {
    "mcp.annotations": "present"
  },
  "fingerprint": "sha256:f0955b4be1f87693b97382d830f444cb33b11c10b9cad10ce1dae9616d60f364"
}
toolread5.0.05.0.0
get_schemastartreedata-mcp-pinot:tool:get_schema
Observed interface and hashes

Get one Pinot schema, including dimensions, metrics, time, and primary keys. This is a single-object lookup, not a list, so pagination does not apply. The output preserves additional fields introduced by the connected Pinot version. Failure recovery: For not-found errors, pass the table's exact schema name (normally the table name without a type suffix). Fix permissions before retrying; retry transient controller failures after ``test_connection`` succeeds.

Input schema

{
  "additionalProperties": false,
  "properties": {
    "schema_name": {
      "description": "Exact Pinot schema name. It normally matches the table name without an _OFFLINE/_REALTIME suffix; use letters, digits, hyphens, or underscores, optionally prefixed by one 'database.' qualifier.",
      "maxLength": 128,
      "minLength": 1,
      "pattern": "^(?:[A-Za-z0-9_-]+\\.)?[A-Za-z0-9_-]+$",
      "type": "string"
    }
  },
  "required": [
    "schema_name"
  ],
  "type": "object"
}
sha256:c934a096b1b2d28df9c448fe6b9542beb42a63b90f55903a1d4ff85faaeef86e

Output schema

{
  "additionalProperties": true,
  "description": "A Pinot table schema definition (column field specs).",
  "properties": {
    "dateTimeFieldSpecs": {
      "anyOf": [
        {
          "items": {
            "additionalProperties": true,
            "type": "object"
          },
          "type": "array"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Date/time column specifications."
    },
    "dimensionFieldSpecs": {
      "anyOf": [
        {
          "items": {
            "additionalProperties": true,
            "type": "object"
          },
          "type": "array"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Dimension (attribute) column specifications."
    },
    "metricFieldSpecs": {
      "anyOf": [
        {
          "items": {
            "additionalProperties": true,
            "type": "object"
          },
          "type": "array"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Metric (aggregatable measure) column specifications."
    },
    "primaryKeyColumns": {
      "anyOf": [
        {
          "items": {
            "type": "string"
          },
          "type": "array"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Primary key columns, for upsert-enabled tables."
    },
    "schemaName": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "The schema name."
    }
  },
  "type": "object"
}
sha256:80278d2648be22f3d849822e21d71d394a90507ee31eed84478c93155423fe68

Description hash: sha256:817cb96de433405b8f33182eeaa338921eb5ca7e675cedcf5e652ec6efa289ae

Interface hash: sha256:8deb527077868d9ddebd85dee2fa4b6a9f0b4d2984e400650f062a3aa63a2f52

Other observed Modelara metadata
{
  "id": "mcp:Pinot MCP Server/get_schema",
  "title": "Get schema",
  "source": {
    "type": "mcp",
    "server": "Pinot MCP Server",
    "operation": "get_schema"
  },
  "declared": {
    "read_only": "true",
    "destructive": "unknown",
    "idempotent": "true",
    "open_world": "true"
  },
  "safety": {
    "idempotent": "true",
    "retry_safe": "true"
  },
  "metadata": {
    "mcp.annotations": "present"
  },
  "fingerprint": "sha256:bbb42eac2dc42dda0183ecbcde4c3e08e430f742fc737886a4fc4d5dd0e2179d"
}
toolread4.0.05.0.0
get_segment_index_metadatastartreedata-mcp-pinot:tool:get_segment_index_metadata
Observed interface and hashes

Get per-column index metadata for ONE segment (which indexes each column has). Use this to inspect how a specific segment is indexed (inverted, sorted, range, etc.). Requires a ``segment_name`` from ``list_segments``. For a segment's row count/size/time boundaries use ``list_segment_metadata``; for the table's declared index *configuration* (not per-segment state) use ``get_table_config``. Failure recovery: A missing segment is non-retryable with the same value; refresh ``list_segments`` and use an exact returned name. Retry transient controller errors after ``test_connection`` succeeds.

Input schema

{
  "additionalProperties": false,
  "properties": {
    "segment_name": {
      "description": "Exact, case-sensitive opaque segment name returned by list_segments; do not construct, trim, or add a table-type suffix. Pinot defines the length and characters, so this client only requires non-empty.",
      "maxLength": 1024,
      "minLength": 1,
      "type": "string"
    },
    "table_name": {
      "description": "Exact Pinot table name, without _OFFLINE/_REALTIME. Use letters, digits, hyphens, or underscores, optionally prefixed by one 'database.' qualifier; whitespace is invalid and '__' is reserved by Pinot. Quote hyphenated names in SQL. Names are case-sensitive when that cluster option is enabled.",
      "maxLength": 128,
      "minLength": 1,
      "pattern": "^(?:[A-Za-z0-9_-]+\\.)?[A-Za-z0-9_-]+$",
      "type": "string"
    }
  },
  "required": [
    "table_name",
    "segment_name"
  ],
  "type": "object"
}
sha256:0f22b2a200956009e3390f15c297c8b9b073b7bba1c6d55e153fc3a573eaa1e3

Output schema

{
  "additionalProperties": true,
  "description": "Per-column index metadata for a single segment.",
  "properties": {
    "columns": {
      "default": null,
      "description": "Per-column metadata for the segment, when present.",
      "title": "Columns"
    },
    "indexes": {
      "default": null,
      "description": "Per-column index metadata (index types present on each column).",
      "title": "Indexes"
    }
  },
  "type": "object"
}
sha256:29d69a72436f8656feb28124dc0d9433d4ed5b1fab29428ddf1f3f9c7565d759

Description hash: sha256:1a1201b8ee74e504a13a4f07d9a9f3cc032dc1543b2c349743299be9be0ecbf2

Interface hash: sha256:7a3a7cd4f03bcc468c97e66dcabe4a77e55dbf42809ff865958f056f5fef094b

Other observed Modelara metadata
{
  "id": "mcp:Pinot MCP Server/get_segment_index_metadata",
  "title": "Index/column details",
  "source": {
    "type": "mcp",
    "server": "Pinot MCP Server",
    "operation": "get_segment_index_metadata"
  },
  "declared": {
    "read_only": "true",
    "destructive": "unknown",
    "idempotent": "true",
    "open_world": "true"
  },
  "safety": {
    "idempotent": "true",
    "retry_safe": "true"
  },
  "metadata": {
    "mcp.annotations": "present"
  },
  "fingerprint": "sha256:677f845c966522cd5d73feb05722b994191e78190e2b06875d78cf9f51e3c783"
}
toolread4.0.05.0.0
get_table_configstartreedata-mcp-pinot:tool:get_table_config
Observed interface and hashes

Get one table's indexing, retention, tenant, and ingestion configuration. This is a single-object lookup, not a list, so pagination does not apply. Set ``table_type`` only when one side of a hybrid table is needed. Failure recovery: For not-found errors, use an exact name from ``list_tables`` and a valid table type. Fix permissions before retrying; retry transient controller failures after ``test_connection`` succeeds.

Input schema

{
  "additionalProperties": false,
  "properties": {
    "table_name": {
      "description": "Exact Pinot table name, without _OFFLINE/_REALTIME. Use letters, digits, hyphens, or underscores, optionally prefixed by one 'database.' qualifier; whitespace is invalid and '__' is reserved by Pinot. Quote hyphenated names in SQL. Names are case-sensitive when that cluster option is enabled.",
      "maxLength": 128,
      "minLength": 1,
      "pattern": "^(?:[A-Za-z0-9_-]+\\.)?[A-Za-z0-9_-]+$",
      "type": "string"
    },
    "table_type": {
      "anyOf": [
        {
          "enum": [
            "OFFLINE",
            "REALTIME"
          ],
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Restrict to one table type; omit to return both when present."
    }
  },
  "required": [
    "table_name"
  ],
  "type": "object"
}
sha256:125c4da1d95a130456e44af9783c5c3ef80eab6fc5a62e3716961d1334fd509d

Output schema

{
  "description": "Canonical shape for one-sided and hybrid Pinot table configurations.",
  "properties": {
    "offline": {
      "anyOf": [
        {
          "additionalProperties": true,
          "description": "A Pinot table configuration (``GET /tables/{name}``).",
          "properties": {
            "ingestionConfig": {
              "anyOf": [
                {
                  "additionalProperties": true,
                  "type": "object"
                },
                {
                  "type": "null"
                }
              ],
              "default": null,
              "description": "Ingestion / transform configuration, when present."
            },
            "segmentsConfig": {
              "anyOf": [
                {
                  "additionalProperties": true,
                  "type": "object"
                },
                {
                  "type": "null"
                }
              ],
              "default": null,
              "description": "Retention, replication, and time-column settings."
            },
            "tableIndexConfig": {
              "anyOf": [
                {
                  "additionalProperties": true,
                  "type": "object"
                },
                {
                  "type": "null"
                }
              ],
              "default": null,
              "description": "Index configuration (inverted, sorted, range, ...)."
            },
            "tableName": {
              "anyOf": [
                {
                  "type": "string"
                },
                {
                  "type": "null"
                }
              ],
              "default": null,
              "description": "The table name."
            },
            "tableType": {
              "anyOf": [
                {
                  "type": "string"
                },
                {
                  "type": "null"
                }
              ],
              "default": null,
              "description": "Table type: 'OFFLINE' or 'REALTIME'."
            },
            "tenants": {
              "anyOf": [
                {
                  "additionalProperties": true,
                  "type": "object"
                },
                {
                  "type": "null"
                }
              ],
              "default": null,
              "description": "Broker and server tenant assignment."
            }
          },
          "type": "object"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "OFFLINE configuration, when present/requested."
    },
    "realtime": {
      "anyOf": [
        {
          "additionalProperties": true,
          "description": "A Pinot table configuration (``GET /tables/{name}``).",
          "properties": {
            "ingestionConfig": {
              "anyOf": [
                {
                  "additionalProperties": true,
                  "type": "object"
                },
                {
                  "type": "null"
                }
              ],
              "default": null,
              "description": "Ingestion / transform configuration, when present."
            },
            "segmentsConfig": {
              "anyOf": [
                {
                  "additionalProperties": true,
                  "type": "object"
                },
                {
                  "type": "null"
                }
              ],
              "default": null,
              "description": "Retention, replication, and time-column settings."
            },
            "tableIndexConfig": {
              "anyOf": [
                {
                  "additionalProperties": true,
                  "type": "object"
                },
                {
                  "type": "null"
                }
              ],
              "default": null,
              "description": "Index configuration (inverted, sorted, range, ...)."
            },
            "tableName": {
              "anyOf": [
                {
                  "type": "string"
                },
                {
                  "type": "null"
                }
              ],
              "default": null,
              "description": "The table name."
            },
            "tableType": {
              "anyOf": [
                {
                  "type": "string"
                },
                {
                  "type": "null"
                }
              ],
              "default": null,
              "description": "Table type: 'OFFLINE' or 'REALTIME'."
            },
            "tenants": {
              "anyOf": [
                {
                  "additionalProperties": true,
                  "type": "object"
                },
                {
                  "type": "null"
                }
              ],
              "default": null,
              "description": "Broker and server tenant assignment."
            }
          },
          "type": "object"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "REALTIME configuration, when present/requested."
    },
    "table_name": {
      "description": "Base table name requested by the caller.",
      "type": "string"
    }
  },
  "required": [
    "table_name"
  ],
  "type": "object"
}
sha256:e5f61dffbb555564228473a3d7bbfb0800e2b3ec9e12cd98a9b06124f37be672

Description hash: sha256:08609b34fe0b55ba15ec5d2d9ec58479a64824a6af9258127cc3d3a7ce5e2b83

Interface hash: sha256:ec6a6b97b773a5038ef02fa77fda967176ac6bc905f971b94f56f6dcbfc7b242

Other observed Modelara metadata
{
  "id": "mcp:Pinot MCP Server/get_table_config",
  "title": "Get table config",
  "source": {
    "type": "mcp",
    "server": "Pinot MCP Server",
    "operation": "get_table_config"
  },
  "declared": {
    "read_only": "true",
    "destructive": "unknown",
    "idempotent": "true",
    "open_world": "true"
  },
  "safety": {
    "idempotent": "true",
    "retry_safe": "true"
  },
  "metadata": {
    "mcp.annotations": "present"
  },
  "fingerprint": "sha256:6d4bf9d069dc397f37afa552eb41267e7725ef397a539ba0898b1b2c4557fde1"
}
toolread4.0.05.0.0
get_table_sizestartreedata-mcp-pinot:tool:get_table_size
Observed interface and hashes

Get a table's storage footprint: reported vs. estimated size in bytes. Use this for capacity/size questions about a whole table. It does NOT list segments (use ``list_segments``) or return row counts/time boundaries (use ``list_segment_metadata``). ``reportedSizeInBytes`` is what the servers currently hosting the segments report; ``estimatedSizeInBytes`` assumes every replica is present. Failure recovery: For not-found errors, copy an exact name from ``list_tables``. Fix permission errors before retrying; retry transient controller failures after a health check.

Input schema

{
  "additionalProperties": false,
  "properties": {
    "table_name": {
      "description": "Exact Pinot table name, without _OFFLINE/_REALTIME. Use letters, digits, hyphens, or underscores, optionally prefixed by one 'database.' qualifier; whitespace is invalid and '__' is reserved by Pinot. Quote hyphenated names in SQL. Names are case-sensitive when that cluster option is enabled.",
      "maxLength": 128,
      "minLength": 1,
      "pattern": "^(?:[A-Za-z0-9_-]+\\.)?[A-Za-z0-9_-]+$",
      "type": "string"
    }
  },
  "required": [
    "table_name"
  ],
  "type": "object"
}
sha256:0256e05eb420472dc0957050c35a7c59c5af11a4a6fdd4b0fab564b821760567

Output schema

{
  "additionalProperties": true,
  "description": "Storage size for a table (Pinot ``GET /tables/{name}/size``).\n\nDeclared fields document the common size metrics; any additional fields Pinot\nreturns (per-segment breakdowns, etc.) are preserved.",
  "properties": {
    "estimatedSizeInBytes": {
      "anyOf": [
        {
          "type": "integer"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Estimated size assuming every replica is present, in bytes."
    },
    "reportedSizeInBytes": {
      "anyOf": [
        {
          "type": "integer"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Size reported by the servers currently hosting the table's segments, in bytes."
    },
    "tableName": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "The table name."
    }
  },
  "type": "object"
}
sha256:9602a0818305d4b84b7d5206d848cce50877c3127d3c18d84261d72b98135675

Description hash: sha256:aef99e7ca07331d261b40ecf4babe4cb3722c366d26e2bc97e5c13dacc08d67d

Interface hash: sha256:9112eaf3c4eda0e6feb8d94c77b3fbb8fc5ac32deb6194cacbb8f40c9d7e744f

Other observed Modelara metadata
{
  "id": "mcp:Pinot MCP Server/get_table_size",
  "title": "Table size details",
  "source": {
    "type": "mcp",
    "server": "Pinot MCP Server",
    "operation": "get_table_size"
  },
  "declared": {
    "read_only": "true",
    "destructive": "unknown",
    "idempotent": "true",
    "open_world": "true"
  },
  "safety": {
    "idempotent": "true",
    "retry_safe": "true"
  },
  "metadata": {
    "mcp.annotations": "present"
  },
  "fingerprint": "sha256:9b5849fc21e61ae60503825c47b65bca9cc503a05f8cbb52bea7e0d57528c9e4"
}
toolread4.0.05.0.0
get_tracestartreedata-mcp-pinot:tool:get_trace
Observed interface and hashes

Retrieve scoped trace rows with actual span and parent-span identifiers. Configure both span columns in the server profile. This fetches recorded relationships and does not infer causality or validate instrumentation coverage. Failure recovery: Use an exact scoped trace ID; inspect completeness before citing.

Input schema

{
  "additionalProperties": false,
  "properties": {
    "run_id": {
      "maxLength": 128,
      "minLength": 1,
      "type": "string"
    },
    "trace_id": {
      "maxLength": 256,
      "minLength": 1,
      "type": "string"
    }
  },
  "required": [
    "run_id",
    "trace_id"
  ],
  "type": "object"
}
sha256:cd031502e65ea53c2ff26463d480245662d3a9368460ab6aace9bc88aeb0a780

Output schema

{
  "properties": {
    "columns": {
      "items": {
        "type": "string"
      },
      "type": "array"
    },
    "complete": {
      "default": false,
      "type": "boolean"
    },
    "dataset_coverage_attested": {
      "default": false,
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null
    },
    "evidence_id": {
      "type": "string"
    },
    "kind": {
      "type": "string"
    },
    "metadata": {
      "description": "Native execution evidence, independently of paging or dataset coverage.",
      "properties": {
        "completeness": {
          "default": "unknown",
          "enum": [
            "complete",
            "partial",
            "unknown"
          ],
          "type": "string"
        },
        "early_termination_reasons": {
          "items": {
            "enum": [
              "DISTINCT_MAX_ROWS",
              "DISTINCT_MAX_ROWS_WITHOUT_CHANGE",
              "DISTINCT_MAX_EXECUTION_TIME",
              "UNRECOGNIZED_NATIVE_REASON"
            ],
            "type": "string"
          },
          "maxItems": 4,
          "type": "array"
        },
        "execution_limit_flags": {
          "additionalProperties": {
            "type": "boolean"
          },
          "maxProperties": 7,
          "propertyNames": {
            "enum": [
              "numGroupsLimitReached",
              "maxRowsInJoinReached",
              "maxRowsInWindowReached",
              "mseLiteLeafStageLimitReached",
              "maxRowsInDistinctReached",
              "maxRowsWithoutChangeInDistinctReached",
              "maxExecutionTimeInDistinctReached"
            ]
          },
          "type": "object"
        },
        "execution_limit_reached": {
          "anyOf": [
            {
              "type": "boolean"
            },
            {
              "type": "null"
            }
          ],
          "default": null,
          "description": "Any reported native execution limit or early termination."
        },
        "native_query_id": {
          "anyOf": [
            {
              "type": "integer"
            },
            {
              "type": "string"
            },
            {
              "type": "null"
            }
          ],
          "default": null
        },
        "native_stats": {
          "additionalProperties": {
            "anyOf": [
              {
                "type": "integer"
              },
              {
                "type": "number"
              }
            ]
          },
          "maxProperties": 32,
          "type": "object"
        },
        "partial_result": {
          "anyOf": [
            {
              "type": "boolean"
            },
            {
              "type": "null"
            }
          ],
          "default": null
        },
        "query_sha256": {
          "anyOf": [
            {
              "pattern": "^[0-9a-f]{64}$",
              "type": "string"
            },
            {
              "type": "null"
            }
          ],
          "default": null
        },
        "request_id": {
          "anyOf": [
            {
              "type": "string"
            },
            {
              "type": "null"
            }
          ],
          "default": null
        },
        "row_limit_reached": {
          "default": false,
          "description": "The bounded SQL returned its row limit; not proof of more rows.",
          "type": "boolean"
        },
        "servers_queried": {
          "anyOf": [
            {
              "minimum": 0,
              "type": "integer"
            },
            {
              "type": "null"
            }
          ],
          "default": null
        },
        "servers_responded": {
          "anyOf": [
            {
              "minimum": 0,
              "type": "integer"
            },
            {
              "type": "null"
            }
          ],
          "default": null
        },
        "unknown_reasons": {
          "items": {
            "type": "string"
          },
          "type": "array"
        }
      },
      "type": "object"
    },
    "rows": {
      "items": {
        "additionalProperties": true,
        "type": "object"
      },
      "type": "array"
    },
    "run_id": {
      "type": "string"
    },
    "sha256": {
      "default": "",
      "type": "string"
    },
    "sql": {
      "type": "string"
    }
  },
  "required": [
    "evidence_id",
    "run_id",
    "kind",
    "sql"
  ],
  "type": "object"
}
sha256:1d300453ebb4e0e450a7f5bca955a522708ee5e109074efd3ef8845320ae2e4e

Description hash: sha256:780afc32921a30d07d84b194b3e92c2de84f984ea29ca22def459c1f1608b12d

Interface hash: sha256:39fddef58d15e2cb36a5057c843ab59ca146788cbe3971f59c9ff4645c6651ae

Other observed Modelara metadata
{
  "id": "mcp:Pinot MCP Server/get_trace",
  "title": "Get trace",
  "source": {
    "type": "mcp",
    "server": "Pinot MCP Server",
    "operation": "get_trace"
  },
  "declared": {
    "read_only": "true",
    "destructive": "unknown",
    "idempotent": "false",
    "open_world": "true"
  },
  "safety": {
    "idempotent": "true",
    "retry_safe": "true"
  },
  "metadata": {
    "mcp.annotations": "present"
  },
  "fingerprint": "sha256:1a36c053310cdc4b13d8d4a59ca3124648cdfd925875c46ef5ab1a614610f5b4"
}
toolread5.0.05.0.0
list_segment_metadatastartreedata-mcp-pinot:tool:list_segment_metadata
Observed interface and hashes

Get a deterministic page of segment rows, sizes, and time boundaries. Pinot can return thousands of segment objects. Results are sorted by exact segment name, then sliced with ``limit``/``offset``; follow ``has_more`` until false. Use ``list_segments`` when only names are needed. Failure recovery: An empty page is success. For not-found errors, use ``list_tables``; correct permissions before retrying, and retry transient server failures only after ``test_connection`` succeeds.

Input schema

{
  "additionalProperties": false,
  "properties": {
    "limit": {
      "default": 100,
      "description": "Maximum segment metadata objects in this page.",
      "maximum": 500,
      "minimum": 1,
      "type": "integer"
    },
    "offset": {
      "default": 0,
      "description": "Zero-based segment offset for pagination.",
      "maximum": 10000,
      "minimum": 0,
      "type": "integer"
    },
    "table_name": {
      "description": "Exact Pinot table name, without _OFFLINE/_REALTIME. Use letters, digits, hyphens, or underscores, optionally prefixed by one 'database.' qualifier; whitespace is invalid and '__' is reserved by Pinot. Quote hyphenated names in SQL. Names are case-sensitive when that cluster option is enabled.",
      "maxLength": 128,
      "minLength": 1,
      "pattern": "^(?:[A-Za-z0-9_-]+\\.)?[A-Za-z0-9_-]+$",
      "type": "string"
    }
  },
  "required": [
    "table_name"
  ],
  "type": "object"
}
sha256:2061de52db0b1e8836cfe14a2b55fd8adc8c0d77f1614c486431d36411fd27a1

Output schema

{
  "description": "A deterministic page of segment metadata for one Pinot table.",
  "properties": {
    "has_more": {
      "description": "True when more fetched segment metadata remains after this page.",
      "type": "boolean"
    },
    "offset": {
      "description": "Zero-based index of the first returned segment.",
      "type": "integer"
    },
    "returned_segments": {
      "description": "Number of segment metadata objects in this page.",
      "type": "integer"
    },
    "segments": {
      "additionalProperties": true,
      "description": "Metadata keyed by exact segment name. Values can include row counts, sizes, time boundaries, and column/index details returned by Pinot.",
      "type": "object"
    },
    "total_segments": {
      "description": "Total segment metadata objects fetched before paging.",
      "type": "integer"
    }
  },
  "required": [
    "returned_segments",
    "total_segments",
    "offset",
    "has_more"
  ],
  "type": "object"
}
sha256:29f6a9239c498ad98e1bb4ad6df37bce8a8518a0a79ffd29a8bb63ddca7d0a9b

Description hash: sha256:e328e8dfce2fea2d5116d59b807c85b4542d015e903c725fb5b42095e443ee69

Interface hash: sha256:96f0b989fd9ce84e0da5ff03c4bedd97d3564e5e8f93f3cbd8badcbf427608da

Other observed Modelara metadata
{
  "id": "mcp:Pinot MCP Server/list_segment_metadata",
  "title": "Segment metadata",
  "source": {
    "type": "mcp",
    "server": "Pinot MCP Server",
    "operation": "list_segment_metadata"
  },
  "declared": {
    "read_only": "true",
    "destructive": "unknown",
    "idempotent": "true",
    "open_world": "true"
  },
  "safety": {
    "idempotent": "true",
    "retry_safe": "true"
  },
  "metadata": {
    "mcp.annotations": "present"
  },
  "fingerprint": "sha256:6335ed2b9e0ad8d776694af648da5ed600a144fd5bf4c65b5a9e4cb18056e1b9"
}
toolread4.0.05.0.0
list_segmentsstartreedata-mcp-pinot:tool:list_segments
Observed interface and hashes

List a table's segment names, grouped by table type (OFFLINE/REALTIME). Use this to discover segment names — e.g. to get a ``segment_name`` for ``get_segment_index_metadata``, or to see how a table is partitioned. For per-segment row counts / sizes / time boundaries call ``list_segment_metadata`` instead; for total storage call ``get_table_size``. Segment names are paginated (a busy table can have thousands) — use ``limit``/``offset`` and the ``has_more`` flag to page through them. Failure recovery: An empty page is success. For not-found errors, use an exact name from ``list_tables``; correct access errors, or retry transient controller errors.

Input schema

{
  "additionalProperties": false,
  "properties": {
    "limit": {
      "default": 100,
      "description": "Maximum segment names to return in this page.",
      "maximum": 500,
      "minimum": 1,
      "type": "integer"
    },
    "offset": {
      "default": 0,
      "description": "Zero-based offset for pagination.",
      "maximum": 10000,
      "minimum": 0,
      "type": "integer"
    },
    "table_name": {
      "description": "Exact Pinot table name, without _OFFLINE/_REALTIME. Use letters, digits, hyphens, or underscores, optionally prefixed by one 'database.' qualifier; whitespace is invalid and '__' is reserved by Pinot. Quote hyphenated names in SQL. Names are case-sensitive when that cluster option is enabled.",
      "maxLength": 128,
      "minLength": 1,
      "pattern": "^(?:[A-Za-z0-9_-]+\\.)?[A-Za-z0-9_-]+$",
      "type": "string"
    }
  },
  "required": [
    "table_name"
  ],
  "type": "object"
}
sha256:969a1c27d834b59e2d2f282b7ac54610f8469c4676b0013a95b38b36281ef5b8

Output schema

{
  "additionalProperties": true,
  "description": "Segment names for a table, grouped by table type.",
  "properties": {
    "OFFLINE": {
      "anyOf": [
        {
          "items": {
            "type": "string"
          },
          "type": "array"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "OFFLINE segment names in this page, when present."
    },
    "REALTIME": {
      "anyOf": [
        {
          "items": {
            "type": "string"
          },
          "type": "array"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "REALTIME segment names in this page, when present."
    },
    "has_more": {
      "anyOf": [
        {
          "type": "boolean"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "True when more segments remain beyond this page."
    },
    "offset": {
      "anyOf": [
        {
          "type": "integer"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Zero-based offset of the first segment in this page."
    },
    "returned_segments": {
      "anyOf": [
        {
          "type": "integer"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Number of segment names returned in this page."
    },
    "total_segments": {
      "anyOf": [
        {
          "type": "integer"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Total segments across all types before paging."
    }
  },
  "type": "object"
}
sha256:edae822623d44b9763770fdafbee0de8492af2c96b9d43712d33ee00464d3edc

Description hash: sha256:930bc71dab62b6bbccdf1a1a44794ad9d1452a88afc8d5d4e38f28c0cde95763

Interface hash: sha256:7e8fbf2a0f90d0bef75618e0fa5b8594282267f2cdff9555b2215986a6f63d7e

Other observed Modelara metadata
{
  "id": "mcp:Pinot MCP Server/list_segments",
  "title": "List segments",
  "source": {
    "type": "mcp",
    "server": "Pinot MCP Server",
    "operation": "list_segments"
  },
  "declared": {
    "read_only": "true",
    "destructive": "unknown",
    "idempotent": "true",
    "open_world": "true"
  },
  "safety": {
    "idempotent": "true",
    "retry_safe": "true"
  },
  "metadata": {
    "mcp.annotations": "present"
  },
  "fingerprint": "sha256:e818b5afe8ce2dfe267a1ab9c69ede214c687d4c733e3b9ecd95ac036a49d656"
}
toolread4.0.05.0.0
list_tablesstartreedata-mcp-pinot:tool:list_tables
Observed interface and hashes

List Pinot tables visible to this server (subject to table filters). Returns a paginated list of table names. Use ``limit``/``offset`` and the ``has_more`` flag to page through clusters with many tables. Failure recovery: An empty page is success. For authentication/connectivity errors, verify the controller with ``test_connection`` and retry after access is restored.

Input schema

{
  "additionalProperties": false,
  "properties": {
    "limit": {
      "default": 100,
      "description": "Maximum tables to return in this page.",
      "maximum": 500,
      "minimum": 1,
      "type": "integer"
    },
    "offset": {
      "default": 0,
      "description": "Zero-based offset for pagination.",
      "maximum": 10000,
      "minimum": 0,
      "type": "integer"
    }
  },
  "type": "object"
}
sha256:a6e18970fcfe5705962afb5a7c8a1cd599819d133ac34b227fd22ac391a00eb1

Output schema

{
  "description": "A page of Pinot table names visible to this server.",
  "properties": {
    "has_more": {
      "description": "True when more tables remain beyond this page.",
      "type": "boolean"
    },
    "offset": {
      "description": "Zero-based index of the first returned table.",
      "type": "integer"
    },
    "table_count": {
      "description": "Number of tables in this page.",
      "type": "integer"
    },
    "tables": {
      "description": "Table names in this page.",
      "items": {
        "type": "string"
      },
      "type": "array"
    },
    "total_tables": {
      "description": "Total tables visible to this server.",
      "type": "integer"
    }
  },
  "required": [
    "table_count",
    "total_tables",
    "offset",
    "has_more"
  ],
  "type": "object"
}
sha256:c7f83bf44e4372c049c51605874a0dd5f79484b385243aa1b506dafa73a980e8

Description hash: sha256:86df6f88b6a41fc0b120ec92a22f6a3e06a7c183b05f13611cf3abb33c4bd56e

Interface hash: sha256:150ab3f685cfd44fe3914a55d1a4bd3590d59fdf40cdbd774b9f73ec7cf782ea

Other observed Modelara metadata
{
  "id": "mcp:Pinot MCP Server/list_tables",
  "title": "List tables",
  "source": {
    "type": "mcp",
    "server": "Pinot MCP Server",
    "operation": "list_tables"
  },
  "declared": {
    "read_only": "true",
    "destructive": "unknown",
    "idempotent": "true",
    "open_world": "true"
  },
  "safety": {
    "idempotent": "true",
    "retry_safe": "true"
  },
  "metadata": {
    "mcp.annotations": "present"
  },
  "fingerprint": "sha256:04cd5aed3881f161038b6947a04a43c081a46da1d0eaca9f90989cd0bdd42d43"
}
toolread4.0.05.0.0
query_incidentstartreedata-mcp-pinot:tool:query_incident
Observed interface and hashes

Collect bounded evidence with fixed tenant/time predicates and citations. The server generates SQL for the selected kind. Candidate filters apply only to onset queries. Failed, unknown, partial, truncated, or late execution is retained as incomplete evidence; it cannot support a qualified finish. Failure recovery: Query attempts consume budget even on failure. Inspect evidence before retrying.

Input schema

{
  "additionalProperties": false,
  "properties": {
    "candidate": {
      "anyOf": [
        {
          "additionalProperties": false,
          "description": "Unverified association supplied by a caller, never confirmed as a cause.",
          "properties": {
            "kind": {
              "enum": [
                "deployment",
                "traffic_switch",
                "experiment",
                "environment"
              ],
              "type": "string"
            },
            "service": {
              "anyOf": [
                {
                  "type": "string"
                },
                {
                  "type": "null"
                }
              ],
              "default": null
            },
            "version": {
              "anyOf": [
                {
                  "type": "string"
                },
                {
                  "type": "null"
                }
              ],
              "default": null
            },
            "zone": {
              "anyOf": [
                {
                  "type": "string"
                },
                {
                  "type": "null"
                }
              ],
              "default": null
            }
          },
          "required": [
            "kind"
          ],
          "type": "object"
        },
        {
          "type": "null"
        }
      ],
      "default": null
    },
    "kind": {
      "enum": [
        "baseline",
        "incident",
        "watermark",
        "changes",
        "onset"
      ],
      "type": "string"
    },
    "run_id": {
      "maxLength": 128,
      "minLength": 1,
      "type": "string"
    }
  },
  "required": [
    "run_id",
    "kind"
  ],
  "type": "object"
}
sha256:9f063b5f0c60297b4e40ed2c134350d38b1ea6fe206d333b8eb66e5bc1c4c588

Output schema

{
  "properties": {
    "columns": {
      "items": {
        "type": "string"
      },
      "type": "array"
    },
    "complete": {
      "default": false,
      "type": "boolean"
    },
    "dataset_coverage_attested": {
      "default": false,
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null
    },
    "evidence_id": {
      "type": "string"
    },
    "kind": {
      "type": "string"
    },
    "metadata": {
      "description": "Native execution evidence, independently of paging or dataset coverage.",
      "properties": {
        "completeness": {
          "default": "unknown",
          "enum": [
            "complete",
            "partial",
            "unknown"
          ],
          "type": "string"
        },
        "early_termination_reasons": {
          "items": {
            "enum": [
              "DISTINCT_MAX_ROWS",
              "DISTINCT_MAX_ROWS_WITHOUT_CHANGE",
              "DISTINCT_MAX_EXECUTION_TIME",
              "UNRECOGNIZED_NATIVE_REASON"
            ],
            "type": "string"
          },
          "maxItems": 4,
          "type": "array"
        },
        "execution_limit_flags": {
          "additionalProperties": {
            "type": "boolean"
          },
          "maxProperties": 7,
          "propertyNames": {
            "enum": [
              "numGroupsLimitReached",
              "maxRowsInJoinReached",
              "maxRowsInWindowReached",
              "mseLiteLeafStageLimitReached",
              "maxRowsInDistinctReached",
              "maxRowsWithoutChangeInDistinctReached",
              "maxExecutionTimeInDistinctReached"
            ]
          },
          "type": "object"
        },
        "execution_limit_reached": {
          "anyOf": [
            {
              "type": "boolean"
            },
            {
              "type": "null"
            }
          ],
          "default": null,
          "description": "Any reported native execution limit or early termination."
        },
        "native_query_id": {
          "anyOf": [
            {
              "type": "integer"
            },
            {
              "type": "string"
            },
            {
              "type": "null"
            }
          ],
          "default": null
        },
        "native_stats": {
          "additionalProperties": {
            "anyOf": [
              {
                "type": "integer"
              },
              {
                "type": "number"
              }
            ]
          },
          "maxProperties": 32,
          "type": "object"
        },
        "partial_result": {
          "anyOf": [
            {
              "type": "boolean"
            },
            {
              "type": "null"
            }
          ],
          "default": null
        },
        "query_sha256": {
          "anyOf": [
            {
              "pattern": "^[0-9a-f]{64}$",
              "type": "string"
            },
            {
              "type": "null"
            }
          ],
          "default": null
        },
        "request_id": {
          "anyOf": [
            {
              "type": "string"
            },
            {
              "type": "null"
            }
          ],
          "default": null
        },
        "row_limit_reached": {
          "default": false,
          "description": "The bounded SQL returned its row limit; not proof of more rows.",
          "type": "boolean"
        },
        "servers_queried": {
          "anyOf": [
            {
              "minimum": 0,
              "type": "integer"
            },
            {
              "type": "null"
            }
          ],
          "default": null
        },
        "servers_responded": {
          "anyOf": [
            {
              "minimum": 0,
              "type": "integer"
            },
            {
              "type": "null"
            }
          ],
          "default": null
        },
        "unknown_reasons": {
          "items": {
            "type": "string"
          },
          "type": "array"
        }
      },
      "type": "object"
    },
    "rows": {
      "items": {
        "additionalProperties": true,
        "type": "object"
      },
      "type": "array"
    },
    "run_id": {
      "type": "string"
    },
    "sha256": {
      "default": "",
      "type": "string"
    },
    "sql": {
      "type": "string"
    }
  },
  "required": [
    "evidence_id",
    "run_id",
    "kind",
    "sql"
  ],
  "type": "object"
}
sha256:1d300453ebb4e0e450a7f5bca955a522708ee5e109074efd3ef8845320ae2e4e

Description hash: sha256:e4fd764fa137ed4c61edf8f9fb0603b89079609fb9345fd1529c6b516fd7b045

Interface hash: sha256:ad5c1fee32ad97fd92a5b56eb987f0f801da367d5771205615ab51ccba3ec1fb

Other observed Modelara metadata
{
  "id": "mcp:Pinot MCP Server/query_incident",
  "title": "Query incident",
  "source": {
    "type": "mcp",
    "server": "Pinot MCP Server",
    "operation": "query_incident"
  },
  "declared": {
    "read_only": "true",
    "destructive": "unknown",
    "idempotent": "false",
    "open_world": "true"
  },
  "safety": {
    "idempotent": "true",
    "retry_safe": "true"
  },
  "metadata": {
    "mcp.annotations": "present"
  },
  "fingerprint": "sha256:a6f73c4de111468f16612cecb6f370db40a04b375cab0a127e617c5b8b03695f"
}
toolread5.0.05.0.0
read_querystartreedata-mcp-pinot:tool:read_query
Observed interface and hashes

Run a read-only SQL query against Pinot and return a page of rows. Only a single SELECT (or WITH ... SELECT) statement is allowed; the query is rejected if it contains multiple statements or write/DDL/admin keywords. Results are paginated to keep responses small — use ``limit``/``offset`` and the ``has_more`` flag to page through large result sets. Returns ``QueryResult`` with the page of rows, the column list, fetched row count, a ``has_more`` flag, and native execution metadata. Missing native metadata is unknown; complete execution does not establish dataset coverage. Failure recovery: SQL/allow-list/permission failures require correcting the query or access; do not retry unchanged. A timeout or connection failure can be retried after ``test_connection`` succeeds. Check ``metadata.completeness`` even for zero rows; no response is promoted to healthy empty evidence.

Input schema

{
  "additionalProperties": false,
  "properties": {
    "limit": {
      "default": 100,
      "description": "Maximum rows to return in this page.",
      "maximum": 500,
      "minimum": 1,
      "type": "integer"
    },
    "offset": {
      "default": 0,
      "description": "Zero-based row offset for pagination.",
      "maximum": 10000,
      "minimum": 0,
      "type": "integer"
    },
    "query": {
      "description": "A single read-only statement in Pinot SQL: 'SELECT ...' or 'WITH ... SELECT ...'. Stacked statements and DML/DDL/admin keywords (INSERT, UPDATE, DELETE, DROP, SET, ...) are rejected.",
      "maxLength": 20000,
      "minLength": 1,
      "type": "string"
    }
  },
  "required": [
    "query"
  ],
  "type": "object"
}
sha256:68838f59b806b5d24bce8753df1df7d63db6dcfc99e0cbebc762d6e92f546e90

Output schema

{
  "description": "A page of rows produced by a read-only SQL query.",
  "properties": {
    "columns": {
      "description": "Column names, in result order.",
      "items": {
        "type": "string"
      },
      "type": "array"
    },
    "has_more": {
      "description": "True when more fetched rows remain beyond this page (not necessarily more rows in the underlying table).",
      "type": "boolean"
    },
    "metadata": {
      "description": "Execution evidence; complete execution does not imply dataset coverage.",
      "properties": {
        "completeness": {
          "default": "unknown",
          "enum": [
            "complete",
            "partial",
            "unknown"
          ],
          "type": "string"
        },
        "early_termination_reasons": {
          "items": {
            "enum": [
              "DISTINCT_MAX_ROWS",
              "DISTINCT_MAX_ROWS_WITHOUT_CHANGE",
              "DISTINCT_MAX_EXECUTION_TIME",
              "UNRECOGNIZED_NATIVE_REASON"
            ],
            "type": "string"
          },
          "maxItems": 4,
          "type": "array"
        },
        "execution_limit_flags": {
          "additionalProperties": {
            "type": "boolean"
          },
          "maxProperties": 7,
          "propertyNames": {
            "enum": [
              "numGroupsLimitReached",
              "maxRowsInJoinReached",
              "maxRowsInWindowReached",
              "mseLiteLeafStageLimitReached",
              "maxRowsInDistinctReached",
              "maxRowsWithoutChangeInDistinctReached",
              "maxExecutionTimeInDistinctReached"
            ]
          },
          "type": "object"
        },
        "execution_limit_reached": {
          "anyOf": [
            {
              "type": "boolean"
            },
            {
              "type": "null"
            }
          ],
          "default": null,
          "description": "Any reported native execution limit or early termination."
        },
        "native_query_id": {
          "anyOf": [
            {
              "type": "integer"
            },
            {
              "type": "string"
            },
            {
              "type": "null"
            }
          ],
          "default": null
        },
        "native_stats": {
          "additionalProperties": {
            "anyOf": [
              {
                "type": "integer"
              },
              {
                "type": "number"
              }
            ]
          },
          "maxProperties": 32,
          "type": "object"
        },
        "partial_result": {
          "anyOf": [
            {
              "type": "boolean"
            },
            {
              "type": "null"
            }
          ],
          "default": null
        },
        "query_sha256": {
          "anyOf": [
            {
              "pattern": "^[0-9a-f]{64}$",
              "type": "string"
            },
            {
              "type": "null"
            }
          ],
          "default": null
        },
        "request_id": {
          "anyOf": [
            {
              "type": "string"
            },
            {
              "type": "null"
            }
          ],
          "default": null
        },
        "row_limit_reached": {
          "default": false,
          "description": "The bounded SQL returned its row limit; not proof of more rows.",
          "type": "boolean"
        },
        "servers_queried": {
          "anyOf": [
            {
              "minimum": 0,
              "type": "integer"
            },
            {
              "type": "null"
            }
          ],
          "default": null
        },
        "servers_responded": {
          "anyOf": [
            {
              "minimum": 0,
              "type": "integer"
            },
            {
              "type": "null"
            }
          ],
          "default": null
        },
        "unknown_reasons": {
          "items": {
            "type": "string"
          },
          "type": "array"
        }
      },
      "type": "object"
    },
    "offset": {
      "description": "Zero-based index of the first returned row.",
      "type": "integer"
    },
    "row_count": {
      "description": "Number of rows returned in this page.",
      "type": "integer"
    },
    "rows": {
      "description": "Rows in this page; each row maps column name to value.",
      "items": {
        "additionalProperties": true,
        "type": "object"
      },
      "type": "array"
    },
    "total_rows": {
      "description": "Rows the query returned before this page was sliced. Pinot may have already applied its own LIMIT, so this is rows fetched, not the table total.",
      "type": "integer"
    },
    "truncated": {
      "default": false,
      "description": "True when the server-enforced fetch bound truncated the result.",
      "type": "boolean"
    }
  },
  "required": [
    "row_count",
    "total_rows",
    "offset",
    "has_more"
  ],
  "type": "object"
}
sha256:52b4c3ebee5060073f24ea77966eee096fdc0a426add82c465843f80e2a23d65

Description hash: sha256:851145194f5d8add239ab56a2adcf5054b0206bcb72b91f904fd4ea0e1fba404

Interface hash: sha256:9fb53b91882543dd438a3e15c0b4ea5c10fc49d007682a2b0fdd6001faf7d91c

Other observed Modelara metadata
{
  "id": "mcp:Pinot MCP Server/read_query",
  "title": "Read query",
  "source": {
    "type": "mcp",
    "server": "Pinot MCP Server",
    "operation": "read_query"
  },
  "declared": {
    "read_only": "true",
    "destructive": "unknown",
    "idempotent": "true",
    "open_world": "true"
  },
  "safety": {
    "idempotent": "true",
    "retry_safe": "true"
  },
  "metadata": {
    "mcp.annotations": "present"
  },
  "fingerprint": "sha256:ceb366190f89aa074df12f83ff49f7c82fd41d437552cda9836e2807c5aa1055"
}
toolread4.0.05.0.0
reload_table_filtersstartreedata-mcp-pinot:tool:reload_table_filters
Observed interface and hashes

Preview or apply the configured table-filter YAML without restarting. Reads only the path configured by ``PINOT_TABLE_FILTER_FILE``. The YAML must be an object whose ``included_tables`` value is a non-empty list of glob strings. Allowing every table requires an explicit ``allow_all: true``. The default ``dry_run=true`` validates and reports the before/after patterns and returns a short-lived confirmation token. Pass ``dry_run=false`` with that token to apply the exact candidate atomically. Editing the file after preview invalidates the confirmation and requires another preview. Failure recovery: A missing setting/file or malformed YAML is non-retryable until corrected; fix ``PINOT_TABLE_FILTER_FILE`` or its ``included_tables`` list, then retry.

Input schema

{
  "additionalProperties": false,
  "properties": {
    "confirmation_token": {
      "anyOf": [
        {
          "maxLength": 4096,
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "One-time token returned by a dry-run preview of the exact current filter-file contents. Required when dry_run is false."
    },
    "dry_run": {
      "default": true,
      "description": "When true (default), validate and preview the candidate allow-list without changing server state. Pass false explicitly to apply it.",
      "type": "boolean"
    }
  },
  "type": "object"
}
sha256:ade387a46dd0fa396d6325da8e9169692151846f99468b8f5b91d838767cf6a9

Output schema

{
  "additionalProperties": true,
  "description": "Preview or outcome of hot-reloading the table access filter file.",
  "properties": {
    "applied": {
      "default": false,
      "description": "True only when the in-memory allow-list was changed.",
      "type": "boolean"
    },
    "confirmation_token": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Short-lived token bound to this exact filter preview; required to apply."
    },
    "message": {
      "description": "Human-readable summary of the reload.",
      "type": "string"
    },
    "new_filter_count": {
      "default": 0,
      "description": "Number of allowed tables after the reload.",
      "type": "integer"
    },
    "new_filters": {
      "anyOf": [
        {
          "items": {
            "type": "string"
          },
          "type": "array"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Validated candidate patterns; null means all tables."
    },
    "previous_filter_count": {
      "default": 0,
      "description": "Number of allowed tables before the reload.",
      "type": "integer"
    },
    "previous_filters": {
      "anyOf": [
        {
          "items": {
            "type": "string"
          },
          "type": "array"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Allow-list patterns active before the operation; null means all."
    },
    "status": {
      "description": "Whether the candidate filters were previewed, applied, or failed.",
      "enum": [
        "preview",
        "success",
        "error"
      ],
      "type": "string"
    }
  },
  "required": [
    "status",
    "message"
  ],
  "type": "object"
}
sha256:8b123baa985047722bf18b384f677327e2bb36acf1f33aedc0e7387b0f863719

Description hash: sha256:8a81fe9f9738029f1b8503a908af09e5c1a957cefc05b8dd97187ca0f914aeed

Interface hash: sha256:d4442bd50f607466df1fbd09658ac47d5c030347046948cedc9d93d1316f1c77

Other observed Modelara metadata
{
  "id": "mcp:Pinot MCP Server/reload_table_filters",
  "title": "Reload table filters",
  "source": {
    "type": "mcp",
    "server": "Pinot MCP Server",
    "operation": "reload_table_filters"
  },
  "declared": {
    "read_only": "false",
    "destructive": "true",
    "idempotent": "true",
    "open_world": "false"
  },
  "safety": {
    "idempotent": "true",
    "retry_safe": "unknown"
  },
  "metadata": {
    "mcp.annotations": "present"
  },
  "fingerprint": "sha256:24518d61bd29eddc178b6db1472f5da4a5234e4e100c0dfe60d4f449ecd40d57"
}
tooldestructive4.0.05.0.0
test_connectionstartreedata-mcp-pinot:tool:test_connection
Observed interface and hashes

Probe Pinot connectivity and return diagnostics. Runs three checks — broker connection, a trivial ``SELECT 1`` query, and a controller table listing — and reports which succeeded plus a small sample of tables. Useful for troubleshooting configuration before using other tools. Failure recovery: Individual check failures are returned in ``error``. Verify the broker and controller URLs, credentials, and network, then retry only failed checks.

Input schema

{
  "additionalProperties": false,
  "properties": {},
  "type": "object"
}
sha256:fc182e1a69a66dadc6c6ee98df9606d1d4fd90fb51b082083aaa8c230cb4765c

Output schema

{
  "description": "Diagnostics describing Pinot connectivity and a sample of tables.\n\nOnly the declared fields below are surfaced. The client's internal ``config``\nblock (broker host/port/scheme, controller URL, database) is intentionally\nNOT passed through, so connection internals are never exposed to callers.",
  "properties": {
    "connection_test": {
      "default": false,
      "description": "True when the broker answered, i.e. the query check below succeeded.",
      "type": "boolean"
    },
    "dbapi_test": {
      "default": false,
      "description": "Informational: True when the optional pinotdb DB-API probe also succeeded. No tool uses that path, so false here does not mean the deployment is unhealthy — check query_test and tables_test instead.",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Names the checks that failed, or null when both required checks passed."
    },
    "query_test": {
      "default": false,
      "description": "True when a trivial 'SELECT 1' succeeded through the same broker path read_query uses.",
      "type": "boolean"
    },
    "sample_tables": {
      "description": "Up to five example table names.",
      "items": {
        "type": "string"
      },
      "type": "array"
    },
    "tables_count": {
      "anyOf": [
        {
          "type": "integer"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Number of tables discovered, when available."
    },
    "tables_test": {
      "default": false,
      "description": "True when the controller table listing succeeded.",
      "type": "boolean"
    }
  },
  "type": "object"
}
sha256:0c5fd06e357874b6f30a9ab1ebd359ed34f748a10dc94188ff005fb4d646e27b

Description hash: sha256:e74ec7fb31ea6ed347f841d4e5d62d3c8bdee94852dfc897ed1a14264fe96273

Interface hash: sha256:ad67f72df2efc135c6398776c7cf142014de48ae324be917bd42cd91378717c9

Other observed Modelara metadata
{
  "id": "mcp:Pinot MCP Server/test_connection",
  "title": "Test connection",
  "source": {
    "type": "mcp",
    "server": "Pinot MCP Server",
    "operation": "test_connection"
  },
  "declared": {
    "read_only": "true",
    "destructive": "unknown",
    "idempotent": "true",
    "open_world": "true"
  },
  "safety": {
    "idempotent": "true",
    "retry_safe": "true"
  },
  "metadata": {
    "mcp.annotations": "present"
  },
  "fingerprint": "sha256:c45d8d7ea02b69b5cee613043e867870cdd82b5ec2264fe0346503352d50db78"
}
toolread4.0.05.0.0
update_schemastartreedata-mcp-pinot:tool:update_schema
Observed interface and hashes

Update an existing Pinot schema. Accepts a typed schema object. This can change column definitions on a live table; the default ``dry_run=true`` previews without applying and returns a confirmation token bound to the exact replacement. Failure recovery: Invalid JSON/name or schema validation failures require a corrected payload; do not retry unchanged. Fix permission errors first, and retry transient controller failures only after connectivity is restored.

Input schema

{
  "additionalProperties": false,
  "properties": {
    "confirmation_token": {
      "anyOf": [
        {
          "maxLength": 4096,
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Token returned by a preview of this exact payload."
    },
    "dry_run": {
      "default": true,
      "description": "Preview safely (default); false requests application.",
      "type": "boolean"
    },
    "reload": {
      "default": false,
      "description": "Reload affected segments after updating.",
      "type": "boolean"
    },
    "schema": {
      "additionalProperties": {},
      "description": "Complete replacement schema; schemaName must match.",
      "properties": {
        "dateTimeFieldSpecs": {
          "items": {
            "additionalProperties": {},
            "description": "Typed Pinot column definition used by schema write tools.",
            "properties": {
              "dataType": {
                "enum": [
                  "INT",
                  "LONG",
                  "FLOAT",
                  "DOUBLE",
                  "BIG_DECIMAL",
                  "BOOLEAN",
                  "TIMESTAMP",
                  "STRING",
                  "BYTES",
                  "JSON"
                ],
                "type": "string"
              },
              "defaultNullValue": {
                "default": null
              },
              "name": {
                "maxLength": 128,
                "minLength": 1,
                "pattern": "^[A-Za-z0-9_-]+$",
                "type": "string"
              },
              "singleValueField": {
                "default": true,
                "type": "boolean"
              }
            },
            "required": [
              "name",
              "dataType"
            ],
            "type": "object"
          },
          "maxItems": 100,
          "type": "array"
        },
        "dimensionFieldSpecs": {
          "items": {
            "additionalProperties": {},
            "description": "Typed Pinot column definition used by schema write tools.",
            "properties": {
              "dataType": {
                "enum": [
                  "INT",
                  "LONG",
                  "FLOAT",
                  "DOUBLE",
                  "BIG_DECIMAL",
                  "BOOLEAN",
                  "TIMESTAMP",
                  "STRING",
                  "BYTES",
                  "JSON"
                ],
                "type": "string"
              },
              "defaultNullValue": {
                "default": null
              },
              "name": {
                "maxLength": 128,
                "minLength": 1,
                "pattern": "^[A-Za-z0-9_-]+$",
                "type": "string"
              },
              "singleValueField": {
                "default": true,
                "type": "boolean"
              }
            },
            "required": [
              "name",
              "dataType"
            ],
            "type": "object"
          },
          "maxItems": 10000,
          "type": "array"
        },
        "metricFieldSpecs": {
          "items": {
            "additionalProperties": {},
            "description": "Typed Pinot column definition used by schema write tools.",
            "properties": {
              "dataType": {
                "enum": [
                  "INT",
                  "LONG",
                  "FLOAT",
                  "DOUBLE",
                  "BIG_DECIMAL",
                  "BOOLEAN",
                  "TIMESTAMP",
                  "STRING",
                  "BYTES",
                  "JSON"
                ],
                "type": "string"
              },
              "defaultNullValue": {
                "default": null
              },
              "name": {
                "maxLength": 128,
                "minLength": 1,
                "pattern": "^[A-Za-z0-9_-]+$",
                "type": "string"
              },
              "singleValueField": {
                "default": true,
                "type": "boolean"
              }
            },
            "required": [
              "name",
              "dataType"
            ],
            "type": "object"
          },
          "maxItems": 10000,
          "type": "array"
        },
        "primaryKeyColumns": {
          "anyOf": [
            {
              "items": {
                "type": "string"
              },
              "maxItems": 100,
              "type": "array"
            },
            {
              "type": "null"
            }
          ],
          "default": null
        },
        "schemaName": {
          "maxLength": 128,
          "minLength": 1,
          "pattern": "^(?:[A-Za-z0-9_-]+\\.)?[A-Za-z0-9_-]+$",
          "type": "string"
        }
      },
      "required": [
        "schemaName"
      ],
      "type": "object"
    },
    "schema_name": {
      "description": "Exact Pinot schema name. It normally matches the table name without an _OFFLINE/_REALTIME suffix; use letters, digits, hyphens, or underscores, optionally prefixed by one 'database.' qualifier.",
      "maxLength": 128,
      "minLength": 1,
      "pattern": "^(?:[A-Za-z0-9_-]+\\.)?[A-Za-z0-9_-]+$",
      "type": "string"
    }
  },
  "required": [
    "schema_name",
    "schema"
  ],
  "type": "object"
}
sha256:c1f5d043aeed4fd3eb8ffcbf2487f5df705a7f94e7d1857b9df8f295ff835048

Output schema

{
  "additionalProperties": false,
  "description": "Result of a schema or table-config create/update operation.",
  "properties": {
    "applied": {
      "default": false,
      "description": "True only when Pinot accepted a mutating request.",
      "type": "boolean"
    },
    "confirmation_token": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Short-lived token bound to this exact preview; required to apply it."
    },
    "dry_run": {
      "default": false,
      "description": "True when no mutation was sent to Pinot.",
      "type": "boolean"
    },
    "message": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Human-readable detail, when provided."
    },
    "operation": {
      "description": "Stable operation identifier.",
      "enum": [
        "create_schema",
        "update_schema",
        "create_table",
        "update_table"
      ],
      "type": "string"
    },
    "resource_name": {
      "description": "Exact schema or table name targeted.",
      "type": "string"
    },
    "resource_type": {
      "description": "Kind of Pinot resource targeted by the operation.",
      "enum": [
        "schema",
        "table"
      ],
      "type": "string"
    },
    "response_summary": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Sanitized summary returned by the Pinot controller."
    },
    "status": {
      "default": "success",
      "description": "Whether the operation was previewed, applied, or rejected.",
      "enum": [
        "preview",
        "success",
        "rejected"
      ],
      "type": "string"
    },
    "verification_tool": {
      "description": "Read tool to call after a successful mutation.",
      "enum": [
        "get_schema",
        "get_table_config"
      ],
      "type": "string"
    },
    "warnings": {
      "description": "Safety or validation warnings.",
      "items": {
        "type": "string"
      },
      "type": "array"
    }
  },
  "required": [
    "operation",
    "resource_type",
    "resource_name",
    "verification_tool"
  ],
  "type": "object"
}
sha256:a1b69f42125d3d5beb369a44b6a20ebcbd0626d31fc6734368ec0f99995ac511

Description hash: sha256:f7f7a784883d102f5a8475d9069ef0b8266168c9b8b83f5ff19e1526ec97edda

Interface hash: sha256:5b1121b7fec61afb9b9b113074dacc0c2353d0597732f175cb03034da3c468b6

Other observed Modelara metadata
{
  "id": "mcp:Pinot MCP Server/update_schema",
  "title": "Update schema",
  "source": {
    "type": "mcp",
    "server": "Pinot MCP Server",
    "operation": "update_schema"
  },
  "declared": {
    "read_only": "false",
    "destructive": "true",
    "idempotent": "false",
    "open_world": "true"
  },
  "safety": {
    "idempotent": "false",
    "retry_safe": "false"
  },
  "metadata": {
    "mcp.annotations": "present"
  },
  "fingerprint": "sha256:685ae6d5801dd9b704c59d3a8a393d8c84ed6adcfeaa3204ae140a55054d4bc0"
}
tooldestructive4.0.05.0.0
update_table_configstartreedata-mcp-pinot:tool:update_table_config
Observed interface and hashes

Update an existing Pinot table configuration. Accepts a typed replacement table-config object. This changes a live table; the default ``dry_run=true`` asks Pinot to validate it, compares it with the current configuration, and returns a token without applying. Failure recovery: Invalid JSON/name or controller validation failures require a corrected payload; do not retry unchanged. Fix access errors first, and retry transient controller failures only after connectivity is restored.

Input schema

{
  "additionalProperties": false,
  "properties": {
    "confirmation_token": {
      "anyOf": [
        {
          "maxLength": 4096,
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Token returned by a preview of this exact payload."
    },
    "dry_run": {
      "default": true,
      "description": "Preview safely (default); false requests application.",
      "type": "boolean"
    },
    "table_config": {
      "additionalProperties": {},
      "description": "Complete replacement table configuration.",
      "properties": {
        "ingestionConfig": {
          "anyOf": [
            {
              "additionalProperties": {},
              "type": "object"
            },
            {
              "type": "null"
            }
          ],
          "default": null
        },
        "segmentsConfig": {
          "additionalProperties": {},
          "type": "object"
        },
        "tableIndexConfig": {
          "additionalProperties": {},
          "type": "object"
        },
        "tableName": {
          "maxLength": 128,
          "minLength": 1,
          "pattern": "^(?:[A-Za-z0-9_-]+\\.)?[A-Za-z0-9_-]+$",
          "type": "string"
        },
        "tableType": {
          "enum": [
            "OFFLINE",
            "REALTIME"
          ],
          "type": "string"
        },
        "tenants": {
          "additionalProperties": {},
          "type": "object"
        }
      },
      "required": [
        "tableName",
        "tableType",
        "segmentsConfig",
        "tableIndexConfig"
      ],
      "type": "object"
    },
    "table_name": {
      "description": "Exact Pinot table name, without _OFFLINE/_REALTIME. Use letters, digits, hyphens, or underscores, optionally prefixed by one 'database.' qualifier; whitespace is invalid and '__' is reserved by Pinot. Quote hyphenated names in SQL. Names are case-sensitive when that cluster option is enabled.",
      "maxLength": 128,
      "minLength": 1,
      "pattern": "^(?:[A-Za-z0-9_-]+\\.)?[A-Za-z0-9_-]+$",
      "type": "string"
    }
  },
  "required": [
    "table_name",
    "table_config"
  ],
  "type": "object"
}
sha256:c06071a7f40701bd006d72c8f86eae7d86fb4277b413295620b7312463c171bd

Output schema

{
  "additionalProperties": false,
  "description": "Result of a schema or table-config create/update operation.",
  "properties": {
    "applied": {
      "default": false,
      "description": "True only when Pinot accepted a mutating request.",
      "type": "boolean"
    },
    "confirmation_token": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Short-lived token bound to this exact preview; required to apply it."
    },
    "dry_run": {
      "default": false,
      "description": "True when no mutation was sent to Pinot.",
      "type": "boolean"
    },
    "message": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Human-readable detail, when provided."
    },
    "operation": {
      "description": "Stable operation identifier.",
      "enum": [
        "create_schema",
        "update_schema",
        "create_table",
        "update_table"
      ],
      "type": "string"
    },
    "resource_name": {
      "description": "Exact schema or table name targeted.",
      "type": "string"
    },
    "resource_type": {
      "description": "Kind of Pinot resource targeted by the operation.",
      "enum": [
        "schema",
        "table"
      ],
      "type": "string"
    },
    "response_summary": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Sanitized summary returned by the Pinot controller."
    },
    "status": {
      "default": "success",
      "description": "Whether the operation was previewed, applied, or rejected.",
      "enum": [
        "preview",
        "success",
        "rejected"
      ],
      "type": "string"
    },
    "verification_tool": {
      "description": "Read tool to call after a successful mutation.",
      "enum": [
        "get_schema",
        "get_table_config"
      ],
      "type": "string"
    },
    "warnings": {
      "description": "Safety or validation warnings.",
      "items": {
        "type": "string"
      },
      "type": "array"
    }
  },
  "required": [
    "operation",
    "resource_type",
    "resource_name",
    "verification_tool"
  ],
  "type": "object"
}
sha256:a1b69f42125d3d5beb369a44b6a20ebcbd0626d31fc6734368ec0f99995ac511

Description hash: sha256:f9574faf359d52d0b192dc3a6282d0be7d40401813b546e98caab0ef76ca306e

Interface hash: sha256:9ffca00de56cca3eb5cdaad0688254c67d49976494e95ca759eac15db12ddd3a

Other observed Modelara metadata
{
  "id": "mcp:Pinot MCP Server/update_table_config",
  "title": "Update table config",
  "source": {
    "type": "mcp",
    "server": "Pinot MCP Server",
    "operation": "update_table_config"
  },
  "declared": {
    "read_only": "false",
    "destructive": "true",
    "idempotent": "false",
    "open_world": "true"
  },
  "safety": {
    "idempotent": "false",
    "retry_safe": "false"
  },
  "metadata": {
    "mcp.annotations": "present"
  },
  "fingerprint": "sha256:0fc0e0dbb84e516f04ad813a141740031c4f104c0c8c634ae205bcc14e004ff7"
}
tooldestructive4.0.05.0.0

STATIC COMPARISONS

Release history

2 release transitions
  1. 4 added0 removed1 schema0 write0 destructive0 unknown

    Nov 16, 2026· Pending human review

  2. 0 added0 removed1 schema0 write0 destructive0 unknown

    Nov 16, 2026· Pending human review