logo
Login
Cover image
MCP-Server
Private

MCP-Server

Try Now
2025-04-14

Modellkontextprotokoll -Implementierung, die Ihre LLM mit Firebolt verbindet

3 years

Works with Finder

2

Github Watches

0

Github Forks

2

Github Stars


Firebolt
MCP Server

A Model Context Protocol implementation that connects your LLM to Firebolt Data Warehouse

Key Features | How To Use | Connecting Your LLM | Architecture | Development

Key Features

LLM Integration with Firebolt

  • Connect your AI assistants directly to your data warehouse
  • Enable AI agents to autonomously query data and generate insights
  • Provide LLMs with deep knowledge of Firebolt SQL, features, and documentation

SQL Query Execution

  • Support for multiple query types and execution modes
  • Direct access to Firebolt databases

Documentation Access

  • Grant LLMs access to comprehensive Firebolt docs, SQL reference, function lists, and more

Account Management

  • Seamless authentication with Firebolt service accounts
  • Connect to different engines and workspaces

Multi-platform Support

  • Runs anywhere Go binaries are supported
  • Official Docker image available for easy deployment

How To Use

Before you start, ensure you have a Firebolt service account with a client ID and client secret.

Installing the MCP Server

You can run the Firebolt MCP Server either via Docker or by downloading the binary.

Option 1: Run with Docker

docker run \
  --rm \
  -e FIREBOLT_MCP_CLIENT_ID=your-client-id \
  -e FIREBOLT_MCP_CLIENT_SECRET=your-client-secret \
  ghcr.io/firebolt-db/mcp-server:0.2.1

Option 2: Run the Binary

# Download the binary for your OS from:
# https://github.com/firebolt-db/mcp-server/releases/tag/v0.2.1

./firebolt-mcp-server \
  --client-id your-client-id \
  --client-secret your-client-secret

Connecting Your LLM

Once the MCP Server is installed, you can connect various LLM clients.

Below are integration examples for Claude Desktop. For other clients like VSCode Copilot Chat and Cursor, please refer to their official documentation.

Claude Desktop

To integrate with Claude Desktop using Docker:

  1. Open the Claude menu and select Settings….

  2. Navigate to Developer > Edit Config.

  3. Update the configuration file (claude_desktop_config.json) to include:

    {
  "mcpServers": {
    "firebolt": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e", "FIREBOLT_MCP_CLIENT_ID",
        "-e", "FIREBOLT_MCP_CLIENT_SECRET",
        "ghcr.io/firebolt-db/mcp-server:0.2.1"
      ],
      "env": {
        "FIREBOLT_MCP_CLIENT_ID": "your-client-id",
        "FIREBOLT_MCP_CLIENT_SECRET": "your-client-secret"
      }
    }
  }
}

    To use the binary instead of Docker:

    {
  "mcpServers": {
    "firebolt": {
      "command": "/path/to/firebolt-mcp-server",
      "env": {
        "FIREBOLT_MCP_CLIENT_ID": "your-client-id",
        "FIREBOLT_MCP_CLIENT_SECRET": "your-client-secret"
      }
    }
  }
}

  4. Save the config and restart Claude Desktop.

More details: Claude MCP Quickstart Guide

GitHub Copilot Chat (VSCode)

To integrate MCP with Copilot Chat in VSCode, refer to the official documentation:

👉 Extending Copilot Chat with the Model Context Protocol

Cursor Editor

To set up MCP in Cursor, follow their guide:

👉 Cursor Documentation on Model Context Protocol

Using SSE Transport

By default, the MCP Server uses STDIO as the transport mechanism.
However, Server-Sent Events (SSE) are also supported and require additional configuration.

To enable SSE, set the --transport CLI flag (or the FIREBOLT_MCP_SERVER_TRANSPORT environment variable) to sse.

Optionally, you can specify the address the server should listen on by setting the --transport-sse-listen-address CLI flag (or the FIREBOLT_MCP_TRANSPORT_SSE_LISTEN_ADDRESS environment variable).

Architecture

Firebolt MCP Server implements the Model Context Protocol, providing:

  1. Tools - Task-specific capabilities provided to the LLM:

    • firebolt_docs: Access Firebolt documentation
    • firebolt_connect: Establish connections to Firebolt engines and databases
    • firebolt_query: Execute SQL queries against Firebolt

  2. Resources - Data that can be referenced by the LLM:

    • Documentation articles
    • Lists of Accounts, Databases, Engines

  3. Prompts - Predefined instructions for the LLM:

    • Firebolt Expert: Prompts the model to act as a Firebolt specialist

Development

To set up the development environment:

# Clone this repository
git clone https://github.com/firebolt-db/mcp-server.git

# Go into the repository
cd mcp-server

# Install Task (if you don't have it already)
go install github.com/go-task/task/v3/cmd/task@latest

# Update Go dependencies
task mod

# Build the application
task build

# Run the tests
task test

相关推荐

Hafen

Hafen

  • av

    • Führen Sie mühelos LLM -Backends, APIs, Frontends und Dienste mit einem Befehl aus.

    2 (1)
    Awesome-llm-Ressourse

    Awesome-llm-Ressourse

  • WangRongsheng

    • 🧑‍🚀 全世界最好的 llm 资料总结（数据处理、模型训练、模型部署、 O1 模型、 MCP 、小语言模型、视觉语言模型） | Zusammenfassung der weltbesten LLM -Ressourcen.

    3.5 (4)
    1Panel

    1Panel

  • 1Panel-dev

    • 🔥 1Panel bietet eine intuitive Weboberfläche und einen MCP -Server, um Websites, Dateien, Container, Datenbanken und LLMs auf einem Linux -Server zu verwalten.

    2 (1)
    Rulleego

    Rulleego

  • rulego

    • ⛓️Rugele ist ein leichter, leistungsstarker, leistungsstarker, eingebetteter Komponenten-Orchestrierungsregel-Motor-Rahmen für GO.

    3.7 (10)
    CPP-MCP

    CPP-MCP

  • hkr04

    • Leichtes C ++ MCP (Modellkontextprotokoll) SDK

    3 (1)
    LLM-Funktionen

    LLM-Funktionen

  • sigoden

    • Erstellen Sie einfach LLM -Tools und -Argarten mit einfachen Bash/JavaScript/Python -Funktionen.

    1 (1)
    Langbot

    Langbot

  • RockChinQ

    • 😎简单易用、🧩丰富生态 - 大模型原生即时通信机器人平台 | 适配 qq / 微信（企业微信、个人微信） / 飞书 / 钉钉 / diskord / telegram / slack 等平台 | 支持 Chatgpt 、 Deepseek 、 Diffy 、 Claude 、 Gemini 、 xai 、 ppio 、 、 ulama 、 lm Studio 、阿里云百炼、火山方舟、 siliconflow 、 qwen 、 mondshot 、 chatglm 、 sillytraven 、 mcp 等 llm 的机器人 / agent | LLM-basierte Instant Messaging Bots-Plattform, unterstützt Zwietracht, Telegramm, Wechat, Lark, Dingtalk, QQ, Slack

    5 (1)
    AgentsCope

    AgentsCope

  • modelscope

    • Bauen Sie LLM-Multi-Agent-Anwendungen auf einfachere Weise auf.

    2 (1)
    Minima

    Minima

  • dmayboroda

    • On-Premise-Konversationslappen mit konfigurierbaren Behältern

    3 (5)

    Reviews

    2.8 (13)
    Avatar
    user_eI6IQANK
    2025-04-24

    As a dedicated user of mcp-server, I must say that this product by Firebolt-DB is exceptional. It's highly efficient and has streamlined server management for our team. The connection speed is unparalleled, and the interface is incredibly user-friendly. The setup process was seamless, thanks to the clear and welcoming instructions provided at the start URL. Overall, I highly recommend mcp-server to anyone looking to enhance their server operations!

    Avatar
    user_kG58T8ZR
    2025-04-24

    As a dedicated user of mcp-server by firebolt-db, I can confidently say that this tool has significantly streamlined our server management tasks. Its intuitive interface and robust features make it an invaluable asset for our development team. The performance and reliability it offers are unmatched, and we have seen noticeable improvements in our workflow efficiency. Highly recommend!

    Avatar
    user_uzV700ET
    2025-04-24

    I have been using the mcp-server by firebolt-db and I am thoroughly impressed! It offers seamless integration and performance that is unparalleled. The user interface is intuitive and the customer support from firebolt-db has been exceptional. Highly recommended for anyone needing a reliable and efficient server solution!

    Avatar
    user_IIQYSBpg
    2025-04-24

    As a dedicated user of mcp-server by firebolt-db, I must say it has significantly improved my data management process. The seamless integration and robust performance have been game changers for my projects. Highly recommend it to anyone looking for a reliable server solution!

    Avatar
    user_CoIiMFZu
    2025-04-24

    As a dedicated user of mcp-server by firebolt-db, I can confidently say that this tool is exceptional. It seamlessly integrates with my existing systems, offering robust and reliable performance. The interface is user-friendly, making it easy to deploy and manage. I highly recommend mcp-server for anyone looking to optimize their server management solutions.

    Avatar
    user_t09cI6Kl
    2025-04-24

    I've been using mcp-server by firebolt-db, and it's a game changer for my projects. It's reliable and efficient, ensuring smooth server performance. The user-friendly interface made the setup a breeze, and I've noticed significant improvements in data handling and speed. Highly recommend it to anyone looking to optimize server operations!

    Avatar
    user_BCzBPE5k
    2025-04-24

    I've been using mcp-server by firebolt-db, and it has significantly improved my data management tasks. Its seamless integration and robust performance make it a standout product in its category. Highly recommended for anyone looking to streamline their server operations efficiently!

    Avatar
    user_dAgqT93H
    2025-04-24

    I've been using mcp-server by firebolt-db and it has revolutionized my data management workflow. The seamless integration and powerful language support make it an essential tool for any data-driven project. Highly recommend for anyone seeking efficiency and reliability!

    Avatar
    user_wCmseBXf
    2025-04-24

    As a loyal user of mcp-server by firebolt-db, I highly recommend it for anyone in need of a reliable server management tool. This product stands out for its robust features and user-friendly interface, making the process of managing servers seamless and efficient. The support from the Firebolt team is excellent, and their commitment to continuous improvement ensures the server remains up-to-date with the latest advancements.

    Avatar
    user_PPT9MdyR
    2025-04-24

    As a dedicated user of mcp-server by firebolt-db, I must say this tool is exceptional for database management. It offers robust features, seamless user experience, and impressive performance. Highly recommend for any business in need of reliable server solutions.

    Avatar
    user_bmrGLKSv
    2025-04-24

    I've been using mcp-server by firebolt-db and I'm thoroughly impressed with its performance and reliability. The ease of configuration and seamless integration into my existing workflow has truly been transformative. Highly recommend it for anyone looking to enhance their server management capabilities.

    Avatar
    user_IRYYJwMy
    2025-04-24

    As a dedicated user of mcp-server by firebolt-db, I am continuously impressed by its seamless performance and robust capabilities. The integration process is smooth, and the user-friendly interface makes it approachable even for those new to database management. With mcp-server, managing and scaling databases is straightforward and efficient. Highly recommended for both beginners and advanced users.

    Avatar
    user_tmrkCDEq
    2025-04-24

    As a dedicated user of mcp-server by firebolt-db, I can confidently say this application has transformed our server management experience. The seamless integration and user-friendly interface make it a must-have for efficient database operations. Highly recommend it for its reliability and performance!