🧑‍🍳 Spice.ai OSS Cookbook

79 guides and samples to help you build data-grounded AI apps and agents with Spice.ai Open-Source. Find ready-to-use examples for data acceleration, AI agents, LLM memory, and more.

Contribute to the Cookbook on GitHub!

Featured Recipes

Federated SQL Query

Join S3, PostgreSQL, and Dremio data in one SQL query.

Recipe

Run Llama3 Locally

Use Llama models from HuggingFace with Spice.

Recipe Video

Data Acceleration with DuckDB

Speed up queries using DuckDB.

Recipe Video

LLM Memory

Persistent memory for language models

Recipe Video

Sample Applications and Guides

Example apps and guides for real-world Spice.ai usage and best practices.

Command Query Responsibility Segregation (CQRS)

Sample application implementing the CQRS pattern with Spice.

Recipe

Core Features

Discover core capabilities like data federation, acceleration, search, and LLM inference to enhance your applications.

Federated SQL Query

Query data from S3, PostgreSQL, and Dremio in a single query.

Recipe

OpenAI SDK

Use the OpenAI SDK to connect to models hosted on Spice.

Recipe

OpenAI Responses API

Use the OpenAI Responses API with Spice

Recipe

DuckDB Data Accelerator

Accelerate data locally using DuckDB.

Recipe Video

Models, AI, and Agents

Integrate with popular AI models, LLMs, and build intelligent agents using Spice.ai.

Azure OpenAI Models

Connect and use Azure OpenAI models with Spice.

Recipe

Running Llama3 Locally

Use the Llama family of models locally from HuggingFace using Spice.

Recipe Video

OpenAI SDK

Use the OpenAI SDK to connect to models hosted on Spice.

Recipe

OpenAI Responses API

Use the OpenAI Responses API with Spice

Recipe

LLM Memory

Persistent memory for language models.

Recipe Video

Text to SQL (NSQL)

Ask natural language (NLP) questions of your datasets using the built-in text-to-SQL tool.

Recipe

AI SQL Function

Invoke LLMs directly within SQL queries using the AI SQL function.

Recipe

Nvidia NIM

Deploy Nvidia NIM infrastructure, on Kubernetes, with GPUs connected to Spice.

Recipe

Searching GitHub Files

Search GitHub files with embeddings and vector similarity search.

Recipe Video

Hybrid-Search with RRF

Combine multiple search methods using Reciprocal Rank Fusion (RRF) for improved search results.

Recipe

xAI Models

Use xAI models such as Grok.

Recipe Video

DeepSeek Model

Use DeepSeek model through Spice.

Recipe

Model-Context-Protocol (MCP)

Use Spice to connect to or host MCP servers.

Recipe

Amazon S3 Vectors

Use Amazon S3 Vectors to store embeddings and perform efficient vector search.

Recipe Video

Data Acceleration, Materialization, and Federation

Optimize query performance with local acceleration, data materialization, and federation techniques.

DuckDB Data Accelerator

Accelerate data locally using DuckDB.

Recipe Video

PostgreSQL Data Accelerator

Accelerate data locally using PostgreSQL.

Recipe

SQLite Data Accelerator

Accelerate data locally using SQLite.

Recipe

Apache Arrow Data Accelerator

Accelerate data using Apache Arrow.

Recipe

Hashed Partitioning with DuckDB

Use hashed partitioning for performance with DuckDB.

Recipe

Accelerated Views

Use view materialization for improved performance.

Recipe

Indexes on Accelerated Data

Create and manage indexes on accelerated data.

Recipe

Search & Embeddings

Implement advanced search capabilities and leverage embeddings for vector similarity search.

Searching GitHub Files

Search GitHub files with embeddings and vector similarity search.

Recipe Video

Hybrid-Search with RRF

Combine multiple search methods using Reciprocal Rank Fusion (RRF) for improved search results.

Recipe

Amazon S3 Vectors

Use Amazon S3 Vectors to store embeddings and perform efficient vector search.

Recipe Video

Data Connectors

Connect to various data sources and systems to query, analyze, and manage your data efficiently.

PostgreSQL Connector

Connect to and query PostgreSQL databases.

Recipe

AWS RDS PostgreSQL

Connect to AWS RDS PostgreSQL instances.

Recipe

Supabase PostgreSQL

Connect to Supabase PostgreSQL databases.

Recipe

MySQL Connector

Connect to and query MySQL databases.

Recipe

AWS RDS Aurora MySQL

Connect to AWS RDS Aurora with MySQL compatibility.

Recipe

PlanetScale MySQL

Connect to PlanetScale MySQL databases.

Recipe

Clickhouse Connector

Connect to and query Clickhouse databases.

Recipe

Databricks Connector

Connect to and query Databricks instances using Delta Lake or Spark Connect.

Recipe

Delta Lake Connector

Query data from Delta Lake tables.

Recipe

Debezium CDC from Postgres

Stream changes from PostgreSQL using Debezium CDC.

Recipe

Debezium CDC with SASL/SCRAM

Stream MySQL changes using Debezium with SASL/SCRAM authentication.

Recipe

Dremio Connector

Connect to and query Dremio.

Recipe

DuckDB Connector

Query DuckDB databases with sample TPCH data.

Recipe

File Connector

Query data from local files.

Recipe

FTP Connector

Query data from FTP servers.

Recipe

GitHub Connector

Connect to and query GitHub data.

Recipe Video

GraphQL Connector

Query data from GraphQL endpoints.

Recipe

MSSQL Connector

Connect to Microsoft SQL Server databases.

Recipe

ODBC Connector

Connect to databases using ODBC.

Recipe

Oracle Connector

Connect to and query Oracle databases.

Recipe

Glue Connector

Connect to AWS Glue.

Recipe

S3 Connector

Query data from S3 compatible storage.

Recipe

SharePoint Connector

Connect to SharePoint and OneDrive for Business.

Recipe

Snowflake Connector

Connect to and query Snowflake databases.

Recipe

Spice.ai Cloud Connector

Connect to the Spice.ai Cloud Platform.

Recipe

Apache Spark Connector

Connect to and query Apache Spark.

Recipe

IMAP Emails

Federated SQL query of mail across IMAP email servers.

Recipe

MongoDB Connector

Connect to and query MongoDB databases.

Recipe

Live Orders Analytics with Apache Kafka Data Connector

Combine real-time data streaming from Kafka with other datasets using Spice.

Recipe

Catalog Connectors

Connect to data catalogs to discover, manage, and utilize your data assets effectively.

Spice.ai Cloud Platform Catalog

Connect to the Spice.ai Cloud Platform catalog.

Recipe

Databricks Unity Catalog

Connect to Databricks Unity catalog.

Recipe

Unity Catalog

Connect to Unity catalog.

Recipe

Iceberg Catalog Connector

Connect to Iceberg catalog with support for reading and writing Iceberg tables.

Recipe

Visualization

Visualize data with BI and analytics tools.

Sales BI with Apache Superset

Visualize data in Spice with Apache Superset.

Recipe

Grafana Datasource

Add Spice as a Grafana datasource.

Recipe

API Clients

Use API clients for data access and integration.

Python ADBC Client

Query Spice using ADBC and Parameterized Queries with Python.

Recipe

Java JDBC Client

Query Spice.ai using the Java JDBC client.

Recipe

Scala JDBC Client

Query Spice.ai using the Scala JDBC client.

Recipe

Deployment

Deploy Spice.ai in different environments.

Deploying to Kubernetes

Deploy Spice.ai on Kubernetes.

Recipe

Running in Docker

Run Spice.ai in Docker containers.

Recipe

Performance and Benchmarking

Measure and optimize performance with benchmarks and best practices for your Spice.ai deployment.

TPC-H Benchmarking

Benchmark performance using TPC-H.

Recipe

Results Caching

Cache query results for improved performance.

Recipe

Indexes on Accelerated Data

Create and manage indexes on accelerated data.

Recipe

Configuration

Fine-tune your Spice.ai deployment with advanced configuration options for optimal performance.

Data Retention Policy

Configure data retention policies.

Recipe

Refresh Data Window

Configure data refresh windows.

Recipe

Advanced Data Refresh

Advanced configuration for data refresh.

Recipe

Data Quality with Constraints

Add data quality constraints.

Recipe

Cron Dataset Schedules

Schedule dataset refreshes using cron syntax.

Recipe

SDKs

Use SDKs for different programming languages.

OpenAI SDK

Use the OpenAI SDK to connect to models hosted on Spice.

Recipe

Rust SDK

Query Spice.ai using the Rust SDK.

Recipe

Python SDK

Query Spice.ai using the Python SDK.

Recipe

Go SDK

Query Spice.ai using the Go SDK.

Recipe

Spice.js JavaScript (Node.js) SDK

Query Spice.ai using the JavaScript (Node.js) SDK with examples.

Recipe

Java SDK

Query Spice.ai using the Java SDK.

Recipe

Security

Secure your Spice.ai deployment and data access with robust security practices and configurations.

Intelligent Security Copilot

Analyze real-time data access patterns with Spice.ai.

Recipe

TLS Encryption

Enable encryption in transit using TLS.

Recipe

API Key Authentication

Secure access with API key authentication.

Recipe