Is Suganthans BigQuery MCP Server safe to use?

Suganthans BigQuery MCP Server has no known CVEs as of the latest MCPpedia security scan. It does not require authentication, so any local process can connect — keep this in mind in shared environments. Licensed under Apache-2.0.

How do I install Suganthans BigQuery MCP Server?

Suganthans BigQuery MCP Server supports copy-paste install configs on its MCPpedia page for Claude Desktop, Cursor, and Claude Code. Scroll to the Quick Install section and select your client.

What can Suganthans BigQuery MCP Server do?

Suganthans BigQuery MCP Server provides 26 tools: gsc_anonymous_traffic, gsc_forecast, gsc_anomalies, gsc_seasonal, gsc_device_split and 21 more. See the full tools list on the server page for descriptions and parameters.

What AI clients work with Suganthans BigQuery MCP Server?

Suganthans BigQuery MCP Server is compatible with claude-desktop, cursor, claude-code. It uses stdio and sse transport.

Is Suganthans BigQuery MCP Server actively maintained?

Suganthans BigQuery MCP Server is actively maintained — last commit was 27 days ago. It has 35 GitHub stars.

Suganthans BigQuery MCP Server

Name: Suganthans BigQuery MCP Server
Author: Suganthan-Mohanadasan

npm · by Suganthan-Mohanadasan

BigQuery MCP server for Claude — query any BigQuery dataset in natural language, with built-in SEO analysis tools for GSC bulk export data

35 12.6M/wk 26 tools GitHub npm

No known CVEs

Apache-2.0 license

Actively maintained

Last commit 27d ago

Works with most clients

Transport: stdio, sse

26 tools · ~1.3k tok

Grade B · 0.6% of 200K ctx

Edit this pageView history

Data Analytics

Step 1

Install in your client

Config is the same across clients — only the file and path differ.

Supported in Claude Desktopstdio, sse · Node 18+

Paste into ~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "bigquery": {
      "env": {
        "BIGQUERY_KEY_FILE": "/path/to/service-account-key.json",
        "BIGQUERY_LOCATION": "US",
        "BIGQUERY_PROJECT_ID": "your-project-id",
        "BIGQUERY_DEFAULT_DATASET": "searchconsole"
      },
      "args": [
        "/path/to/Suganthans-BigQuery-MCP-Server/dist/index.js"
      ],
      "command": "node"
    }
  }
}

Are you the author?

Add this badge to your README to show your security score and help users find safe servers.

Embed in your READMEAbout badges →

[![MCPpedia Score](https://mcppedia.org/api/badge/suganthans-bigquery-mcp-server)](https://mcppedia.org/s/suganthans-bigquery-mcp-server)

Read me

What Suganthans BigQuery MCP Server does

An MCP server for BigQuery that lets you ask Claude questions about your search data warehouse and get real answers. Not raw query results. Actual analysis with verdicts and recommendations.

Test This Server

Run this in your terminal to verify the server starts. Then let us know if it worked — your result helps other developers.

npx -y 'npm' 2>&1 | head -1 && echo "✓ Server started successfully"

After testing, let us know if it worked:

Loading README…

Scored, not listed

Why this score

Five weighted categories — click any category to see the underlying evidence.

Score breakdown

87/100across 5 weighted dimensions

How we score →

0255075100

−13

Security

Maintenance

Efficiency

Documentation

Compatibility

Categoriesclick a row to see evidence

Security

OSV.dev

8 fixed

CVE-2022-29244low · fixedCVSS 3.1

Packing does not respect root-level ignore files in workspaces

### Impact `npm pack` ignores root-level `.gitignore` & `.npmignore` file exclusion directives when run in a workspace or with a workspace flag (ie. `--workspaces`, `--workspace=<name>`). Anyone who has run `npm pack` or `npm publish` with workspaces, as of [v7.9.0](https://github.com/npm/cli/releases/tag/v7.9.0) & [v7.13.0](https://github.com/npm/cli/releases/tag/v7.13.0) respectively, may be affected and have published files into the npm registry they did not intend to include. ### Patch - Up

Affected: >= 7.9.0Fixed in 8.11.0source →

CVE-2018-7408low · fixedCVSS 3

Incorrect Permission Assignment for Critical Resource in NPM

An issue was discovered in an npm 5.7.0 2018-02-21 pre-release (marked as "next: 5.7.0" and therefore automatically installed by an "npm upgrade -g npm" command, and also announced in the vendor's blog without mention of pre-release status). It might allow local users to bypass intended filesystem access restrictions because ownerships of /etc and /usr directories are being changed unexpectedly, related to a "correctMkdir" issue.

Affected: >= 0Fixed in 5.7.1source →

CVE-2013-4116info · fixed

Local Privilege Escalation in npm

Affected versions of `npm` use predictable temporary file names during archive unpacking. If an attacker can create a symbolic link at the location of one of these temporary file names, the attacker can arbitrarily write to any file that the user which owns the `npm` process has permission to write to, potentially resulting in local privilege escalation. ## Recommendation Update to version 1.3.3 or later.

Affected: >= 0Fixed in 1.3.3source →

CVE-2020-15095low · fixedCVSS 3.1

npm CLI exposing sensitive information through logs

Versions of the npm CLI prior to 6.14.6 are vulnerable to an information exposure vulnerability through log files. The CLI supports URLs like `<protocol>://[<user>[:<password>]@]<hostname>[:<port>][:][/]<path>`. The password value is not redacted and is printed to stdout and also to any generated log files.

Affected: >= 0Fixed in 6.14.6source →

CVE-2019-16777low · fixedCVSS 3.1

npm Vulnerable to Global node_modules Binary Overwrite

Versions of the npm CLI prior to 6.13.4 are vulnerable to a Global node_modules Binary Overwrite. It fails to prevent existing globally-installed binaries to be overwritten by other package installations. For example, if a package was installed globally and created a `serve` binary, any subsequent installs of packages that also create a `serve` binary would overwrite the first binary. This will not overwrite system binaries but only binaries put into the global node_modules directory. This b

Affected: >= 0Fixed in 6.13.4source →

Inventory

Tools (26)

Click any tool to inspect its schema.

~1.3k tokens total

Community

Reviews

Be the first to review

Have you used this server?

Share your experience — it helps other developers decide.

How easy was setup?Did it work reliably?How was the documentation?

Frequently Asked Questions

Is Suganthans BigQuery MCP Server safe to use?: Suganthans BigQuery MCP Server has no known CVEs as of the latest MCPpedia security scan. It does not require authentication, so any local process can connect — keep this in mind in shared environments. Licensed under Apache-2.0.
How do I install Suganthans BigQuery MCP Server?: Suganthans BigQuery MCP Server supports copy-paste install configs on its MCPpedia page for Claude Desktop, Cursor, and Claude Code. Scroll to the Quick Install section and select your client.
What can Suganthans BigQuery MCP Server do?: Suganthans BigQuery MCP Server provides 26 tools: gsc_anonymous_traffic, gsc_forecast, gsc_anomalies, gsc_seasonal, gsc_device_split and 21 more. See the full tools list on the server page for descriptions and parameters.
What AI clients work with Suganthans BigQuery MCP Server?: Suganthans BigQuery MCP Server is compatible with claude-desktop, cursor, claude-code. It uses stdio and sse transport.
Is Suganthans BigQuery MCP Server actively maintained?: Suganthans BigQuery MCP Server is actively maintained — last commit was 27 days ago. It has 35 GitHub stars.

Similar servers

Others in data / analytics

View all →

Supabase MCP Server97

Manage Supabase projects — databases, auth, storage, and edge functions

2.7k 4

Observability Mcp95

MCP Server for GCP environment for interacting with various Observability APIs.

790 10

Firecrawl Mcp Server95

🔥 Official Firecrawl MCP Server - Adds powerful web scraping and search to Cursor, Claude and any other LLM clients.

6.3k 4

Apify Mcp Server94

The Apify MCP server enables your AI agents to extract data from social media, search engines, maps, e-commerce sites, or any other website using thousands of ready-made scrapers, crawlers, and automation tools available on the Apify Store.

1.2k 1

MCP Security Weekly

Get CVE alerts and security updates for Suganthans BigQuery MCP Server and similar servers.

Community

Discussion

Start a conversation

Ask a question, share a tip, or report an issue.

Has anyone used this with Cursor?How do you handle auth?Any alternatives?

Edit this pageView history

Data Analytics

Step 1

Install in your client

Config is the same across clients — only the file and path differ.

Supported in Claude Desktopstdio, sse · Node 18+

Paste into ~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "bigquery": {
      "env": {
        "BIGQUERY_KEY_FILE": "/path/to/service-account-key.json",
        "BIGQUERY_LOCATION": "US",
        "BIGQUERY_PROJECT_ID": "your-project-id",
        "BIGQUERY_DEFAULT_DATASET": "searchconsole"
      },
      "args": [
        "/path/to/Suganthans-BigQuery-MCP-Server/dist/index.js"
      ],
      "command": "node"
    }
  }
}

Are you the author?

Add this badge to your README to show your security score and help users find safe servers.

Embed in your READMEAbout badges →

[![MCPpedia Score](https://mcppedia.org/api/badge/suganthans-bigquery-mcp-server)](https://mcppedia.org/s/suganthans-bigquery-mcp-server)

Read me

What Suganthans BigQuery MCP Server does

An MCP server for BigQuery that lets you ask Claude questions about your search data warehouse and get real answers. Not raw query results. Actual analysis with verdicts and recommendations.

Test This Server

Run this in your terminal to verify the server starts. Then let us know if it worked — your result helps other developers.

npx -y 'npm' 2>&1 | head -1 && echo "✓ Server started successfully"

After testing, let us know if it worked:

README

BigQuery MCP Server

An MCP server for BigQuery that lets you ask Claude questions about your search and analytics data warehouse and get real answers. Not raw query results. Actual analysis with verdicts and recommendations.

32 tools. GA4 + GSC revenue attribution. ML forecasting. Anomaly detection. Anonymous query analysis. Free and open source.

Full setup guide with screenshots: suganthan.com/blog/bigquery-mcp-server/

New in v4.0 (GA4 integration): suganthan.com/blog/google-analytics-bigquery-mcp-server/

See it in action

"How much of my traffic is hidden behind anonymous queries?"

"Forecast my traffic for the next 90 days"

"Are there any traffic anomalies I should investigate?"

"Show me year over year seasonal trends"

"Show me queries where mobile and desktop rank different pages"

"Break down my queries by search intent"

"What are the most common terms in my queries?"

"What new keywords appeared this week?"

What you can ask

What are my quick win keywords?
Which pages are losing traffic and why?
Forecast my traffic for the next 90 days
Are there any traffic anomalies I should investigate?
How much of my traffic comes from anonymous queries?
Show me year over year seasonal trends
What new keywords appeared this week?
Break down my queries by search intent
Show me queries where multiple pages are competing
Generate a full performance report
How does my CTR compare to benchmarks?
How is my /blog/ cluster performing?
Check for any SEO alerts in the last 7 days
Give me content recommendations

With the GA4 BigQuery export also connected (v4.0+):

Which keywords generate the most revenue?
Which pages have the biggest gap between rankings and conversions?
What is each search position worth on my site?
Which pages have a mismatch between their search snippet and actual content quality?
Compare branded vs non-branded performance for 'my brand, my-brand'
Show me page performance combining search and analytics data

Quick start

git clone https://github.com/Suganthan-Mohanadasan/Suganthans-BigQuery-MCP-Server.git
cd Suganthans-BigQuery-MCP-Server
npm install
npm run build

Add to your Claude Desktop config (~/Library/Application Support/Claude/claude_desktop_config.json):

{
  "mcpServers": {
    "bigquery": {
      "command": "node",
      "args": ["/path/to/Suganthans-BigQuery-MCP-Server/dist/index.js"],
      "env": {
        "BIGQUERY_PROJECT_ID": "your-project-id",
        "BIGQUERY_KEY_FILE": "/path/to/service-account-key.json",
        "BIGQUERY_DEFAULT_DATASET": "searchconsole",
        "BIGQUERY_LOCATION": "US"
      }
    }
  }
}

Your service account needs three IAM roles: BigQuery Data Editor, BigQuery Data Viewer, and BigQuery Job User.

Need help with BigQuery setup, bulk export, service accounts, or permissions? The full guide walks through every step with screenshots.

... View full README on GitHub

Loading README…

Scored, not listed

Why this score

Five weighted categories — click any category to see the underlying evidence.

Score breakdown

87/100across 5 weighted dimensions

How we score →

0255075100

−13

Security

Maintenance

Efficiency

Documentation

Compatibility

Categoriesclick a row to see evidence

Security

OSV.dev

8 fixed

CVE-2022-29244low · fixedCVSS 3.1

Packing does not respect root-level ignore files in workspaces

Affected: >= 7.9.0Fixed in 8.11.0source →

CVE-2018-7408low · fixedCVSS 3

Incorrect Permission Assignment for Critical Resource in NPM

Affected: >= 0Fixed in 5.7.1source →

CVE-2013-4116info · fixed

Local Privilege Escalation in npm

Affected: >= 0Fixed in 1.3.3source →

CVE-2020-15095low · fixedCVSS 3.1

npm CLI exposing sensitive information through logs

Affected: >= 0Fixed in 6.14.6source →

CVE-2019-16777low · fixedCVSS 3.1

npm Vulnerable to Global node_modules Binary Overwrite

Affected: >= 0Fixed in 6.13.4source →

Inventory

Tools (26)

Click any tool to inspect its schema.

~1.3k tokens total

Community

Reviews

Be the first to review

Have you used this server?

Share your experience — it helps other developers decide.

How easy was setup?Did it work reliably?How was the documentation?

Frequently Asked Questions

Is Suganthans BigQuery MCP Server safe to use?: Suganthans BigQuery MCP Server has no known CVEs as of the latest MCPpedia security scan. It does not require authentication, so any local process can connect — keep this in mind in shared environments. Licensed under Apache-2.0.
How do I install Suganthans BigQuery MCP Server?: Suganthans BigQuery MCP Server supports copy-paste install configs on its MCPpedia page for Claude Desktop, Cursor, and Claude Code. Scroll to the Quick Install section and select your client.
What can Suganthans BigQuery MCP Server do?: Suganthans BigQuery MCP Server provides 26 tools: gsc_anonymous_traffic, gsc_forecast, gsc_anomalies, gsc_seasonal, gsc_device_split and 21 more. See the full tools list on the server page for descriptions and parameters.
What AI clients work with Suganthans BigQuery MCP Server?: Suganthans BigQuery MCP Server is compatible with claude-desktop, cursor, claude-code. It uses stdio and sse transport.
Is Suganthans BigQuery MCP Server actively maintained?: Suganthans BigQuery MCP Server is actively maintained — last commit was 27 days ago. It has 35 GitHub stars.