E

Ergut MCP Bigquery Server

Certified
This is a server that allows an LLM (such as Claude) to directly interact with the BigQuery database. It acts as a secure translation layer between the AI assistant and the database, supporting data query in natural language without manually writing SQL.
2 points
8

What is the BigQuery MCP Server?

This is a server that acts as a translator between the AI assistant and the BigQuery database, allowing you to query data in natural language without writing SQL. It is based on the Model Context Protocol (MCP) and currently supports Claude Desktop.

How to use the BigQuery MCP Server?

Simply complete the authentication configuration and add project information to the Claude Desktop configuration file, and you can start querying data in natural language.

Applicable scenarios

Suitable for business personnel, data analysts, and product managers who need to frequently query BigQuery data but do not want to write SQL.

Main features

Natural language queryGet data by asking questions in everyday English without writing SQL
Schema explorationClearly display the dataset structure and distinguish between tables and views
Data securityRead-only access with a default query limit of 1GB

Advantages and limitations

Advantages
Query data without SQL knowledge
Support access to tables and views
Secure read-only access
Seamless integration with Claude
Limitations
Currently only supports Claude Desktop
Only local MCP server connections are allowed
There is a 1GB processing limit for queries
There may be limitations for certain complex view types

How to use

Installation preparation
Ensure that Node.js 14+ and Google Cloud CLI are installed
Authentication configuration
Choose to log in with Google Cloud CLI or use a service account
Add to Claude configuration
Modify the claude_desktop_config.json file

Usage examples

Sales data analysisQuery sales performance within a specific time period
Customer insightsGet information about high-value customers

Frequently asked questions

What permissions are required to use it?
Which AI models are supported?
Are there any query limitations?

Related resources

GitHub repository
Project source code and issue tracking
Smithery protocol page
Official protocol documentation
OREDATA official website
Project sponsor website
Installation
Copy the following command to your Client for configuration
{
       "mcpServers": {
         "bigquery": {
           "command": "npx",
           "args": [
             "-y",
             "@ergut/mcp-bigquery-server",
             "--project-id",
             "your-project-id",
             "--location",
             "us-central1"
           ]
         }
       }
     }

{
       "mcpServers": {
         "bigquery": {
           "command": "npx",
           "args": [
             "-y",
             "@ergut/mcp-bigquery-server",
             "--project-id",
             "your-project-id",
             "--location",
             "us-central1",
             "--key-file",
             "/path/to/service-account-key.json"
           ]
         }
       }
     }

{
  "mcpServers": {
    "bigquery": {
      "command": "node",
      "args": [
        "/path/to/your/clone/mcp-bigquery-server/dist/index.js",
        "--project-id",
        "your-project-id",
        "--location",
        "us-central1",
        "--key-file",
        "/path/to/service-account-key.json"
      ]
    }
  }
}
Note: Your key is sensitive information, do not share it with anyone.
N
Notte Browser
Certified
Notte is an open-source full-stack network AI agent framework that provides browser sessions, automated LLM-driven agents, web page observation and operation, credential management, etc. It aims to transform the Internet into an agent-friendly environment and reduce the cognitive burden of LLMs by describing website structures in natural language.
658
4.5 points
B
Bing Search MCP
An MCP server for integrating Microsoft Bing Search API, supporting web page, news, and image search functions, providing network search capabilities for AI assistants.
Python
227
4 points
M
MCP Alchemy
Certified
MCP Alchemy is a tool that connects Claude Desktop to multiple databases, supporting SQL queries, database structure analysis, and data report generation.
Python
321
4.2 points
P
Postgresql MCP
A PostgreSQL database MCP service based on the FastMCP library, providing CRUD operations, schema inspection, and custom SQL query functions for specified tables.
Python
110
4 points
C
Cloudflare
Changesets is a build tool for managing versions and releases in multi - package or single - package repositories.
TypeScript
1.5K
5 points
E
Eino
Eino is an LLM application development framework designed specifically for Golang, aiming to simplify the AI application development process through concise, scalable, reliable, and efficient component abstraction and orchestration capabilities. It provides a rich component library, powerful graphical orchestration functions, complete stream processing support, and a highly scalable aspect mechanism, covering the full-cycle toolchain from development to deployment.
Go
3.5K
5 points
M
Modelcontextprotocol
Certified
This project is an implementation of an MCP server integrated with the Sonar API, providing real-time web search capabilities for Claude. It includes guides on system architecture, tool configuration, Docker deployment, and multi-platform integration.
TypeScript
1.1K
5 points
A
Awesome MCP List
This is a continuously updated curated list of MCP servers, covering multiple categories such as browser control, art and culture, cloud platforms, command - line, communication, customer data platforms, databases, developer tools, data science tools, file systems, finance and fintech, games, knowledge and memory, location services, marketing, monitoring, search, and utilities. Each project comes with a GitHub link and the number of stars, making it easy for users to quickly understand and use.
709
5 points
Featured MCP Services
D
Duckduckgo MCP Server
Certified
The DuckDuckGo Search MCP Server provides web search and content scraping services for LLMs such as Claude.
Python
827
4.3 points
G
Gitlab MCP Server
Certified
The GitLab MCP server is a project based on the Model Context Protocol that provides a comprehensive toolset for interacting with GitLab accounts, including code review, merge request management, CI/CD configuration, and other functions.
TypeScript
85
4.3 points
M
Markdownify MCP
Markdownify is a multi-functional file conversion service that supports converting multiple formats such as PDFs, images, audio, and web page content into Markdown format.
TypeScript
1.7K
5 points
N
Notion Api MCP
Certified
A Python-based MCP Server that provides advanced to-do list management and content organization functions through the Notion API, enabling seamless integration between AI models and Notion.
Python
140
4.5 points
U
Unity
Certified
UnityMCP is a Unity editor plugin that implements the Model Context Protocol (MCP), providing seamless integration between Unity and AI assistants, including real - time state monitoring, remote command execution, and log functions.
C#
563
5 points
F
Figma Context MCP
Framelink Figma MCP Server is a server that provides access to Figma design data for AI programming tools (such as Cursor). By simplifying the Figma API response, it helps AI more accurately achieve one - click conversion from design to code.
TypeScript
6.7K
4.5 points
M
Minimax MCP Server
The MiniMax Model Context Protocol (MCP) is an official server that supports interaction with powerful text-to-speech, video/image generation APIs, and is suitable for various client tools such as Claude Desktop and Cursor.
Python
752
4.8 points
G
Gmail MCP Server
A Gmail automatic authentication MCP server designed for Claude Desktop, supporting Gmail management through natural language interaction, including complete functions such as sending emails, label management, and batch operations.
TypeScript
282
4.5 points
AIbase
Zhiqi Future, Your AI Solution Think Tank
© 2025AIbase