Skip to main content
Firebolt
start free →
Open Source · Postgres SQL Dialect · Real Time · Scale Out · Iceberg · DuckLake

Firebolt: The Analytical Database for Engineers

Built for AI Agents, real-time analytics and efficient ELT with the best price-performance in the market

start free →read docs

WHAT IT IS

Firebolt is a high performance, open source analytical database (OSS available in preview today). It runs as a single binary on your laptop and scales to hundreds of nodes and petabytes of data in your cloud. Whether you’re dealing with real-time analytics or batch processing, Firebolt lets you unlock the full potential of your data without compromising on performance or cost.

WHY FIREBOLT?

  • Open source engine and open storage
  • Full deployment flexibility
  • Superior price / performance
  • Supports both real-time and batch analytics

PHILOSOPHY

  • Minimal complexity

    Runs as a single binary on your laptop, or as a 100-node cluster in the cloud. Same binary, same behavior.

  • Universal deployment

    Run Firebolt anywhere — bare metal, VMs, Kubernetes, any cloud, any data center.

  • Fewest moving parts

    Laptop? SQLite for metadata. Cluster? Postgres. Zero additional dependencies. Built around object storage: robust and fault tolerant.

  • Cloud native when you need it

    Kubernetes + object storage == full cloud data warehouse. Workload isolation, dynamic scaling, self-hosted anywhere.

DEPLOYMENT MODES

MODE 1
laptop · dev · embedded

# single binary, zero dependencies

┌─────────────────────────────────┐
│ FIREBOLT                        │
│ ┌─────────────────────────────┐ │
│ │ QUERY ENGINE                │ │
│ ├─────────────────────────────┤ │
│ │ planner → runtime → storage │ │
│ └─────────────────────────────┘ │
│ ┌─────────────────────────────┐ │
│ │ SQLITE                      │ │
│ ├─────────────────────────────┤ │
│ │ metadata                    │ │
│ └─────────────────────────────┘ │
└────────────────┬────────────────┘
                 │
        ┌────────┴────────┐
        │ LOCAL SSD/DISK  │
        └─────────────────┘
# Download and launch
bash <(curl -s https://get-core.firebolt.io/)
# Run your first query
select        l_returnflag,        l_linestatus,        sum(l_quantity) as sum_qty,        sum(l_extendedprice * (1 - l_discount) * (1 + l_tax)) as sum_charge,        avg(l_extendedprice) as avg_price,        count(*) as count_orderfrom        read_iceberg('s3://firebolt-core-us-east-1/test_data/tpch/iceberg/tpch.db/lineitem') lineitemwhere        l_shipdate <= date '1998-12-01' - interval '90' daygroup by        l_returnflag,        l_linestatus;

MANAGED SERVICE

Firebolt is fully open source. You can deploy it without limits on your own hardware. If you don’t want to self-host, you can use our managed service or bring your own cloud (BYOC).

# COMPUTE

An engine has a REST endpoint and can serve SQL queries. You can scale it up (S–XL), out (1–256 nodes), or for concurrency (up to 10 parallel clusters). You can isolate workloads by running many different engines.

Firebolt storage-optimized engine pricing for US East (N. Virginia), listing nodes, vCPU, memory, disk capacity, and hourly rate.
ENGINENODESvCPUMEM (GB)DISK (GB)$ / HOUR
S18641,875$1.84
M1161283,750$3.68
L1322567,500$7.36
XL16451215,000$14.72
2L26451215,000$14.72
2XL21281,02430,000$29.44
4XL42562,04860,000$58.88

# STORAGE

$0.0264 / gb · month on object storage (pass-through at cost)

view full pricing →

CHANGELOG

  • 4.32Adds support to attach Iceberg catalogs with CREATE ICEBERG DATABASE.
  • 4.31Adds a native JSON data type for efficient field access, user-defined schemas, Iceberg schema evolution, and HNSW vector indexes.
  • 4.30HNSW vector search indexes over float arrays for low-latency similarity search.
  • 4.29Run JOINs and queries that span multiple databases in a single statement.
  • 4.28Adds Tableau Cloud connectivity and role-based transfer of object ownership.
view all releases →