BigQuery Server

Local

API Integration

Integrate this MCP server into your applications.

Get your API Key

You'll need to login and generate a Smithery API key to connect to this server.

Installation

Install the Smithery and MCP SDKs using npm:

npm install @smithery/sdk @modelcontextprotocol/sdk

TypeScript SDK

Use Smithery's TypeScript SDK to connect to this MCP server:

typescript


import { StdioClientTransport } from "@modelcontextprotocol/sdk/client/stdio.js"

const transport = new StdioClientTransport({
  "command": "uvx",
  "args": [
    "mcp-server-bigquery",
    "--project",
    "your-gcp-project-id",
    "--location",
    "europe-west9",
    "--dataset",
    "my_dataset_1",
    "--dataset",
    "my_dataset_2"
  ]
})

// Create MCP client
import { Client } from "@modelcontextprotocol/sdk/client/index.js"

const client = new Client({
	name: "Test client",
	version: "1.0.0"
})
await client.connect(transport)

// Use the server tools with your LLM application
const tools = await client.listTools()
console.log(`Available tools: ${tools.map(t => t.name).join(", ")}`)

// Example: Call a tool
// const result = await client.callTool("tool_name", { param1: "value1" })

Configuration Schema

Full JSON Schema for server configuration:

json

{
  "type": "object",
  "required": [
    "gcpProjectId",
    "gcpLocation"
  ],
  "properties": {
    "dataset": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "Specific BigQuery datasets to consider; if not provided, all tables in the project will be considered."
    },
    "gcpLocation": {
      "type": "string",
      "description": "The GCP location (e.g. europe-west9)."
    },
    "gcpProjectId": {
      "type": "string",
      "description": "The GCP project ID."
    }
  }
}