Skip to main content
Glama

BigQuery MCP by InsightfulPipe

BigQuery Prompts

prompts_menu
Read-only

Access BigQuery prompt catalog with 4 operations:

  1. List Public Prompts: • request='menu' - No additional params needed • Returns: All public/system prompts available for BigQuery

  2. List Custom Prompts: • request='menu', prompt_type='custom', workspace_id= • Returns: All custom prompts for the specified workspace

  3. Get Public Prompt Details: • request='prompt_details', prompt_id= • Returns: Full text/details of a public prompt

  4. Get Custom Prompt Details: • request='prompt_details', prompt_id=, is_custom=True, workspace_id= • Returns: Full text/details of a custom prompt

Tool call template

Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.

{
  "id": 1,
  "jsonrpc": "2.0",
  "method": "tools/call",
  "params": {
    "arguments": {
      "request": "<request>"
    },
    "name": "prompts_menu"
  }
}

Input Schema

NameRequiredDescriptionDefault
requestYes
is_customNo
prompt_idNo
prompt_typeNo
workspace_idNo

Output Schema

NameRequiredDescriptionDefault

No arguments

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observed

TDQS

A3.8/5.0
Behavior3/5

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

Annotations already declare readOnlyHint=true, so the safety profile is covered. The description adds per-operation return summaries, but says nothing about pagination, result limits, or whether a nonexistent prompt_id errors or returns empty. With output schema present, the return summaries add limited unique value.

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

Conciseness4/5

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

The numbered operation list is front-loaded and scannable, with parameter recipes ahead of return summaries. Two lines are spent restating return values already captured by the output schema, which is minor waste but not harmful.

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?

For a 5-parameter tool with zero schema descriptions, the operation recipes make it callable without guesswork. Remaining gaps are the is_custom vs prompt_type='custom' redundancy and no guidance on cross-tool selection; return values need not be covered since an output schema exists.

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

Parameters4/5

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

Schema description coverage is 0%, so the description must carry the full burden — and it largely does, mapping every parameter to concrete operation combinations (prompt_id, is_custom, workspace_id, prompt_type). The gap is that 'prompt_type' is only ever shown as 'custom' and its relationship to the overlapping 'is_custom' boolean is unexplained, leaving genuine ambiguity.

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

Purpose4/5

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

The description names a specific resource (BigQuery prompt catalog) and enumerates the exact operations available via the 'request' enum. An agent can distinguish 'menu' from 'prompt_details' immediately. It does not distinguish itself from siblings like query_contexts or query_data, which is the only gap.

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

Usage Guidelines4/5

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

Each of the four operations carries an explicit parameter recipe (e.g., request='menu', prompt_type='custom', workspace_id=<int>), which tells the agent precisely which combination to supply. It stops short of saying when this tool is preferable to query_data/query_contexts, or whether a menu call must precede a details call.

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

Try in Browser

Glama MCP Gateway

Add one secure layer between your agents and this server.