Skip to content
SPECIFICTION
Get listed

Spice.ai OSS

spiceai.org

Free plan WindowsmacOSLinuxAPISelf-hosted
Visit spiceai.org
Spec score 7.7 #12 of 25 in Data Virtualization Software

What it is

Spice.ai OSS is a free, 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 engine provides an OpenAI-compatible API for local and hosted inference, search, memory, evaluations, and observability. Search methods include vector, full-text BM25, and hybrid approaches exposed through SQL table-valued functions. Spice lists over 40 data connectors, including PostgreSQL, MySQL, S3, Snowflake, Databricks, and DuckDB, and documented client integrations include DBeaver, JetBrains DataGrip, Apache Superset, Tableau, and Microsoft Power BI. It can run as a binary, container, Kubernetes workload, or managed app on Spice Cloud. The Apache 2.0-licensed software is self-hostable as a binary or Docker image. Listed operating systems are macOS with Apple Silicon, Linux on x86_64 or aarch64, and Windows 10 or later with WSL.

Spec sheet

Product
Spice is an open-source SQL query and AI-inference engine built in Rust for developers.Read 30 Sep 2026 · spiceai.org
Deployment
Spice runs as a binary, container, Kubernetes workload, or managed app on the Spice Cloud Platform.Read 30 Sep 2026 · spiceai.org
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.Read 30 Sep 2026 · spiceai.org
Support
The getting-started documentation says Spice.ai Enterprise provides full support for up to three years from release date.Read 30 Sep 2026 · spiceai.org
BI and SQL clients
Documented client integrations include DBeaver, JetBrains DataGrip, Apache Superset, Tableau, and Microsoft Power BI.Read 30 Sep 2026 · spiceai.org
Data acceleration
It can materialize data in DuckDB, SQLite, and PostgreSQL in memory or on disk, with results caching included.Read 30 Sep 2026 · spiceai.org
Data integrations
The runtime components page says Spice supports over 40 data connectors, including PostgreSQL, MySQL, S3, Snowflake, Databricks, and DuckDB.Read 30 Sep 2026 · spiceai.org
Federated SQL
It provides a SQL API to query structured and unstructured data across databases, data warehouses, and data lakes.Read 30 Sep 2026 · spiceai.org
LLM interface
Its AI compute engine provides an OpenAI-compatible API for local and hosted inference, search, memory, evaluations, and observability.Read 30 Sep 2026 · spiceai.org
Model providers
The feature overview lists hosted OpenAI, Anthropic, and xAI models and local Llama and Phi models, with CUDA and Metal acceleration.Read 30 Sep 2026 · spiceai.org
Monitoring
Observability includes Prometheus-compatible metrics, OpenTelemetry metric export, and Zipkin distributed tracing, with integrations such as Datadog and Grafana.Read 30 Sep 2026 · spiceai.org
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.Read 30 Sep 2026 · spiceai.org
Search
Search supports vector, full-text BM25, and hybrid methods through SQL table-valued functions.Read 30 Sep 2026 · spiceai.org

Plans and prices

Spice.ai OSS Free Apache 2.0 licensed · self-hostable binary or Docker image Read 30 Sep 2026 · spiceai.org

Every Spice.ai OSS plan and price →

Strong points and limits

Strong points

  • Free and licensed under Apache 2.0.
  • Supports over 40 data connectors.
  • Includes results caching with data materialization.
  • Offers an OpenAI-compatible API for local and hosted inference.

Limits

  • Windows support requires Windows 10 or later with WSL.
  • macOS support is listed for Apple Silicon.
  • Enterprise support is time-limited from release date.

Who it suits

Spice.ai OSS suits developers who need SQL access across databases, warehouses, or lakes alongside AI inference and search. It also fits teams that want to self-host and connect existing SQL or BI clients.

Verdict

Spice.ai OSS combines federated SQL, data acceleration, and AI capabilities in a self-hostable free package. Its documented operating-system support has specific requirements for Windows and macOS.

Where Specifiction places it

Alternatives to Spice.ai OSSAll alternatives →