Firebolt Core | Run Firebolt. Anywhere.

Run Firebolt. Anywhere.

Run Firebolt's analytical query engine anywhere - fast, scalable, self-hosted and forever free.

bash <(curl -s https://get-core.firebolt.io/)

Get Started

Documentation

Sub-Second Queries

Blazing-fast queries over large, complex datasets.

Scales Out

Run Firebolt Core on multiple nodes that work together on a single query

Postgres Compliant

Postgres-compliant SQL extended for modern analytics: Apache Iceberg, array processing with lambdas and vector search.

Free Forever

Use in production without any usage limits.

Runs Anywhere

Spin up Firebolt Core anywhere you need it: locally, on prem or in the cloud using Docker and Kubernetes.

Production Ready

Core is powered by the same high-performance SQL engine trusted by Firebolt’s SaaS customers

SQL Queries to Get You Started

These examples highlight common workflows in Firebolt Core — from querying simple select, list objects, or read Iceberg tables, and more.

1curl -s "http://localhost:3473" --data-binary "
2  SELECT 42
3"

curl -s "http://localhost:3473" --data-binary "
     SELECT 42
"

1# List objects in a public S3 bucket
2curl -s "http://localhost:3473" --data-binary "
3	SELECT *
4    FROM list_objects('s3://firebolt-core-us-east-1/test_data/tpch/parquet/')
5    ORDER BY object_name;
6"

# List objects in a public S3 bucket
curl -s "http://localhost:3473" --data-binary "
     SELECT *
     FROM list_objects('s3://firebolt-core-us-east-1/test_data/tpch/parquet/')
     ORDER BY object_name;
"

1# Read an Iceberg table from a public GCS bucket
2curl -s "http://localhost:3473" --data-binary "
3  SELECT *
4  FROM read_iceberg('gs://firebolt-core-us-east-1/test_data/tpch/iceberg/tpch.db/lineitem')
5  LIMIT 10
6"

# Read an Iceberg table from a public GCS bucket
curl -s "http://localhost:3473" --data-binary "
     SELECT *
     FROM read_iceberg('gs://firebolt-core-us-east-1/test_data/tpch/iceberg/tpch.db/lineitem')
     LIMIT 10
"

Read about Firebolt's commitment with Firebolt Core

Read the blog post

Frequently Asked Questions

What is Firebolt Core?

Firebolt Core is a self-hosted version of the Firebolt query engine, designed for developers who want speed, control, and flexibility. It’s free to use, easy to deploy via Docker, and can run wherever you want — whether that’s on a laptop or in your cloud environment.

What can I do with it?

Run sub-second SQL queries locally or in your infrastructure, scan Iceberg or Parquet data, and prototype AI pipelines, analytics apps, or embedded workloads — all without relying on managed services or cloud-specific tooling.

How do I get started?

You can run Firebolt Core via Docker in seconds. Just pull the image, start the container, and you’re ready to send SQL queries from Firebolt Core’s CLI.

Is it really free forever?

Yes. Firebolt Core is free for commercial and non-commercial use, with no usage caps. You can deploy it in production without paying anything!

We use cookies to give you a better online experience