🧑🍳 Spice.ai Cookbook
78 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.
Featured Recipes
Most popular cookbook recipes for SQL federation, local models, acceleration, and LLM memory.
Federated SQL Query
Join S3, PostgreSQL, and Dremio data in one SQL query.
Run Llama3 Locally
Use Llama models from HuggingFace with Spice. Includes video walkthrough.
Data Acceleration with DuckDB
Speed up queries using DuckDB. Includes video walkthrough.
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.
AI SQL Function
Invoke LLMs directly within SQL queries using the AI SQL function.
DuckDB Data Accelerator
Accelerate data locally using DuckDB. Includes video walkthrough.
Amazon S3 Vectors Search
Use Amazon S3 Vectors to store embeddings and run efficient vector search. Includes video walkthrough.
Spice Cayenne Data Accelerator
Accelerate data locally using the Spice Cayenne Data Accelerator.
Models, AI, and Agents
Integrate with popular AI models, LLMs, and build intelligent agents using Spice.ai.
Running Llama3 Locally
Use the Llama family of models locally from HuggingFace using Spice. Includes video walkthrough.
LLM Memory
Persistent memory for language models.
Text to SQL (NSQL)
Ask natural language (NLP) questions of your datasets using the built-in text-to-SQL tool.
AI SQL Function
Invoke LLMs directly within SQL queries using the AI SQL function.
Generative Visualizations
Generate SQL queries and Chart.js visualizations from natural language using AI.
Nvidia NIM on Kubernetes
Deploy Nvidia NIM infrastructure on Kubernetes with GPUs connected to Spice.
Nvidia NIM on AWS EC2
Deploy Nvidia NIM on AWS GPU-optimized EC2 instances connected to Spice.
Searching GitHub Files
Search GitHub files with embeddings and vector similarity search. Includes video walkthrough.
Hybrid-Search with RRF
Combine multiple search methods using Reciprocal Rank Fusion (RRF) for improved search results.
xAI Models
Use xAI models such as Grok. Includes video walkthrough.
Web Search Tools using Perplexity
Provide LLMs with web search access for more informed answers.
LLM as a Judge
Define LLM judge models to evaluate the performance of other language models.
Model-Context-Protocol (MCP)
Use Spice to connect to or host MCP servers.
Amazon S3 Vectors
Use Amazon S3 Vectors to store embeddings and perform efficient vector search. Includes video walkthrough.
Data Acceleration, Materialization, and Federation
Optimize query performance with local acceleration, data materialization, and federation techniques.
DuckDB Data Accelerator
Accelerate data locally using DuckDB. Includes video walkthrough.
PostgreSQL Data Accelerator
Accelerate data locally using PostgreSQL.
Hashed Partitioning with DuckDB
Use hashed partitioning for performance with DuckDB.
Dataset Partitioning
Partition accelerated datasets to improve query performance.
Database Snapshots
Bootstrap DuckDB accelerations from object storage to skip cold starts.
Indexes on Accelerated Data
Create and manage indexes on accelerated data.
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. Includes video walkthrough.
Hybrid-Search with RRF
Combine multiple search methods using Reciprocal Rank Fusion (RRF) for improved search results.
Amazon S3 Vectors
Use Amazon S3 Vectors to store embeddings and perform efficient vector search. Includes video walkthrough.
Data Connectors
Connect to various data sources and systems to query, analyze, and manage your data efficiently.
AWS RDS Aurora MySQL
Connect to AWS RDS Aurora with MySQL compatibility.
Databricks Connector
Connect to and query Databricks instances using Delta Lake or Spark Connect.
Debezium CDC from Postgres
Stream changes from PostgreSQL using Debezium CDC.
Debezium CDC with SASL/SCRAM
Stream MySQL changes using Debezium with SASL/SCRAM authentication.
GitHub Connector
Connect to and query GitHub data. Includes video walkthrough.
ScyllaDB Connector
Query data from ScyllaDB clusters using federated SQL.
SharePoint Connector
Connect to SharePoint and OneDrive for Business.
Live Orders Analytics with Apache Kafka Data Connector
Combine real-time data streaming from Kafka with other datasets using Spice.
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.
Iceberg Catalog Connector
Connect to Iceberg catalog with support for reading and writing Iceberg tables.
Visualization
Visualize data with BI and analytics tools.
Sales BI with Apache Superset
Visualize data in Spice with Apache Superset.
API Clients
Use API clients for data access and integration.
Python ADBC Client
Query Spice using ADBC and Parameterized Queries with Python.
Deployment
Deploy Spice.ai in different environments.
Sidecar Deployment Architecture
Deploy Spice as a sidecar alongside your application.
Microservice Deployment Architecture
Deploy Spice as a standalone microservice architecture.
Advanced Topics
Explore advanced deployment and data architecture patterns for production workloads.
Local Dataset Replication
Link datasets in a parent/child relationship within the current Spicepod.
Distributed Query
Run queries distributed across multiple nodes for large datasets.
Performance and Benchmarking
Measure and optimize performance with benchmarks and best practices for your Spice.ai deployment.
Caching Accelerator
Use intelligent HTTP response caching with stale-while-revalidate (SWR).
Indexes on Accelerated Data
Create and manage indexes on accelerated data.
Configuration
Fine-tune your Spice.ai deployment with advanced configuration options for optimal performance.
SDKs
Use SDKs for different programming languages.
Spice.js JavaScript (Node.js) SDK
Query Spice.ai using the JavaScript (Node.js) SDK with examples.
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.
FAQs
Common questions about using the Spice.ai OSS Cookbook and choosing the right recipe to start with.
The cookbook is a curated set of practical, ready-to-run recipes for Spice.ai Open Source. Recipes cover connectors, federation, acceleration, hybrid search, model integration, and deployment patterns.
If you are new to Spice, start with the recipe that matches your goal. Federated SQL recipes cover multi-source queries, and DuckDB acceleration recipes cover faster performance. The OpenAI SDK and MCP recipes cover AI agent use cases.
Yes. Cookbook patterns are based on Spice OSS capabilities and can be adapted to Spice Cloud workflows. You can start locally with OSS and move to managed deployments as workloads grow. See Spice Cloud pricing.
Build faster with Spice
See how teams use Spice to turn cookbook patterns into production data and AI applications.
Get a demo (opens in a new tab)