At a glance
| SQL support | Subset of PostgreSQL-compatible SQL |
| Storage and compute architecture | Engines (compute) separate from object storage; Parquet and Iceberg support |
| Workload types | Low-latency, high-concurrency analytics for applications, ELT |
| Integrations | Iceberg catalogs, S3, JDBC, Python SDK, dbt |
| Deployment | Managed on AWS, BYOC, self-managed on Kubernetes, or Firebolt Core in Docker |
| Pricing model | Per second per engine node plus storage at USD 0.0264 per GB-month; Core free under Elastic License 2.0 |
Firebolt suits engineering teams that serve many fast queries from applications and want PostgreSQL-flavoured SQL, with the option to run the same engine themselves through the free Firebolt Core. Note that Core is source-available under the Elastic License 2.0 rather than an OSI open source licence, and that the managed service runs on AWS only.
Overview
Firebolt is an analytical database that its site positions for AI agents, real-time analytics and ELT. Its FAQ says it speaks a subset of PostgreSQL-compatible SQL, and a PostgreSQL-compatible wire protocol endpoint is in preview. Data is stored in open formats, with Parquet and Iceberg listed on the home page; release 4.32 added CREATE ICEBERG DATABASE for attaching Iceberg catalogs.
Firebolt can be used in three ways: the managed service, which the FAQ says is offered on AWS only, in six regions; bring your own cloud; or self-managed through an Apache 2.0 Kubernetes operator and Helm chart, which the FAQ lists as GA on AWS and Google Cloud and in preview on Azure. Firebolt Core packages the engine as a single Docker image that is free to use with no usage limits, from a laptop to an on-premises cluster.
Key features
- PostgreSQL-style SQL dialect, with a PostgreSQL wire protocol endpoint in preview
- Per-second engine billing with node types from S to XL and consumption only while engines run
- Firebolt Core, a free self-hosted edition shipped as a single Docker image with no usage limits
- Apache Iceberg catalogs attached with CREATE ICEBERG DATABASE (release 4.32)
- Self-managed deployment through an Apache 2.0 Kubernetes operator and Helm chart
- Drivers and adapters including JDBC, a Python SDK and dbt
Pros and cons
Pros
- Free self-hosted edition with no usage limits
- Published per-node and storage rates with a calculator
- PostgreSQL-style SQL lowers the learning curve
- Several deployment choices, from a laptop to managed cloud
Cons
- Firebolt Core uses the Elastic License 2.0, not an OSI-approved open source licence
- The managed service runs on AWS only, and the PostgreSQL wire endpoint is still in preview
- Smaller ecosystem than the large cloud warehouses
Pricing
Firebolt Core, the self-hosted edition, is free with no usage limits under the Elastic License 2.0, which forbids offering it to others as a hosted or managed service. The managed service bills compute per second per engine node, by node type (S, M, L, XL) and hardware family, only while an engine is running, and passes object storage through at USD 0.0264 per GB-month. As one example, the pricing page lists one S compute-optimised node in US East (N. Virginia) at USD 0.92 per hour. New accounts get USD 200 in free credits, and commitment discounts are available from sales. BYOC pricing was not published.
Pricing checked on the vendor's official page on 7 November 2026. Prices change; confirm before buying.
Who it is best for
Engineering teams that serve many fast analytical queries from applications and want PostgreSQL-style SQL, managed on AWS or self-hosted.
Who should look elsewhere
- Organisations that require an OSI open source licence: look at ClickHouse or StarRocks.
- Teams that need a managed warehouse on Azure or Google Cloud today: see Snowflake alternatives.
Verdict
Firebolt is worth evaluating for application-facing analytics where many concurrent queries must return quickly, and Firebolt Core makes it unusually easy to try the engine without a contract. Weigh the Elastic License 2.0 terms, the AWS-only managed service and a smaller ecosystem against those strengths.
Frequently asked questions
Is Firebolt open source?
Not in the OSI sense. Firebolt Core is free to use with no usage limits under the Elastic License 2.0, which is source-available and forbids offering it as a hosted service. The Kubernetes operator, Helm chart and client drivers are Apache 2.0.
How is Firebolt priced?
The managed service bills compute per second per engine node, by node type, and storage at USD 0.0264 per GB-month. The pricing page lists an S compute-optimised node in US East at USD 0.92 per hour, and new accounts get USD 200 in credits.
Which clouds does Firebolt run on?
Firebolt's FAQ says the fully managed service is offered on AWS only. Self-managed Firebolt is listed as GA on AWS and Google Cloud and in preview on Azure, and Firebolt Core runs anywhere Docker runs.
Sources
- Firebolt pricing
- Firebolt FAQ
- Firebolt Core repository
- Firebolt Core licence (Elastic License 2.0)
- Firebolt release notes
- Self-managed Firebolt documentation
Checked November 2026.
How we research reviews and what star ratings mean: our editorial method.