# BigQuery

> Use this tool when you need to securely interact with Google BigQuery databases, execute SQL queries, and explore data, providing a controlled interface for LLMs to access structured data while preventing excessive costs. It solves problems of data analysis, query execution, and cost estimation, accepting SQL queries as input and returning query results, schema information, and cost estimates as output. Ideal for data analysts and developers, it is particularly useful when building AI-powered data analysis workflows that require access to BigQuery data.

Canonical page: https://skillsregistry.net/skills/takuya0206-bigquery  
JSON: https://api.skillsregistry.net/v1/skills/takuya0206-bigquery

## Description

BigQuery MCP Server provides a secure interface for LLMs to interact with Google BigQuery databases, enabling data exploration and SQL query execution. Built with TypeScript and the Bun runtime, it offers tools for executing read-only queries, listing tables, retrieving schema information, and estimating query costs. The implementation includes safeguards like query validation, configurable processing limits, and partition filter recommendations to prevent excessive costs. It supports both Application Default Credentials and service account authentication, making it ideal for data analysts and developers who need to give AI assistants access to structured data in BigQuery without compromising security.

## Trust

- **Trust score (0–1):** 0.89
- **Verification tier:** verified
- **Last scanned:** 2026-09-28

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** database
- **Updated:** 2026-09-28

## Source

- **Source listing:** [PulseMCP](https://www.pulsemcp.com/servers/takuya0206-bigquery)
- **Repository:** <https://github.com/takuya0206/bigquery-mcp-server>

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "takuya0206-bigquery"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/takuya0206-bigquery` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/takuya0206-bigquery/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt