Mcp Server
About
Connect your LLM to the Firebolt Data Warehouse for data querying and analysis.
Details
- License
- Apache-2.0
Explore
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
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
Mcp ServerCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Before you start, ensure you have either:
- A Firebolt service account with a client ID and client secret.
- A Firebolt Core instance URL.
You can run the Firebolt MCP Server either via Docker or by downloading the binary.
For any MCP client that uses a JSON config (e.g. mcpServers), you can add the Firebolt server with the following canonical configuration. Firebolt Cloud (Docker):
{
"mcpServers": {
"firebolt": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"--network", "host",
"-e", "FIREBOLT_MCP_CLIENT_ID",
"-e", "FIREBOLT_MCP_CLIENT_SECRET",
"ghcr.io/firebolt-db/mcp-server:latest"
],
"env": {
"FIREBOLT_MCP_CLIENT_ID": "your-client-id",
"FIREBOLT_MCP_CLIENT_SECRET": "your-client-secret"
}
}
}
}
For Firebolt Core, use FIREBOLT_MCP_CORE_URL (e.g. http://localhost:3473) in env and pass -e FIREBOLT_MCP_CORE_URL in args instead of the client ID/secret. For Cursor, also set FIREBOLT_MCP_DISABLE_RESOURCES=true in env and in args.
go install github.com/go-task/task/v3/cmd/task@latest
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"mcp server": {
"mcp-server-firebolt-db": {
"command": "docker",
"args": [
"run",
"\\"
]
}
}
}
}McpServers
{
"mcp-server-firebolt-db": {
"command": "docker",
"args": [
"run",
"\\"
]
}
}Installing the MCP Server
You can run the Firebolt MCP Server either via Docker or by downloading the binary.
Option 1: Run with Docker
[//]: # (x-release-please-start-version)
docker run \
--rm \
--network host \
-e FIREBOLT_MCP_CLIENT_ID=your-client-id \
-e FIREBOLT_MCP_CLIENT_SECRET=your-client-secret \
ghcr.io/firebolt-db/mcp-server:0.6.0
[//]: # (x-release-please-end)
Option 2: Run the Binary
[//]: # (x-release-please-start-version)
```bash
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
