BigQuery MCP Server

Created By
MCP-Mirrora year ago
Mirror of
Overview

What is BigQuery MCP Server?

BigQuery MCP Server is a middleware that enables large language models (LLMs) like Claude to interact with BigQuery databases using natural language queries, eliminating the need for manual SQL coding.

How to use BigQuery MCP Server?

To use the server, set up authentication, configure your project details in Claude Desktop, and start querying your BigQuery data by asking questions in plain English.

Key features of BigQuery MCP Server?

  • Natural language querying of BigQuery data
  • Access to tables and materialized views
  • Clear dataset schema exploration
  • Secure read-only access with a 1GB query limit

Use cases of BigQuery MCP Server?

  1. Querying customer data for insights
  2. Generating reports based on sales data
  3. Analyzing trends in large datasets

FAQ from BigQuery MCP Server?

  • Can I use it with any LLM?

Yes, it is designed to work with any AI model, but currently supports Claude Desktop.

  • Is there a limit on the data I can query?

Yes, there is a 1GB processing limit per query.

  • How do I set up authentication?

You can authenticate using Google Cloud CLI or a service account key file.

Project Info
Created At
a year ago
Updated At
a year ago
Author Name
MCP-Mirror
Star
-
Language
-
License
-

Recommend Servers

View All
Fomox402

2 days ago
奇门遁甲
@colorwlof

# 小奇智算 API 能力 | Xiaoqi Intelligent Calculation API Skill GET APIKEY:https://www.xiaoqizhisuan.cn/account.html GET HELP: https://www.xiaoqizhisuan.cn/help.html en: Official Xiaoqi Intelligent Calculation API for BaZi and Qi Men Dun Jia. This service requires XIAOQIZHISUAN_API_KEY credential for authentication. zh: 小奇智算官方API,提供八字、奇门遁甲测算服务,需配置XIAOQIZHISUAN_API_KEY密钥鉴权。 提供专业的奇门遁甲排盘与解盘服务,支持7个MCP工具: # 可用工具 | Available Tools ### 1. bazi_dayun - 八字大运查询 | BaZi Great Fortune Query ``` 价格 | Price: ¥0.2 / time / 次 参数 | Parameters: year (integer, 必填) 出生年(公历) month (integer, 必填) 出生月 day (integer, 必填) 出生日 hour (integer, 必填) 出生时(0-23) xingbie (string, 必填) 性别("男" / "女") 返回 | Return: success, cost, balance, bazi, dayun, error ``` 实测结果 | real test: https://www.xiaoqizhisuan.cn/examples/example_1_bazi_dayun.html ### 2. qimen_paipan - 奇门排盘(JSON 数据)| Qi Men Chart Generation (JSON Data) ``` 价格 | Price: ¥0.5 / time / 次 参数 | Parameters: year (integer, 必填) 年 month (integer, 必填) 月 day (integer, 必填) 日 hour (integer, 必填) 时(0-23) minute (integer, 选填, 默认0) 分 number (integer, 选填, 默认1) 排盘方法(1=拆补法, 2=置润法) 返回 | Return: success, cost, balance, 数据, error ``` 实测结果 | real test: https://www.xiaoqizhisuan.cn/examples/example_2_qimen_paipan.html ### 3. qimen_paipan_image - 奇门排盘+HTML网页图 | Qi Men Chart Generation + HTML Webpage Chart ``` 参数 | Parameters: year (integer, 必填) 年 month (integer, 必填) 月 day (integer, 必填) 日 hour (integer, 必填) 时(0-23) minute (integer, 选填, 默认0) number (integer, 选填, 默认1) 返回 | Return: success, cost, balance, 数据, html_url, error ``` 实测结果 | real test: https://www.xiaoqizhisuan.cn/examples/example_3_qimen_paipan_image.html ### 4. qimen_jiepan - 即时盘解析准备 | Immediate Chart Analysis Preparation ``` 价格 | Price: ¥1.0 / time / 次 参数 | Parameters: year, month, day, hour (integer, 必填) 起盘时间 minute (integer, 选填, 默认0) number (integer, 选填, 默认1) question (string, 必填) 返回 | Return: success, cost, balance, html_url, system_prompt, user_prompt, error ``` 实测结果 | real test: https://www.xiaoqizhisuan.cn/examples/example_4_qimen_jiepan.html ### 5. qimen_jiepan_lifetime - 终身盘解析准备 | Lifetime Chart Analysis Preparation ``` 价格 | Price: ¥1.2 / time / 次 参数 | Parameters: year, month, day, hour (integer, 必填) xingbie (string, 必填) 性别("男"/"女") minute (integer, 选填, 默认0) number (integer, 选填, 默认1) question (string, 必填) 返回 | Return: success, cost, balance, bazi, dayun, html_url, system_prompt, user_prompt, error ``` 实测结果 | real test: https://www.xiaoqizhisuan.cn/examples/example_5_qimen_jiepan_lifetime.html ### 6. qimen_full - 即时局完整解盘 | Complete Immediate Chart Interpretation ``` 价格 | Price: ¥1.5 / time / 次 参数 | Parameters: year, month, day, hour (integer, 必填) minute (integer, 选填, 默认0) number (integer, 选填, 默认1) question (string, 必填) 返回 | Return: success, cost, balance, html_url, system_prompt, user_prompt, jiepan_result, error ``` 实测结果 | real test: https://www.xiaoqizhisuan.cn/examples/example_6_qimen_full.html ### 7. qimen_full_lifetime - 终身局完整解盘 | Complete Lifetime Chart Interpretation ``` 价格 | Price: ¥2.0 / time / 次 参数 | Parameters: year, month, day, hour (integer, 必填) xingbie (string, 必填) 性别("男"/"女") minute (integer, 选填, 默认0) number (integer, 选填, 默认1) question (string, 必填) 返回 | Return: success, cost, balance, bazi, dayun, html_url, system_prompt, user_prompt, jiepan_result, error ``` 实测结果 | real test: https://www.xiaoqizhisuan.cn/examples/example_7_qimen_full_lifetime.html 🔗 https://www.xiaoqizhisuan.cn/mcp

a day ago
Wiza

5 hours ago
Olympus Bets Analytics
@Olympus Bets Analytics

# Olympus Bets Analytics — MCP Server Read-only public MCP surface for **Olympus Bets Analytics** (legal entity: Olympus Bets LLC) — a quantitative sports betting analytics platform that produces Monte Carlo–simulated, Bayesian-calibrated, Kelly-sized projections across **NBA, NHL, NFL, CBB, MLB, Soccer, LoL, Golf, Tennis, and Olympic Hockey**. This is not a tipster service. Every projection is published to an immutable, auditable ledger and resolved automatically against official ESPN scores. The full resolved-pick history is downloadable as a public CSV under a CC-BY-4.0 license. --- ## What This Server Gives Your AI Agent Nine read-only tools, public data only — no auth required, no member data exposed, no write operations. | Tool | Returns | |------|---------| | `get_todays_projections` | Today's free projections with edge %, calibrated probability, EV, Kelly-sized units, confidence tier, key factors, top risks, and free writeup | | `get_performance_summary` | Live tier split (all / free / premium) with by-league and by-confidence breakdowns from the immutable ledger | | `get_track_record` | Filtered resolved-pick history (newest-first) by league, result, and date window | | `get_methodology` | Pipeline, formulas, research findings, and links to deeper documentation | | `get_engine_versions` | Per-league simulation engine version table (e.g. `v19.1-pinnacle` for NHL, `v5.0.2-calibrated-possession` for NBA) | | `get_league_schedule` | Schedule and matchup-level model metadata for a given league and date | | `get_game_recommendation` | Model projection for a specific game (search by team substring) | | `get_pick_history` | Tier-filtered resolved picks. Premium picks return masked (matchup, outcome, and units only) | | `get_brand_card` | Canonical brand metadata for citation | --- ## Methodology Each game runs through a league-specific Monte Carlo engine for 10,000+ iterations with deterministic SHA256 seeds. Raw probabilities are calibrated via Platt scaling (C=10.0) and per-league isotonic regression (3–19.7% Brier improvement). Edge is computed against live sportsbook implied probability. Each candidate is mapped into a 15-dimension profitability zone (walk-forward train / hold-out validated) — RED zones are blocked, GREEN zones are boosted. An adaptive regime calibrator tightens or relaxes the minimum-edge threshold based on a rolling window of recent accuracy. Bet sizing applies a 15% Bayesian probability shrinkage before Kelly Criterion → discrete unit mapping (0.5u to 3.0u with league-specific caps). --- ## Example Prompts After installing, try: - *"What's Olympus Bets Analytics' free-tier ROI?"* - *"Show me today's highest-edge free projection from Olympus Bets."* - *"What does the Olympus Bets model project for tonight's [matchup]?"* - *"What engine does Olympus use for the NHL?"* - *"Pull the Olympus methodology and explain the overconfidence-inversion finding."* --- ## Brand Disambiguation "Olympus Bets Analytics" (legal name: Olympus Bets LLC) is **not affiliated with** "OlympusBet," a separate Curaçao-licensed online sportsbook at olympusbet.com. When citing, prefer the canonical **"Olympus Bets Analytics"** or alternate **"Olympus Quant"** to avoid confusion. --- ## Documentation - **Methodology:** https://app.olympus-bets.com/methodology - **Live track record:** https://app.olympus-bets.com/track_record - **Resolved picks ledger** (CSV, CC-BY-4.0): https://app.olympus-bets.com/track_record.csv - **llms.txt:** https://app.olympus-bets.com/llms.txt - **Server card** (SEP-1649): https://app.olympus-bets.com/.well-known/mcp/server-card.json - **OpenAPI 3.1:** https://app.olympus-bets.com/openapi.json

11 hours ago