Skip to main content
Glama
deBilla

BigQuery MCP

by deBilla

list_notebook_runs

Read-onlyIdempotent

List scheduled-notebook runs to see what has been failing across all notebooks. Defaults to failed runs, newest first.

Instructions

List individual scheduled-notebook runs, by default the failed ones.

Use this for "what has been failing?" across every scheduled notebook at once, rather than per schedule. Runs are returned newest first.

Outcome cannot be filtered server-side — the API rejects a jobState filter — so this reads the runs in the window and filters here. That makes lookback_days the cost control: each 100 runs is one API call.

Args: status: 'failed' (default), 'succeeded', 'running', or 'all'. environment: Which configured environment to read. Omit for the default. schedule: Restrict to one schedule, by its name or id. lookback_days: How far back to read. Defaults to 30. limit: Maximum runs to return.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
limitNo
statusNofailed
scheduleNo
environmentNo
lookback_daysNo

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observedv0.4.0

TDQS

A4.9/5.0
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations already declare readOnly/idempotent/non-destructive, and the description adds substantial non-obvious behavior: the API rejects a jobState filter so filtering happens client-side, results are newest-first, and lookback_days is the cost lever (100 runs per API call).

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Front-loads purpose and default behavior, then the rationale, then compact arg notes. Despite the length, every sentence carries actionable information that is absent from the structured fields.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

No output schema exists, and the description covers ordering, filtering, and cost but not the shape of a returned run record. Otherwise complete for a read-only list tool with five undocumented parameters.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters5/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 0%, so the description carries the full burden and does: it enumerates the status values, explains environment defaulting, says schedule accepts a name or id, and clarifies lookback_days and limit semantics.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

States a specific verb (list) and resource (scheduled-notebook runs) with an explicit default scope (failed). It draws the boundary against the sibling list_notebook_schedules by contrasting 'across every scheduled notebook at once, rather than per schedule.'

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Gives an explicit triggering question ('what has been failing?') and the condition that favors this tool over the per-schedule alternative. The trade-off against sibling tools is stated rather than inferred.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.