MCP Bigquery Server

🚀 MCP BigQuery Server

MCP BigQuery Server is a server that allows you to query BigQuery tables using MCP. Written in Go, it is lightweight and easy to install with just a few commands.

🚀 Quick Start

MCP BigQuery Server enables users to perform queries on BigQuery tables via MCP. It offers a convenient way to interact with BigQuery data.

✨ Features

• Lightweight: Built with Go, it consumes minimal resources.
• Easy Installation: Can be installed with just a few commands.
• Multiple Tools: Provides several useful tools for querying and managing BigQuery data.

📦 Installation

$ brew tap monochromegane/tap
$ brew install monochromegane/tap/mcp-bigquery-server

💻 Usage Examples

Available Tools

• list_allowed_datasets: Get a list of all allowed datasets.
• list_tables: Get detailed information about all tables in a specified dataset.
• get_table_schema: Get the schema of a specified table in a specified dataset.
• dry_run_query: Perform a dry run to get the estimated cost and time.

Registration

To use MCP BigQuery Server in Cursor, add the following configuration to your .cursor/mcp.json file:

{
  "mcpServers": {
    "BigQuery": {
      "command": "mcp-bigquery-server",
      "args": [
        "start",
        "--project",
        "sample-project",
        "--dataset",
        "test1",
        "--dataset",
        "test2"
      ]
    }
  }
}

⚠️ Important Note

You can specify multiple datasets by repeating the --dataset parameter.

📄 License

MIT

👨‍💻 Author

mono-chromatic