---
title: "BigQuery Integration"
description: "Manage BigQuery list projects, list datasets, list tables, get table, query"
---
The BigQuery integration provides access to manage BigQuery list projects, list datasets, list tables, get table, query through the Integrate MCP server.

## Installation

The BigQuery integration is included with the SDK:

```typescript
import { bigqueryIntegration } from "integrate-sdk/server";
```

## Setup

### 1. Create a BigQuery OAuth App

1. Create an OAuth application for BigQuery
2. Configure your redirect URI
3. Note your Client ID and Client Secret

### 2. Configure the Integration on Your Server

Add the BigQuery integration to your server configuration. The integration automatically reads `BIGQUERY_CLIENT_ID` and `BIGQUERY_CLIENT_SECRET` from your environment variables:

```typescript
import { createMCPServer, bigqueryIntegration } from "integrate-sdk/server";

export const { client: serverClient } = createMCPServer({
  apiKey: process.env.INTEGRATE_API_KEY,
  integrations: [
    bigqueryIntegration({
      scopes: ["https://www.googleapis.com/auth/bigquery", "https://www.googleapis.com/auth/cloud-platform"], // Optional
    }),
  ],
});
```

You can override the environment variables by passing explicit values:

```typescript
bigqueryIntegration({
  clientId: process.env.CUSTOM_BIGQUERY_ID,
  clientSecret: process.env.CUSTOM_BIGQUERY_SECRET,
      scopes: ["https://www.googleapis.com/auth/bigquery", "https://www.googleapis.com/auth/cloud-platform"], // Optional
});
```

### 3. Client-Side Usage

The default client automatically includes all integrations. You can use it directly:

```typescript
import { client } from "integrate-sdk";

await client.authorize("bigquery");
const result = await client.bigquery.listProjects({});

console.log(result);
```

If you're using a custom client, add the integration to the integrations array:

```typescript
import { createMCPClient, bigqueryIntegration } from "integrate-sdk";

const customClient = createMCPClient({
  integrations: [bigqueryIntegration()],
});
```

## Configuration Options

<AutoTypeTable
  path="../src/integrations/bigquery.ts"
  name="BigqueryIntegrationConfig"
/>


## Default Scopes

These defaults are applied unless you override `scopes` in the integration config:

- `https://www.googleapis.com/auth/bigquery`
- `https://www.googleapis.com/auth/cloud-platform`

## Tools

### `bigquery_list_projects`

List projects

<AutoTypeTable
  path="generated/tool-params/bigquery.ts"
  name="BigqueryListProjectsParams"
/>

### `bigquery_list_datasets`

List datasets

<AutoTypeTable
  path="generated/tool-params/bigquery.ts"
  name="BigqueryListDatasetsParams"
/>

### `bigquery_list_tables`

List tables

<AutoTypeTable
  path="generated/tool-params/bigquery.ts"
  name="BigqueryListTablesParams"
/>

### `bigquery_get_table`

Get table

<AutoTypeTable
  path="generated/tool-params/bigquery.ts"
  name="BigqueryGetTableParams"
/>

### `bigquery_query`

Query

<AutoTypeTable
  path="generated/tool-params/bigquery.ts"
  name="BigqueryQueryParams"
/>

### `bigquery_list_jobs`

List jobs

<AutoTypeTable
  path="generated/tool-params/bigquery.ts"
  name="BigqueryListJobsParams"
/>

## Notes

- Category: Data & BI
- Authentication mode: OAuth