Spice.ai OSS
Spice.ai OSS is an open-source SQL query and AI-inference engine built in Rust for developers.
What Spice.ai OSS is
Spice.ai OSS is an open-source SQL query and AI-inference engine built in Rust for developers. Its SQL API queries structured and unstructured data across databases, data warehouses, and data lakes. Data can be materialized in DuckDB, SQLite, or PostgreSQL, in memory or on disk, with results caching included. The AI compute engine offers an OpenAI-compatible API for local and hosted inference, search, memory, evaluations, and observability. Search options include vector, BM25 full-text, and hybrid methods exposed through SQL table-valued functions. Spice lists more than 40 data connectors, including PostgreSQL, MySQL, S3, Snowflake, Databricks, and DuckDB. It also documents integrations with SQL and BI clients such as DBeaver, JetBrains DataGrip, Apache Superset, Tableau, and Microsoft Power BI. Monitoring options include Prometheus-compatible metrics, OpenTelemetry metric export, and Zipkin tracing. Spice runs as a binary, container, Kubernetes workload, or managed app on Spice Cloud. The software is free under Apache 2.0 and can be self-hosted. Listed operating system support includes macOS with Apple Silicon, Linux on x86_64 or aarch64, and Windows 10 or later with WSL.
Good
- SQL API queries structured and unstructured data.
- Supports more than 40 data connectors.
- Offers vector, BM25, and hybrid search.
- Free under Apache 2.0.
Watch out
- Windows support requires WSL.
- Prebuilt macOS binaries are listed for Apple Silicon.
- API-key authentication is optional rather than required.
Who it suits
It suits developers who need SQL access across varied data sources alongside AI inference capabilities. Its deployment options include self-hosted binaries, containers, and Kubernetes workloads.
Verdict
Spice.ai OSS combines federated SQL querying, data materialization, and AI inference in one engine. Developers should account for its operating-system requirements when choosing a deployment.
Plans and prices
From Spice.ai OSS's own pricing page, checked 30 Sep 2026.
| Plan | Price | What it gives you |
|---|---|---|
| Spice.ai OSS | Free | Apache 2.0 licensed · self-hostable binary or Docker image |
The facts
Each one read from Spice.ai OSS's own pages, with the date it was checked.
What it does
- BI and SQL clients
- Documented client integrations include DBeaver, JetBrains DataGrip, Apache Superset, Tableau, and Microsoft Power BI.checked 30 Sep 2026
- Data acceleration
- It can materialize data in DuckDB, SQLite, and PostgreSQL in memory or on disk, with results caching included.checked 30 Sep 2026
- Data integrations
- The runtime components page says Spice supports over 40 data connectors, including PostgreSQL, MySQL, S3, Snowflake, Databricks, and DuckDB.checked 30 Sep 2026
- Deployment
- Spice runs as a binary, container, Kubernetes workload, or managed app on the Spice Cloud Platform.checked 30 Sep 2026
- Federated SQL
- It provides a SQL API to query structured and unstructured data across databases, data warehouses, and data lakes.checked 30 Sep 2026
- LLM interface
- Its AI compute engine provides an OpenAI-compatible API for local and hosted inference, search, memory, evaluations, and observability.checked 30 Sep 2026
- Model providers
- The feature overview lists hosted OpenAI, Anthropic, and xAI models and local Llama and Phi models, with CUDA and Metal acceleration.checked 30 Sep 2026
- Monitoring
- Observability includes Prometheus-compatible metrics, OpenTelemetry metric export, and Zipkin distributed tracing, with integrations such as Datadog and Grafana.checked 30 Sep 2026
- Operating systems
- The installation page lists macOS with Apple Silicon, Linux on x86_64 or aarch64, and Windows 10 or later with WSL; it says the prebuilt binary needs no other dependencies.checked 30 Sep 2026
- Product
- Spice is an open-source SQL query and AI-inference engine built in Rust for developers.checked 30 Sep 2026
- Search
- Search supports vector, full-text BM25, and hybrid methods through SQL table-valued functions.checked 30 Sep 2026
- Security
- Spice supports optional API-key authentication for API endpoints, and its secret stores can use environment variables, files, or external managers such as AWS Secrets Manager and Azure Key Vault.checked 30 Sep 2026
- Support
- The getting-started documentation says Spice.ai Enterprise provides full support for up to three years from release date.checked 30 Sep 2026
Alternatives to Spice.ai OSS
- 1
Virtuoso Universal Server
Open sourceWebAPILinuxmacOS7.9From $99.99 a year - 2
PrestoDB
Free planOpen sourceWebAPILinuxmacOS7.7Free plan - 3
Query Streams
Free planWebAPILinuxmacOS7.7From $15 a month - 4
Stardog
Free planAndroidiOSWebAPI7.7Free plan - 5
Starburst Galaxy
Free planWebAPILinux7.1Free plan - 67.0From $1.15 a month