developer-tools Static interface comparison

Apache Pinot MCP Server

4.1.0 5.0.0

REVIEWPending human review

1 schema change requires review.No new authority detected.

View the upgrade review as Markdown

A shareable summary of this comparison for an issue, pull request or ticket. Select the text and copy it.

Tools14 → 18
Added4
Removed0
Schema changes1
Input schema changes0
Output schema changes1
Unclassified schema changes0
Description changes14
New write authority0
New destructive authority0
New unknown authority0
AnalysisREVIEW

INTERFACE DIFF

What changed, tool by tool

Classification from the recorded findings · definitions from the published snapshots

18 tools with recorded changes

  1. begin_investigationAddedAddedINFO

    What changed

    • New read-only tool begin_investigation.

    Why it could matter

    • The release adds a capability without declared write authority.

    What to verify

    • Decide whether agents should be offered this tool.
    Declared effect
    — → read

    Input schema

    PropertyPrevious (4.1.0)Current (5.0.0)Change
    (schema root)not presentobject, additionalProperties=false
    • Added
    baseline_start_msnot presentinteger, minimum=0required
    • Added
    end_msnot presentinteger, minimum=0required
    • Added
    profile_idnot presentstring, maxLength=256, minLength=1required
    • Added
    servicenot presentstring, maxLength=256, minLength=1required
    • Added
    start_msnot presentinteger, minimum=0required
    • Added

    Output schema

    PropertyPrevious (4.1.0)Current (5.0.0)Change
    (schema root)not presentobject
    • Added
    baseline_start_msnot presentintegerrequired
    • Added
    deadline_secondsnot presentintegerrequired
    • Added
    end_msnot presentintegerrequired
    • Added
    max_queriesnot presentintegerrequired
    • Added
    profile_idnot presentstringrequired
    • Added
    run_idnot presentstringrequired
    • Added
    scopenot presentstring, default="single_process_incident_evidence_assembly"optional
    • Added
    servicenot presentstringrequired
    • Added
    start_msnot presentintegerrequired
    • Added
    Exact JSON from the published snapshots

    Loads the exact recorded definitions of this tool from both releases. The full snapshots are linked under Evidence and provenance.

    Link to this tool
  2. create_schemaModifiedDescriptionINFO

    What changed

    • create_schema: description changed.

    Why it could matter

    • Models choose and call tools partly from their descriptions.

    What to verify

    • Spot-check that agents still select this tool as intended.
    Declared effect
    write → write
    Description
    PreviousPreview 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.
    CurrentPreview 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

    Input schema unchanged.

    24 unchanged entries
    • (schema root)
    • confirmation_token
    • dry_run
    • schema
    • schema › dateTimeFieldSpecs
    • schema › dateTimeFieldSpecs › [items]
    • schema › dateTimeFieldSpecs › [items] › dataType
    • schema › dateTimeFieldSpecs › [items] › defaultNullValue
    • schema › dateTimeFieldSpecs › [items] › name
    • schema › dateTimeFieldSpecs › [items] › singleValueField
    • schema › dimensionFieldSpecs
    • schema › dimensionFieldSpecs › [items]
    • schema › dimensionFieldSpecs › [items] › dataType
    • schema › dimensionFieldSpecs › [items] › defaultNullValue
    • schema › dimensionFieldSpecs › [items] › name
    • schema › dimensionFieldSpecs › [items] › singleValueField
    • schema › metricFieldSpecs
    • schema › metricFieldSpecs › [items]
    • schema › metricFieldSpecs › [items] › dataType
    • schema › metricFieldSpecs › [items] › defaultNullValue
    • schema › metricFieldSpecs › [items] › name
    • schema › metricFieldSpecs › [items] › singleValueField
    • schema › primaryKeyColumns
    • schema › schemaName

    Output schema

    Output schema unchanged.

    13 unchanged entries
    • (schema root)
    • applied
    • confirmation_token
    • dry_run
    • message
    • operation
    • resource_name
    • resource_type
    • response_summary
    • status
    • verification_tool
    • warnings
    • warnings › [items]
    Exact JSON from the published snapshots

    Loads the exact recorded definitions of this tool from both releases. The full snapshots are linked under Evidence and provenance.

    Link to this tool
  3. create_table_configModifiedDescriptionINFO

    What changed

    • create_table_config: description changed.

    Why it could matter

    • Models choose and call tools partly from their descriptions.

    What to verify

    • Spot-check that agents still select this tool as intended.
    Declared effect
    write → write
    Description
    PreviousCreate 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.
    CurrentCreate 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

    Input schema unchanged.

    10 unchanged entries
    • (schema root)
    • confirmation_token
    • dry_run
    • table_config
    • table_config › ingestionConfig
    • table_config › segmentsConfig
    • table_config › tableIndexConfig
    • table_config › tableName
    • table_config › tableType
    • table_config › tenants

    Output schema

    Output schema unchanged.

    13 unchanged entries
    • (schema root)
    • applied
    • confirmation_token
    • dry_run
    • message
    • operation
    • resource_name
    • resource_type
    • response_summary
    • status
    • verification_tool
    • warnings
    • warnings › [items]
    Exact JSON from the published snapshots

    Loads the exact recorded definitions of this tool from both releases. The full snapshots are linked under Evidence and provenance.

    Link to this tool
  4. finish_investigationAddedAddedINFO

    What changed

    • New read-only tool finish_investigation.

    Why it could matter

    • The release adds a capability without declared write authority.

    What to verify

    • Decide whether agents should be offered this tool.
    Declared effect
    — → read

    Input schema

    PropertyPrevious (4.1.0)Current (5.0.0)Change
    (schema root)not presentobject, additionalProperties=false
    • Added
    citationsnot presentarray, maxItems=64required
    • Added
    citations › [items]not presentstring
    • Added
    hypothesisnot presentanyOf (2), default=nulloptional
    • Added
    reasonnot presentanyOf (2), default=nulloptional
    • Added
    run_idnot presentstring, maxLength=128, minLength=1required
    • Added
    statusnot presentstring, default="proposed", enum (3)optional
    • Added

    Output schema

    PropertyPrevious (4.1.0)Current (5.0.0)Change
    (schema root)not presentobject
    • Added
    citationsnot presentobject, additionalProperties {…}required
    • Added
    confirmed_causenot presentboolean, default=falseoptional
    • Added
    dataset_coverage_attestednot presentboolean, default=falseoptional
    • Added
    failed_evidence_idsnot presentarrayrequired
    • Added
    failed_evidence_ids › [items]not presentstring
    • Added
    hypothesisnot presentanyOf (2)required
    • Added
    hypothesis_validatednot presentboolean, default=falseoptional
    • Added
    query_countnot presentintegerrequired
    • Added
    reasonnot presentanyOf (2)required
    • Added
    run_idnot presentstringrequired
    • Added
    scopenot presentstring, default="evidence_assembly_without_rca_semantic_validation"optional
    • Added
    statusnot presentstring, enum (3)required
    • Added
    Exact JSON from the published snapshots

    Loads the exact recorded definitions of this tool from both releases. The full snapshots are linked under Evidence and provenance.

    Link to this tool
  5. get_schemaModifiedDescriptionINFO

    What changed

    • get_schema: description changed.

    Why it could matter

    • Models choose and call tools partly from their descriptions.

    What to verify

    • Spot-check that agents still select this tool as intended.
    Declared effect
    read → read
    Description
    PreviousGet 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.
    CurrentGet 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

    Input schema unchanged.

    2 unchanged entries
    • (schema root)
    • schema_name

    Output schema

    Output schema unchanged.

    6 unchanged entries
    • (schema root)
    • dateTimeFieldSpecs
    • dimensionFieldSpecs
    • metricFieldSpecs
    • primaryKeyColumns
    • schemaName
    Exact JSON from the published snapshots

    Loads the exact recorded definitions of this tool from both releases. The full snapshots are linked under Evidence and provenance.

    Link to this tool
  6. get_segment_index_metadataModifiedDescriptionINFO

    What changed

    • get_segment_index_metadata: description changed.

    Why it could matter

    • Models choose and call tools partly from their descriptions.

    What to verify

    • Spot-check that agents still select this tool as intended.
    Declared effect
    read → read
    Description
    PreviousGet 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.
    CurrentGet 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

    Input schema unchanged.

    3 unchanged entries
    • (schema root)
    • segment_name
    • table_name

    Output schema

    Output schema unchanged.

    3 unchanged entries
    • (schema root)
    • columns
    • indexes
    Exact JSON from the published snapshots

    Loads the exact recorded definitions of this tool from both releases. The full snapshots are linked under Evidence and provenance.

    Link to this tool
  7. get_table_configModifiedDescriptionINFO

    What changed

    • get_table_config: description changed.

    Why it could matter

    • Models choose and call tools partly from their descriptions.

    What to verify

    • Spot-check that agents still select this tool as intended.
    Declared effect
    read → read
    Description
    PreviousGet 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.
    CurrentGet 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

    Input schema unchanged.

    3 unchanged entries
    • (schema root)
    • table_name
    • table_type

    Output schema

    Output schema unchanged.

    4 unchanged entries
    • (schema root)
    • offline
    • realtime
    • table_name
    Exact JSON from the published snapshots

    Loads the exact recorded definitions of this tool from both releases. The full snapshots are linked under Evidence and provenance.

    Link to this tool
  8. get_table_sizeModifiedDescriptionINFO

    What changed

    • get_table_size: description changed.

    Why it could matter

    • Models choose and call tools partly from their descriptions.

    What to verify

    • Spot-check that agents still select this tool as intended.
    Declared effect
    read → read
    Description
    PreviousGet 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.
    CurrentGet 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

    Input schema unchanged.

    2 unchanged entries
    • (schema root)
    • table_name

    Output schema

    Output schema unchanged.

    4 unchanged entries
    • (schema root)
    • estimatedSizeInBytes
    • reportedSizeInBytes
    • tableName
    Exact JSON from the published snapshots

    Loads the exact recorded definitions of this tool from both releases. The full snapshots are linked under Evidence and provenance.

    Link to this tool
  9. get_traceAddedAddedINFO

    What changed

    • New read-only tool get_trace.

    Why it could matter

    • The release adds a capability without declared write authority.

    What to verify

    • Decide whether agents should be offered this tool.
    Declared effect
    — → read

    Input schema

    PropertyPrevious (4.1.0)Current (5.0.0)Change
    (schema root)not presentobject, additionalProperties=false
    • Added
    run_idnot presentstring, maxLength=128, minLength=1required
    • Added
    trace_idnot presentstring, maxLength=256, minLength=1required
    • Added

    Output schema

    PropertyPrevious (4.1.0)Current (5.0.0)Change
    (schema root)not presentobject
    • Added
    columnsnot presentarrayoptional
    • Added
    columns › [items]not presentstring
    • Added
    completenot presentboolean, default=falseoptional
    • Added
    dataset_coverage_attestednot presentboolean, default=falseoptional
    • Added
    errornot presentanyOf (2), default=nulloptional
    • Added
    evidence_idnot presentstringrequired
    • Added
    kindnot presentstringrequired
    • Added
    metadatanot presentobjectoptional
    • Added
    metadata › completenessnot presentstring, default="unknown", enum (3)optional
    • Added
    metadata › early_termination_reasonsnot presentarray, maxItems=4optional
    • Added
    metadata › early_termination_reasons › [items]not presentstring, enum (4)
    • Added
    metadata › execution_limit_flagsnot presentobject, additionalProperties {…}, maxProperties=7, propertyNames {…}optional
    • Added
    metadata › execution_limit_reachednot presentanyOf (2), default=nulloptional
    • Added
    metadata › native_query_idnot presentanyOf (3), default=nulloptional
    • Added
    metadata › native_statsnot presentobject, additionalProperties {…}, maxProperties=32optional
    • Added
    metadata › partial_resultnot presentanyOf (2), default=nulloptional
    • Added
    metadata › query_sha256not presentanyOf (2), default=nulloptional
    • Added
    metadata › request_idnot presentanyOf (2), default=nulloptional
    • Added
    metadata › row_limit_reachednot presentboolean, default=falseoptional
    • Added
    metadata › servers_queriednot presentanyOf (2), default=nulloptional
    • Added
    metadata › servers_respondednot presentanyOf (2), default=nulloptional
    • Added
    metadata › unknown_reasonsnot presentarrayoptional
    • Added
    metadata › unknown_reasons › [items]not presentstring
    • Added
    rowsnot presentarrayoptional
    • Added
    rows › [items]not presentobject, additionalProperties=true
    • Added
    run_idnot presentstringrequired
    • Added
    sha256not presentstring, default=""optional
    • Added
    sqlnot presentstringrequired
    • Added
    Exact JSON from the published snapshots

    Loads the exact recorded definitions of this tool from both releases. The full snapshots are linked under Evidence and provenance.

    Link to this tool
  10. list_segment_metadataModifiedDescriptionINFO

    What changed

    • list_segment_metadata: description changed.

    Why it could matter

    • Models choose and call tools partly from their descriptions.

    What to verify

    • Spot-check that agents still select this tool as intended.
    Declared effect
    read → read
    Description
    PreviousGet 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.
    CurrentGet 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

    Input schema unchanged.

    4 unchanged entries
    • (schema root)
    • limit
    • offset
    • table_name

    Output schema

    Output schema unchanged.

    6 unchanged entries
    • (schema root)
    • has_more
    • offset
    • returned_segments
    • segments
    • total_segments
    Exact JSON from the published snapshots

    Loads the exact recorded definitions of this tool from both releases. The full snapshots are linked under Evidence and provenance.

    Link to this tool
  11. list_segmentsModifiedDescriptionINFO

    What changed

    • list_segments: description changed.

    Why it could matter

    • Models choose and call tools partly from their descriptions.

    What to verify

    • Spot-check that agents still select this tool as intended.
    Declared effect
    read → read
    Description
    PreviousList 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.
    CurrentList 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

    Input schema unchanged.

    4 unchanged entries
    • (schema root)
    • limit
    • offset
    • table_name

    Output schema

    Output schema unchanged.

    7 unchanged entries
    • (schema root)
    • OFFLINE
    • REALTIME
    • has_more
    • offset
    • returned_segments
    • total_segments
    Exact JSON from the published snapshots

    Loads the exact recorded definitions of this tool from both releases. The full snapshots are linked under Evidence and provenance.

    Link to this tool
  12. list_tablesModifiedDescriptionINFO

    What changed

    • list_tables: description changed.

    Why it could matter

    • Models choose and call tools partly from their descriptions.

    What to verify

    • Spot-check that agents still select this tool as intended.
    Declared effect
    read → read
    Description
    PreviousList 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.
    CurrentList 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

    Input schema unchanged.

    3 unchanged entries
    • (schema root)
    • limit
    • offset

    Output schema

    Output schema unchanged.

    7 unchanged entries
    • (schema root)
    • has_more
    • offset
    • table_count
    • tables
    • tables › [items]
    • total_tables
    Exact JSON from the published snapshots

    Loads the exact recorded definitions of this tool from both releases. The full snapshots are linked under Evidence and provenance.

    Link to this tool
  13. query_incidentAddedAddedINFO

    What changed

    • New read-only tool query_incident.

    Why it could matter

    • The release adds a capability without declared write authority.

    What to verify

    • Decide whether agents should be offered this tool.
    Declared effect
    — → read

    Input schema

    PropertyPrevious (4.1.0)Current (5.0.0)Change
    (schema root)not presentobject, additionalProperties=false
    • Added
    candidatenot presentanyOf (2), default=nulloptional
    • Added
    kindnot presentstring, enum (5)required
    • Added
    run_idnot presentstring, maxLength=128, minLength=1required
    • Added

    Output schema

    PropertyPrevious (4.1.0)Current (5.0.0)Change
    (schema root)not presentobject
    • Added
    columnsnot presentarrayoptional
    • Added
    columns › [items]not presentstring
    • Added
    completenot presentboolean, default=falseoptional
    • Added
    dataset_coverage_attestednot presentboolean, default=falseoptional
    • Added
    errornot presentanyOf (2), default=nulloptional
    • Added
    evidence_idnot presentstringrequired
    • Added
    kindnot presentstringrequired
    • Added
    metadatanot presentobjectoptional
    • Added
    metadata › completenessnot presentstring, default="unknown", enum (3)optional
    • Added
    metadata › early_termination_reasonsnot presentarray, maxItems=4optional
    • Added
    metadata › early_termination_reasons › [items]not presentstring, enum (4)
    • Added
    metadata › execution_limit_flagsnot presentobject, additionalProperties {…}, maxProperties=7, propertyNames {…}optional
    • Added
    metadata › execution_limit_reachednot presentanyOf (2), default=nulloptional
    • Added
    metadata › native_query_idnot presentanyOf (3), default=nulloptional
    • Added
    metadata › native_statsnot presentobject, additionalProperties {…}, maxProperties=32optional
    • Added
    metadata › partial_resultnot presentanyOf (2), default=nulloptional
    • Added
    metadata › query_sha256not presentanyOf (2), default=nulloptional
    • Added
    metadata › request_idnot presentanyOf (2), default=nulloptional
    • Added
    metadata › row_limit_reachednot presentboolean, default=falseoptional
    • Added
    metadata › servers_queriednot presentanyOf (2), default=nulloptional
    • Added
    metadata › servers_respondednot presentanyOf (2), default=nulloptional
    • Added
    metadata › unknown_reasonsnot presentarrayoptional
    • Added
    metadata › unknown_reasons › [items]not presentstring
    • Added
    rowsnot presentarrayoptional
    • Added
    rows › [items]not presentobject, additionalProperties=true
    • Added
    run_idnot presentstringrequired
    • Added
    sha256not presentstring, default=""optional
    • Added
    sqlnot presentstringrequired
    • Added
    Exact JSON from the published snapshots

    Loads the exact recorded definitions of this tool from both releases. The full snapshots are linked under Evidence and provenance.

    Link to this tool
  14. read_queryModifiedSchemaDescriptionREVIEWINFO

    What changed

    • read_query — Output schema: property added: metadata.
    • read_query: description changed.

    Why it could matter

    • Code or prompts that read this tool’s results may receive a different shape.
    • Models choose and call tools partly from their descriptions.

    What to verify

    • Check consumers of this tool’s output against the new schema.
    • Spot-check that agents still select this tool as intended.
    Declared effect
    read → read
    Description
    PreviousRun 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, and a ``has_more`` flag. 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. Zero rows is a successful result.
    CurrentRun 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

    Input schema unchanged.

    4 unchanged entries
    • (schema root)
    • limit
    • offset
    • query

    Output schema

    PropertyPrevious (4.1.0)Current (5.0.0)Change
    metadatanot presentobjectoptional
    • Added
    metadata › completenessnot presentstring, default="unknown", enum (3)optional
    • Added
    metadata › early_termination_reasonsnot presentarray, maxItems=4optional
    • Added
    metadata › early_termination_reasons › [items]not presentstring, enum (4)
    • Added
    metadata › execution_limit_flagsnot presentobject, additionalProperties {…}, maxProperties=7, propertyNames {…}optional
    • Added
    metadata › execution_limit_reachednot presentanyOf (2), default=nulloptional
    • Added
    metadata › native_query_idnot presentanyOf (3), default=nulloptional
    • Added
    metadata › native_statsnot presentobject, additionalProperties {…}, maxProperties=32optional
    • Added
    metadata › partial_resultnot presentanyOf (2), default=nulloptional
    • Added
    metadata › query_sha256not presentanyOf (2), default=nulloptional
    • Added
    metadata › request_idnot presentanyOf (2), default=nulloptional
    • Added
    metadata › row_limit_reachednot presentboolean, default=falseoptional
    • Added
    metadata › servers_queriednot presentanyOf (2), default=nulloptional
    • Added
    metadata › servers_respondednot presentanyOf (2), default=nulloptional
    • Added
    metadata › unknown_reasonsnot presentarrayoptional
    • Added
    metadata › unknown_reasons › [items]not presentstring
    • Added
    10 unchanged entries
    • (schema root)
    • columns
    • columns › [items]
    • has_more
    • offset
    • row_count
    • rows
    • rows › [items]
    • total_rows
    • truncated
    Exact JSON from the published snapshots

    Loads the exact recorded definitions of this tool from both releases. The full snapshots are linked under Evidence and provenance.

    Link to this tool
  15. reload_table_filtersModifiedDescriptionINFO

    What changed

    • reload_table_filters: description changed.

    Why it could matter

    • Models choose and call tools partly from their descriptions.

    What to verify

    • Spot-check that agents still select this tool as intended.
    Declared effect
    write → write
    Description
    PreviousPreview 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. Returns: Preview/application status, whether it was applied, old/new patterns, and a confirmation token on previews. 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.
    CurrentPreview 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

    Input schema unchanged.

    3 unchanged entries
    • (schema root)
    • confirmation_token
    • dry_run

    Output schema

    Output schema unchanged.

    9 unchanged entries
    • (schema root)
    • applied
    • confirmation_token
    • message
    • new_filter_count
    • new_filters
    • previous_filter_count
    • previous_filters
    • status
    Exact JSON from the published snapshots

    Loads the exact recorded definitions of this tool from both releases. The full snapshots are linked under Evidence and provenance.

    Link to this tool
  16. test_connectionModifiedDescriptionINFO

    What changed

    • test_connection: description changed.

    Why it could matter

    • Models choose and call tools partly from their descriptions.

    What to verify

    • Spot-check that agents still select this tool as intended.
    Declared effect
    read → read
    Description
    PreviousProbe 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.
    CurrentProbe 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

    Input schema unchanged.

    1 unchanged entry
    • (schema root)

    Output schema

    Output schema unchanged.

    9 unchanged entries
    • (schema root)
    • connection_test
    • dbapi_test
    • error
    • query_test
    • sample_tables
    • sample_tables › [items]
    • tables_count
    • tables_test
    Exact JSON from the published snapshots

    Loads the exact recorded definitions of this tool from both releases. The full snapshots are linked under Evidence and provenance.

    Link to this tool
  17. update_schemaModifiedDescriptionINFO

    What changed

    • update_schema: description changed.

    Why it could matter

    • Models choose and call tools partly from their descriptions.

    What to verify

    • Spot-check that agents still select this tool as intended.
    Declared effect
    write → write
    Description
    PreviousUpdate 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.
    CurrentUpdate 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

    Input schema unchanged.

    26 unchanged entries
    • (schema root)
    • confirmation_token
    • dry_run
    • reload
    • schema
    • schema › dateTimeFieldSpecs
    • schema › dateTimeFieldSpecs › [items]
    • schema › dateTimeFieldSpecs › [items] › dataType
    • schema › dateTimeFieldSpecs › [items] › defaultNullValue
    • schema › dateTimeFieldSpecs › [items] › name
    • schema › dateTimeFieldSpecs › [items] › singleValueField
    • schema › dimensionFieldSpecs
    • schema › dimensionFieldSpecs › [items]
    • schema › dimensionFieldSpecs › [items] › dataType
    • schema › dimensionFieldSpecs › [items] › defaultNullValue
    • schema › dimensionFieldSpecs › [items] › name
    • schema › dimensionFieldSpecs › [items] › singleValueField
    • schema › metricFieldSpecs
    • schema › metricFieldSpecs › [items]
    • schema › metricFieldSpecs › [items] › dataType
    • schema › metricFieldSpecs › [items] › defaultNullValue
    • schema › metricFieldSpecs › [items] › name
    • schema › metricFieldSpecs › [items] › singleValueField
    • schema › primaryKeyColumns
    • schema › schemaName
    • schema_name

    Output schema

    Output schema unchanged.

    13 unchanged entries
    • (schema root)
    • applied
    • confirmation_token
    • dry_run
    • message
    • operation
    • resource_name
    • resource_type
    • response_summary
    • status
    • verification_tool
    • warnings
    • warnings › [items]
    Exact JSON from the published snapshots

    Loads the exact recorded definitions of this tool from both releases. The full snapshots are linked under Evidence and provenance.

    Link to this tool
  18. update_table_configModifiedDescriptionINFO

    What changed

    • update_table_config: description changed.

    Why it could matter

    • Models choose and call tools partly from their descriptions.

    What to verify

    • Spot-check that agents still select this tool as intended.
    Declared effect
    write → write
    Description
    PreviousUpdate 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.
    CurrentUpdate 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

    Input schema unchanged.

    11 unchanged entries
    • (schema root)
    • confirmation_token
    • dry_run
    • table_config
    • table_config › ingestionConfig
    • table_config › segmentsConfig
    • table_config › tableIndexConfig
    • table_config › tableName
    • table_config › tableType
    • table_config › tenants
    • table_name

    Output schema

    Output schema unchanged.

    13 unchanged entries
    • (schema root)
    • applied
    • confirmation_token
    • dry_run
    • message
    • operation
    • resource_name
    • resource_type
    • response_summary
    • status
    • verification_tool
    • warnings
    • warnings › [items]
    Exact JSON from the published snapshots

    Loads the exact recorded definitions of this tool from both releases. The full snapshots are linked under Evidence and provenance.

    Link to this tool

Evidence and provenance

Static findings
REVIEW from Modelara’s automated analysis of the two declared interfaces. A policy outcome, not a security rating or a runtime test.
Human review
Pending human review. No reviewer decision is recorded for this comparison.
Published evidence
Part of Valyd’s published data generation listed in valyd-data-source.json. Published records are not rewritten.
Show provenance and exact files
Comparison
startreedata-mcp-pinot/4.1.0~5.0.0The published comparison identifier.
Analyzer
modelara v0.1.8Policy version not recorded.Analyzed Nov 16, 2026, 10:19 PM UTC.
Distribution
pypi
Previous release
mcp-pinot-server@4.1.014 tools · published by the registry Aug 29, 2026, 10:35 PM UTC · upstream 4.1.0Artifact integritysha256-GTiypEKjTwJ2SZJzdoB0d51W1Xdoyb6FjNbXKUApX4Y=Artifactmcp_pinot_server-4.1.0-py3-none-any.whlInterface fingerprintsha256:f24ed68635de0fabb39d1439292c5afd0fecd0680f200abcbe56ed5bfd67d75cExact interface snapshot (JSON)
Current release
mcp-pinot-server@5.0.018 tools · published by the registry Oct 12, 2026, 12:58 AM UTC · upstream 5.0.0Artifact integritysha256-+unWJw6pCILWbzuApVkHwg2H4bqO8jzBzBKG2DRZH5Q=Artifactmcp_pinot_server-5.0.0-py3-none-any.whlInterface fingerprintsha256:de53328f47de20f4687f6afb0a327f5041b46721ccb08911aa62bb8fbceddb2fExact interface snapshot (JSON)

The integrity value or digest identifies the exact artifact that was inspected; it does not show that the package is safe. The interface fingerprint identifies the declared tools and schemas Modelara recorded for that release.

MODELARA ANALYSIS OUTPUT

Interface findings

Analyzed with Modelara v0.1.8 · Nov 16, 2026

Requires review

1 finding
  • read_queryREVIEWChanged

    Output schema changed

    Show details
    • output property added: metadata
    Authority
    READREAD
    Authority unchanged

Informational

18 findings
  • begin_investigationINFOAdded

    New read-only capability

    Authority
    —READ
  • finish_investigationINFOAdded

    New read-only capability

    Authority
    —READ
  • get_traceINFOAdded

    New read-only capability

    Authority
    —READ
  • query_incidentINFOAdded

    New read-only capability

    Authority
    —READ
  • create_schemaINFOChanged

    Description changed

    Authority
    WRITEWRITE
    Authority unchanged
  • create_table_configINFOChanged

    Description changed

    Authority
    WRITEWRITE
    Authority unchanged
  • get_schemaINFOChanged

    Description changed

    Authority
    READREAD
    Authority unchanged
  • get_segment_index_metadataINFOChanged

    Description changed

    Authority
    READREAD
    Authority unchanged
  • get_table_configINFOChanged

    Description changed

    Authority
    READREAD
    Authority unchanged
  • get_table_sizeINFOChanged

    Description changed

    Authority
    READREAD
    Authority unchanged
  • list_segment_metadataINFOChanged

    Description changed

    Authority
    READREAD
    Authority unchanged
  • list_segmentsINFOChanged

    Description changed

    Authority
    READREAD
    Authority unchanged
  • list_tablesINFOChanged

    Description changed

    Authority
    READREAD
    Authority unchanged
  • read_queryINFOChanged

    Description changed

    Authority
    READREAD
    Authority unchanged
  • reload_table_filtersINFOChanged

    Description changed

    Authority
    DESTRUCTIVEDESTRUCTIVE
    Authority unchanged
  • test_connectionINFOChanged

    Description changed

    Authority
    READREAD
    Authority unchanged
  • update_schemaINFOChanged

    Description changed

    Authority
    DESTRUCTIVEDESTRUCTIVE
    Authority unchanged
  • update_table_configINFOChanged

    Description changed

    Authority
    DESTRUCTIVEDESTRUCTIVE
    Authority unchanged
What do these results mean?
PASS
No policy-significant interface change detected.
REVIEW
Interface changes require inspection.
FAIL
A policy-significant change was detected.
INVALID
The comparison could not be evaluated reliably.
← Back to Apache Pinot MCP Server release history