firebolt_docs_overviewLABSCO SUMMARY
It reads the documentation before it writes your SQL.
By default the connect tool will not proceed until the model has fetched the documentation overview, which grounds it in Firebolt's dialect instead of generic SQL — turn that off with --skip-docs-proof when the extra tokens aren't worth it. One client caveat: the server leans on MCP resources, so Cursor needs FIREBOLT_MCP_DISABLE_RESOURCES=true or it will not work at all.
What it is
Firebolt's MCP server: a Go binary that connects an assistant to a Firebolt engine and database, and to Firebolt's SQL reference and documentation.
What you get
firebolt_connect— attach to an engine and a databasefirebolt_query— execute SQL against Fireboltfirebolt_docs_overviewandfirebolt_docs_search— the documentation, SQL reference and function lists, searchable from the conversation- Resources the model can reference directly: documentation articles and the lists of accounts, databases and engines
- A Firebolt Expert prompt that puts the model in the right frame before it writes SQL
Requirements
Either a Firebolt service account with a client id and secret, in FIREBOLT_MCP_CLIENT_ID and FIREBOLT_MCP_CLIENT_SECRET, or a Firebolt Core instance URL in FIREBOLT_MCP_CORE_URL. Run ghcr.io/firebolt-db/mcp-server:0.6.0 under Docker or download the binary from Releases. STDIO is the default transport; set --transport sse for Server-Sent Events.
Setup effort
One command plus credentials — docker run --rm --network host -e FIREBOLT_MCP_CLIENT_ID=<YOUR_FIREBOLT_MCP_CLIENT_ID> -e FIREBOLT_MCP_CLIENT_SECRET=<YOUR_FIREBOLT_MCP_CLIENT_SECRET> ghcr.io/firebolt-db/mcp-server:0.6.0
USE CASES
01
Answering a data question without opening a SQL client
Connect to the engine, then run the query and read the result in the same thread.
02
Writing Firebolt SQL you don't know by heart
Search the documentation for the function or syntax, then run the statement against the warehouse.
03
Working against a local Firebolt Core
Give the Core URL instead of service-account credentials and the same tools point at your local instance.
04
Getting oriented in an account you just joined
Read the accounts, databases and engines the credentials can see before you query anything.
6 tools
Listed in project docs. Your client may show a different list.
firebolt_docs_llmfirebolt_connectfirebolt_connect_corefirebolt_queryfirebolt_docs_searchBEFORE YOU INSTALL
What to know first
Tools you get
6 tools named in the project's documentation.
Requires
- docker on PATH
- FIREBOLT_MCP_CLIENT_ID in your environment
- FIREBOLT_MCP_CLIENT_SECRET in your environment
Where it runs
All 4 documented clients run the server on your machine.
INSTALLATION
Connect your client
Server setup
TERMINAL
docker run --rm --network host -e FIREBOLT_MCP_CLIENT_ID=<YOUR_FIREBOLT_MCP_CLIENT_ID> -e FIREBOLT_MCP_CLIENT_SECRET=<YOUR_FIREBOLT_MCP_CLIENT_SECRET> ghcr.io/firebolt-db/mcp-server:0.6.0MCP Clients
Cursor
CURSOR · JSON
{
"mcpServers": {
"mcp-server": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"--network",
"host",
"-e",
"FIREBOLT_MCP_CLIENT_ID",
"-e",
"FIREBOLT_MCP_CLIENT_SECRET",
"-e",
"FIREBOLT_MCP_DISABLE_RESOURCES",
"ghcr.io/firebolt-db/mcp-server:latest"
],
"env": {
"FIREBOLT_MCP_CLIENT_ID": "<YOUR_FIREBOLT_MCP_CLIENT_ID>",
"FIREBOLT_MCP_CLIENT_SECRET": "<YOUR_FIREBOLT_MCP_CLIENT_SECRET>",
"FIREBOLT_MCP_DISABLE_RESOURCES": "true"
}
}
}
}VS Code
VS CODE · JSON
{
"servers": {
"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_FIREBOLT_MCP_CLIENT_ID>",
"FIREBOLT_MCP_CLIENT_SECRET": "<YOUR_FIREBOLT_MCP_CLIENT_SECRET>"
}
}
}
}Any MCP client
ANY MCP CLIENT · JSON
{
"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_FIREBOLT_MCP_CLIENT_ID>",
"FIREBOLT_MCP_CLIENT_SECRET": "<YOUR_FIREBOLT_MCP_CLIENT_SECRET>"
}
}
}
}Claude Desktop
CLAUDE DESKTOP · JSON
{
"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:0.6.0"
],
"env": {
"FIREBOLT_MCP_CLIENT_ID": "<YOUR_FIREBOLT_MCP_CLIENT_ID>",
"FIREBOLT_MCP_CLIENT_SECRET": "<YOUR_FIREBOLT_MCP_CLIENT_SECRET>"
}
}
}
}
