bigquery-mcp-bridge

jaewon-parkJP/bigquery-mcp-bridge

3.2

If you are the rightful owner of bigquery-mcp-bridge and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

The BigQuery MCP Bridge connects ChatGPT Desktop with BigQuery MCP server, enabling natural language data queries and analysis.

๐ŸŒ‰ BigQuery MCP Bridge

ChatGPT Desktop๊ณผ BigQuery MCP ์„œ๋ฒ„๋ฅผ ์—ฐ๊ฒฐํ•˜๋Š” ๋ธŒ๋ฆฌ์ง€

์ด ๋ธŒ๋ฆฌ์ง€๋ฅผ ์‚ฌ์šฉํ•˜๋ฉด ChatGPT Desktop ์•ฑ์—์„œ ์ž์—ฐ์–ด๋กœ BigQuery ๋ฐ์ดํ„ฐ๋ฅผ ์กฐํšŒํ•˜๊ณ  ๋ถ„์„ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

๐Ÿš€ ๋น ๋ฅธ ์‹œ์ž‘

1๋‹จ๊ณ„: ChatGPT Desktop ์„ค์น˜

2๋‹จ๊ณ„: ๋ธŒ๋ฆฌ์ง€ ํŒŒ์ผ ๋‹ค์šด๋กœ๋“œ

Windows (PowerShell):

cd $env:USERPROFILE\Documents
mkdir bigquery-chatgpt
cd bigquery-chatgpt
Invoke-WebRequest -Uri "https://raw.githubusercontent.com/jaewon-parkJP/bigquery-mcp-bridge/main/http-to-stdio-bridge.js" -OutFile "http-to-stdio-bridge.js"

Mac (Terminal):

cd ~/Documents
mkdir bigquery-chatgpt
cd bigquery-chatgpt
curl -o http-to-stdio-bridge.js https://raw.githubusercontent.com/jaewon-parkJP/bigquery-mcp-bridge/main/http-to-stdio-bridge.js
chmod +x http-to-stdio-bridge.js

3๋‹จ๊ณ„: ChatGPT MCP ์„ค์ •

Windows:

mkdir "$env:APPDATA\OpenAI\ChatGPT" -Force
@"
{
  "mcpServers": {
    "bigquery": {
      "command": "node",
      "args": [
        "$($env:USERPROFILE)\\Documents\\bigquery-chatgpt\\http-to-stdio-bridge.js"
      ],
      "cwd": "$($env:USERPROFILE)\\Documents\\bigquery-chatgpt",
      "env": {
        "NODE_ENV": "production"
      }
    }
  }
}
"@ | Out-File -FilePath "$env:APPDATA\OpenAI\ChatGPT\mcp_servers.json" -Encoding utf8

Mac:

mkdir -p ~/Library/Application\ Support/OpenAI/ChatGPT
cat > ~/Library/Application\ Support/OpenAI/ChatGPT/mcp_servers.json << 'EOF'
{
  "mcpServers": {
    "bigquery": {
      "command": "node",
      "args": [
        "~/Documents/bigquery-chatgpt/http-to-stdio-bridge.js"
      ],
      "cwd": "~/Documents/bigquery-chatgpt",
      "env": {
        "NODE_ENV": "production"
      }
    }
  }
}
EOF

4๋‹จ๊ณ„: ChatGPT Desktop ์žฌ์‹œ์ž‘ ๋ฐ ํ…Œ์ŠคํŠธ

ChatGPT Desktop์„ ์žฌ์‹œ์ž‘ํ•œ ํ›„:

BigQuery ์„œ๋ฒ„ ์ƒํƒœ๋ฅผ ํ™•์ธํ•ด์ค˜

๐ŸŽฏ ์‚ฌ์šฉ ์˜ˆ์‹œ

"BigQuery์— ์–ด๋–ค ๋ฐ์ดํ„ฐ๊ฐ€ ์žˆ๋Š”์ง€ ์•Œ๋ ค์ค˜"
"๋ฆฌ๋ทฐ ๊ด€๋ จ ํ…Œ์ด๋ธ”์„ ์ฐพ์•„์ค˜"
"์ตœ๊ทผ ๊ฑฐ๋ถ€๋œ ๋ฆฌ๋ทฐ๋“ค์˜ ํ†ต๊ณ„๋ฅผ ๋ณด์—ฌ์ค˜"
"ํ‰๊ท  ์—ฐ๋ด‰์ด ๋†’์€ ์ƒ์œ„ 10๊ฐœ ํšŒ์‚ฌ๋ฅผ ์ฐพ์•„์ค˜"

๐Ÿ› ๏ธ ๊ธฐ์ˆ  ์„ธ๋ถ€์‚ฌํ•ญ

์•„ํ‚คํ…์ฒ˜

ChatGPT Desktop โ†” http-to-stdio-bridge.js โ†” BigQuery MCP Server โ†” BigQuery
     (STDIO)              (Node.js)              (HTTP/JSON-RPC)      (SQL)

์ง€์› ๊ธฐ๋Šฅ

  • ๐Ÿ“Š ๋ฐ์ดํ„ฐ ํƒ์ƒ‰: 61๊ฐœ ๋ฐ์ดํ„ฐ์…‹, 1000+ ํ…Œ์ด๋ธ”
  • ๐Ÿ” ์ž์—ฐ์–ด ์ฟผ๋ฆฌ: "์ตœ๊ทผ ๋ฆฌ๋ทฐ ํ†ต๊ณ„" โ†’ SQL ์ž๋™ ์ƒ์„ฑ
  • โšก ์‹ค์‹œ๊ฐ„ ์‹คํ–‰: ์ฟผ๋ฆฌ ์‹คํ–‰ ๋ฐ ๊ฒฐ๊ณผ ๋ถ„์„
  • ๐Ÿ”’ ๋ณด์•ˆ: ์ฝ๊ธฐ ์ „์šฉ, ๋น„์šฉ ์ œ์–ด

์š”๊ตฌ์‚ฌํ•ญ

  • Node.js 16.0.0+
  • ChatGPT Plus ๊ตฌ๋…
  • ์ธํ„ฐ๋„ท ์—ฐ๊ฒฐ

๐Ÿšจ ๋ฌธ์ œ ํ•ด๊ฒฐ

"MCP ์„œ๋ฒ„๋ฅผ ์ฐพ์„ ์ˆ˜ ์—†์Šต๋‹ˆ๋‹ค"

  1. Node.js ์„ค์น˜ ํ™•์ธ: node --version
  2. ํŒŒ์ผ ๊ฒฝ๋กœ ํ™•์ธ
  3. ChatGPT Desktop ์žฌ์‹œ์ž‘

"์—ฐ๊ฒฐ ์‹œ๊ฐ„ ์ดˆ๊ณผ"

  1. ์ธํ„ฐ๋„ท ์—ฐ๊ฒฐ ํ™•์ธ
  2. ๋ธŒ๋ฆฌ์ง€ ํŒŒ์ผ ์žฌ๋‹ค์šด๋กœ๋“œ
  3. ๋ฐฉํ™”๋ฒฝ/ํ”„๋ก์‹œ ์„ค์ • ํ™•์ธ

๐Ÿ“„ ๋ผ์ด์„ ์Šค

MIT License

๐Ÿค ๊ธฐ์—ฌํ•˜๊ธฐ

์ด์Šˆ๋‚˜ ๊ฐœ์„ ์‚ฌํ•ญ์ด ์žˆ์œผ์‹œ๋ฉด GitHub Issues๋ฅผ ํ†ตํ•ด ์•Œ๋ ค์ฃผ์„ธ์š”!


Happy Querying with ChatGPT! ๐Ÿš€