🧑‍🍳 Spice.ai OSS Cookbook

65 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 Data Access

Use SQL to join data across S3, PostgreSQL, and Dremio in a single query.

Recipe

Local Llama3

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

Recipe Video

Data Acceleration

Accelerate queries with DuckDB.

Recipe Video

LLM Memory

Persistent memory for language models

Recipe Video

Sample Applications and Guides

Explore example applications and guides built with Spice.ai that demonstrate real-world usage patterns and best practices.

Command Query Responsibility Segregation (CQRS)

Sample application implementing the CQRS pattern with Spice.

Recipe

Core Scenarios

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

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

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

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

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

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

Indexes on Accelerated Data

Create and manage indexes on accelerated data.

Recipe

Search and 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

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

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

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

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

Connect to Iceberg catalog.

Recipe

Data Visualization with Client Integrations

Visualize your data using popular BI and analytics tools integrated with Spice.ai.

Sales BI with Apache Superset

Visualize data in Spice with Apache Superset.

Recipe

Grafana Datasource

Add Spice as a Grafana datasource.

Recipe

Deployment

Deploy Spice.ai in various environments and configurations to suit your needs.

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

Advanced 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

SDKs

Utilize development kits and libraries for building applications with Spice.ai across various 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

JavaScript SDK

Query Spice.ai using the JavaScript SDK.

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