mcp-bigquery mcp

v1.0.0 · MCP Tool · cloud · registry.pascalai.org

Google BigQuery REST API v2. Operations: query (run SQL, sync), list_datasets, list_tables, get_table (schema), insert_rows (streaming insert), create_dataset, delete_dataset. Requires OAuth2 accessToken and projectId.

bigquerygooglecloudsqlanalyticsgcp

Input Parameters

Parameter	Type	Description
operationrequired	string	Operation to perform. One of: `query`, `list_datasets`, `list_tables`, `get_table`, `insert_rows`, `create_dataset`, `delete_dataset`.
accessTokenrequired	string	OAuth2 access token for GCP authentication.
projectIdrequired	string	Google Cloud project ID.
datasetIdoptional	string	BigQuery dataset ID. Required for list_tables, get_table, insert_rows, create_dataset, delete_dataset.
tableIdoptional	string	BigQuery table ID. Required for get_table, insert_rows.
sqloptional	string	SQL query string for query operation.
rowsoptional	string	JSON array of row objects for insert_rows (streaming insert).
maxResultsoptional	integer	Max rows to return for query (default: 1000). Default: `1000`.
locationoptional	string	Dataset/query location (e.g. US, EU, us-central1). Default: `US`.

Output Fields

Field	Type	Description
rows	array[object]
schema	object
datasets	array[object]
tables	array[object]
rowCount	integer
ok	boolean
error	string

Examples

Run a BigQuery SQL query

// Input
{
  "operation": "query",
  "accessToken": "ya29...",
  "projectId": "my-project",
  "sql": "SELECT name, count FROM `my-project.dataset.table` LIMIT 10"
}

// Output
{
  "rows": [
    {
      "name": "Alice",
      "count": "42"
    }
  ],
  "rowCount": 1
}

Install & Discovery

Install

ppm install mcp-bigquery

Get JSON Schema

GET /v1/packages/mcp-bigquery/1.0.0/schema

Discover by keyword

GET /v1/mcp/discover?q=bigquery

Discovery hint: Install with ppm install mcp-bigquery or invoke remotely via POST /v1/invoke/mcp-bigquery on the MCP Service.

PascalAI Usage

uses toolslib;
var Tool := LoadTool('mcp-bigquery');
var R := Tool.Call(JsonObj(['operation','query','accessToken','ya29...','projectId','my-proj','sql','SELECT 1']));
Writeln(R.ToJSON);