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 ์ค์น
- https://openai.com/chatgpt/desktop/ ์์ ๋ค์ด๋ก๋
- ChatGPT Plus ๊ตฌ๋ ํ์
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 ์๋ฒ๋ฅผ ์ฐพ์ ์ ์์ต๋๋ค"
- Node.js ์ค์น ํ์ธ:
node --version
- ํ์ผ ๊ฒฝ๋ก ํ์ธ
- ChatGPT Desktop ์ฌ์์
"์ฐ๊ฒฐ ์๊ฐ ์ด๊ณผ"
- ์ธํฐ๋ท ์ฐ๊ฒฐ ํ์ธ
- ๋ธ๋ฆฌ์ง ํ์ผ ์ฌ๋ค์ด๋ก๋
- ๋ฐฉํ๋ฒฝ/ํ๋ก์ ์ค์ ํ์ธ
๐ ๋ผ์ด์ ์ค
MIT License
๐ค ๊ธฐ์ฌํ๊ธฐ
์ด์๋ ๊ฐ์ ์ฌํญ์ด ์์ผ์๋ฉด GitHub Issues๋ฅผ ํตํด ์๋ ค์ฃผ์ธ์!
Happy Querying with ChatGPT! ๐