# Firebolt L1 · Needs a person Firebolt is an analytical database, in the data warehouse category, that runs SQL queries over HTTP, an official MCP server and a CLI. **Can an AI agent use Firebolt? No.** Our agent couldn't get into Firebolt on its own. Category: Data warehouses · Connects by: MCP, API, CLI, SDK · Agent payments: None found · Driven: 28 Oct 2026 **How to connect** - API base URL: `https://firebolt.go.firebolt.io` (documented). Source: https://raw.githubusercontent.com/firebolt-db/openapi/main/specification/yaml/firebolt_query_v2.3.yaml - CLI install: `pipx install firebolt-cli` (documented). Source: https://pypi.org/project/firebolt-cli/ - Docs page: `https://docs.firebolt.io/overview` (tested in our drive). Source: https://docs.firebolt.io/overview **Level 1: Needs a person.** Agents can't get in on their own. - Got in by: A person sets it up (Not on its own in its last 2 drives) - Got as far as: Sign up (Use, Pay and Leave not reached) - To reach L2: Let an agent sign up on its own. 2 drives on one day, awaiting confirmation [What the levels mean](https://agentdrives.com/method/levels?via=md) ## From finding it to leaving What an agent managed without a person, at each step. 1. **Find**: On its own. Docs it can act on: llms.txt, an OpenAPI and an MCP server. 544 doc pages read. 2. **Get in**: Stopped. Can't sign up. The sign-up call was refused with a message that names no reason. Stopped here. 3. **Use**: Not reached. Tasks need an account. 4. **Pay**: Not reached. Buying needs an account. 5. **Leave**: Not reached. Nothing to cancel or delete. ## Getting in None of the 2 ways in got our agent in on its own; one got partway. Where it stopped: **Email and password**. The sign-up call was refused with a message that names no reason. - Both kinds of agent (On a server, or in its own browser): No. Signing up needs a person: the form refused our agent's browser. - Signed agent (Known to Cloudflare): Partly. The sign-up page opens. The check on the form still applies. | Way in | What happened | |---|---| | Runs locally, no account | Partway | | Email and password | Refused | [How agents get past bot checks](https://agentdrives.com/guides/let-signed-agents-past-your-bot-check.md?via=md) ## What an agent can do with Firebolt No task was tried: our agent couldn't get into Firebolt. Core tasks Firebolt offers an agent: - Run a database query (API, MCP, CLI) - Create a database (API, CLI) - Create a table (API, CLI) - List databases and read their schema (API, MCP, CLI) - Add or change a table field (API, CLI) - Sync external data into a table (API, CLI) - Run a vector search (API, MCP, CLI) - Run a full-text search (API, CLI) - Query a database over a REST API (API) What it can't do, and why: - Build the documented vector index on a default table: The engine says this is not yet supported; the docs do not say so. - Pay for the hosted service: Billing runs only through AWS Marketplace after the trial. 13 more tasks it offers: - Create a table view (API, CLI) - Export data to a warehouse (API, MCP, CLI) - Stream database changes (API) - Resize database compute (API, MCP, CLI) - Delete a database (API, CLI) - Delete a record (API, CLI) - Create a database user (API, CLI) - Set row-level security policies (API) - Configure SAML SSO (Web app) - Restrict access by IP address (API, MCP, CLI) - Read the audit log (Web app) - Create a sub-account (API, MCP, CLI) - Enable two-factor authentication (Web app) **Surface audit:** 64 documented operations, 44 run, 37 passed, 6 not as documented, 18 blocked (sandbox or plan limits), 3 left out to stay safe. ### Self-hosted edition L4 · Runs on its own. Firebolt also ships an edition you run yourself. Our agent installed it on its own server in about 6 minutes and drove it the same way, doing 100% of the core work. ## How an agent connects MCP, API, OpenAPI, CLI, SDK and llms.txt found. Agent surfaces: API tested · MCP tested · CLI tested · SDK documented · Docs tested · Agent payments none found. Issues found: 7. - **MCP server**: 8 tested. Official server. Local binary; 4 tools in Core mode. (9 tools across its docs) - **API**: 17 tested. SQL over HTTP; managed REST via service-account token. (22 operations across its docs) - **OpenAPI**: Yes. 3.0.0, one operation (POST /query) - **CLI**: 18 tested. firebolt CLI 5.0.0 (client, server, profile, session) (19 commands across its docs) - **SDK**: Listed, not tested. Python, Node.js, Go, JDBC, .NET, Rust, SQLAlchemy. (7 methods across its docs) - **llms.txt**: Yes. https://www.firebolt.io/llms.txt - **Agent payments**: None found. The checkout wasn't reached: Managed service (compute 1x S), $0.92 a call. - **Docs**: No gaps in what we read. Covers getting started, auth, error codes and code examples. https://docs.firebolt.io/overview (544 of 693 pages read) [The standards](https://agentdrives.com/standard) ## Tips for agent builders - No account needed for the open-source edition: fetch packdb-linux-amd64.tar.gz from github.com/firebolt-db/firebolt-core releases and run 'firebolt server start --http-port 3473'; in a container or sandbox with a low memlock limit set execution.io_uring: off in /config.yaml. - Send one SQL statement per HTTP request to http://:3473/?output_format=JSON_Compact&database=; a multi-statement body is refused with a clear message. - Run the official MCP server with --core-url http://localhost:3473 --transport streamable-http; call firebolt_docs_overview first for the docs_proof, and pass any value as 'account' to firebolt_query on Core. - On Core 5.0.0-pre, rank rows by vector_cosine_distance when the vector index does not build. - Check the database name yourself before writing: confirm it in information_schema.catalogs. ## How Firebolt compares In Data warehouses: 2 of the 7 products we drove in Data warehouses are higher; 4 others share L1. - [ClickHouse Cloud](https://agentdrives.com/tools/clickhouse.md?via=md): L4, Gets in on its own - [MotherDuck](https://agentdrives.com/tools/motherduck.md?via=md): L4, Gets in on its own - [Databricks](https://agentdrives.com/tools/databricks.md?via=md): L1, Can't sign up on its own - **Firebolt** (this page): L1, Can't sign up on its own - [Snowflake](https://agentdrives.com/tools/snowflake.md?via=md): L1, Can't sign up on its own - [Starburst](https://agentdrives.com/tools/starburst.md?via=md): L1, Can't sign up on its own - [Tinybird](https://agentdrives.com/tools/tinybird.md?via=md): L1, Can't sign up on its own [All 7 in Data warehouses](https://agentdrives.com/categories/data-warehouses?via=md) Sorted by level, then work done, then time to the first call. [How we rank](https://agentdrives.com/method?via=md#order) On our standard (24 criteria: against other data warehouses products where we measured 5 or more, otherwise against every product we measured): - [Typed, tight input schemas](https://agentdrives.com/standard#mcp-06): **Ahead of most** 50 of 65 others (every product) lower, 15 the same. - [Agents pick the right tool](https://agentdrives.com/standard#mcp-05): **Ahead of most** 46 of 65 others (every product) lower, 19 the same. - [Docs an agent can navigate](https://agentdrives.com/standard#docs-11): **Ahead of most** 4 of 6 others (data warehouses products) lower, 2 the same. - [A tool list that fits](https://agentdrives.com/standard#mcp-11): **Ahead of most** 33 of 65 others (every product) lower, 32 the same. - [The best way in is built for agents](https://agentdrives.com/standard#in-12): **In the middle** 3 of 6 others (data warehouses products) lower, 3 the same. - [A request id on every answer](https://agentdrives.com/standard#err-07): **Ahead of most** 3 of 5 others (data warehouses products) lower, 1 the same, 1 higher. - [Prices an agent can read](https://agentdrives.com/standard#find-06): **Level with most** 4 of 6 others (data warehouses products) the same, 2 lower. - [Sign-in for agents acting for a person](https://agentdrives.com/standard#in-08): **Level with most** 4 of 6 others (data warehouses products) the same, 2 lower. - [Fast to the first call](https://agentdrives.com/standard#in-03): **Level with most** 3 of 4 others (data warehouses products) the same, 1 lower. - [Descriptions that say when to use the tool](https://agentdrives.com/standard#mcp-04): **In the middle** 20 of 65 others (every product) lower, 30 the same, 15 higher. - [Tool names that sort themselves](https://agentdrives.com/standard#mcp-03): **Level with most** 61 of 65 others (every product) the same, 4 lower. - [Every way in works for an agent](https://agentdrives.com/standard#in-11): **In the middle** 2 of 6 others (data warehouses products) lower, 2 the same, 2 higher. - [Real status codes](https://agentdrives.com/standard#err-01): **The same as all** 5 others (data warehouses products). - [Errors a program can read](https://agentdrives.com/standard#err-02): **In the middle** 1 of 4 others (data warehouses products) lower, 2 the same, 1 higher. - [Errors say what to do next](https://agentdrives.com/standard#err-03): **In the middle** 1 of 4 others (data warehouses products) lower, 2 the same, 1 higher. - [Export before leaving](https://agentdrives.com/standard#leave-03): **Level with most** 4 of 6 others (data warehouses products) the same, 1 lower, 1 higher. - [WebMCP tools on the web app](https://agentdrives.com/standard#proto-02): **The same as all** 5 others (data warehouses products). - [Pages fit one fetch](https://agentdrives.com/standard#docs-08): **Level with most** 5 of 6 others (data warehouses products) the same, 1 higher. - [A path written for agents](https://agentdrives.com/standard#docs-10): **In the middle** 1 of 6 others (data warehouses products) lower, 2 the same, 3 higher. - [Results sized for a context window](https://agentdrives.com/standard#mcp-09): **Behind most** 16 of 31 others (every product) higher, 11 the same, 4 lower. - [Spend an agent can see and cap](https://agentdrives.com/standard#pay-05): **Level with most** 3 of 5 others (data warehouses products) the same, 2 higher. - [Structured results](https://agentdrives.com/standard#mcp-08): **Behind most** 22 of 36 others (every product) higher, 14 the same. - [Truthful annotations](https://agentdrives.com/standard#mcp-07): **Behind most** 48 of 65 others (every product) higher, 17 the same. - [Versions an agent can pin](https://agentdrives.com/standard#api-07): **The lowest result** All 4 others (data warehouses products) higher. [How each criterion is graded](https://agentdrives.com/standard) ## For the team behind Firebolt **7 things to fix for agents.** Agent blockers: 1 found · Agent surfaces: 6 issues found. Safety review: 2 issues found. Agents get stuck at Get in. Prove Firebolt is yours, then see where each issue is, read your safety findings and ask for a free drive after a fix. How to fix each one comes with the Audit. - Find: Clear - Get in: Blocks agents - Use: Not reached - Pay: Not reached - Leave: Not reached [Claim Firebolt, free](https://agentdrives.com/app/products?add=firebolt.io&ref=listing) · [What a drive covers](https://agentdrives.com/method?via=md) ## Where Firebolt fits - Category: [Data and storage](https://agentdrives.com/categories/data?via=md), [Data warehouses](https://agentdrives.com/categories/data-warehouses?via=md) - Wall: [Bot checks](https://agentdrives.com/access/get-in/bot-checks) (kept our agent out), [Google reCAPTCHA bot check](https://agentdrives.com/vendors/recaptcha) (the check, and every product we met it at), [Let signed AI agents past your bot check](https://agentdrives.com/guides/let-signed-agents-past-your-bot-check?via=md) (fix guide) - Standards: [MCP](https://agentdrives.com/standards/mcp) (tools an agent can call), [OpenAPI](https://agentdrives.com/standards/openapi) (its API, described), [llms.txt](https://agentdrives.com/standards/llms-txt) (its docs, listed for agents) - Steps: [Find](https://agentdrives.com/access/find), [Get in](https://agentdrives.com/access/get-in) (stopped here), [Use](https://agentdrives.com/access/use), [Pay](https://agentdrives.com/access/pay), [Leave](https://agentdrives.com/access/leave) - Rivals: [Databricks](https://agentdrives.com/tools/databricks?via=md) (L1), [Snowflake](https://agentdrives.com/tools/snowflake?via=md) (L1), [Starburst](https://agentdrives.com/tools/starburst?via=md) (L1) Data: [JSON](https://agentdrives.com/api/tools/firebolt.json?via=md) · [Markdown](https://agentdrives.com/tools/firebolt.md?via=md) · [History](https://agentdrives.com/tools/firebolt/history?via=md) · [Atom](https://agentdrives.com/feeds/tools/firebolt.atom) · [JSON Feed](https://agentdrives.com/feeds/tools/firebolt.json) · licence [CC BY 4.0](https://creativecommons.org/licenses/by/4.0/) **Found an error?** [Tell us on this page](https://agentdrives.com/tools/firebolt?via=md#correct) or read [how corrections work](https://agentdrives.com/corrections?via=md).