---

title: 'Spice.ai Use Cases' sidebar_label: 'Use Cases' sidebar_position: 4 description: 'Discover how to use Spice.ai for data federation, reverse-ETL, database CDN, enterprise search, RAG, and building AI-powered applications and agents.' keywords: [spice.ai, use cases, data federation, reverse-etl, database cdn, enterprise search, rag, ai agents, data mesh] image: /img/og/spiceai.png pagination_prev: null pagination_next: null

Spice supports a range of use cases across data infrastructure, search, and AI. Each use case below describes a specific scenario with architecture guidance, configuration examples, and links to relevant cookbook recipes.

For hands-on examples, see the Spice.ai Cookbook (opens in a new tab).

Data Federation, Acceleration, and SQL Query

• Reverse-ETL (opens in a new tab): Serve data from warehouses and data lakes to operational systems, applications, and dashboards, eliminating complex pipelines.
• ETL-free Workflows and Data Migrations (opens in a new tab): Enable data migrations and workflows without ETL federating legacy and modern systems for faster time-to-market and lower operational overhead.
• Database CDN (opens in a new tab): Locally replicate working sets of data for operational applications, caching dynamic data for high performance, low-latency, and resilience.
• Data Mesh (opens in a new tab): Unified data access across disparate sources with acceleration.
• Object-Store Native Database (opens in a new tab): Federates, accelerates, and queries object-store data for real-time data access without centralized warehouses.

Caching

• Write-Through Cache (opens in a new tab): Write data through Spice to both a local accelerator and the upstream source, keeping both layers consistent.
• Read-Through Cache (opens in a new tab): Fetch data from the upstream source on cache miss, with stale-while-revalidate and stale-if-error semantics.
• SQL/Database Cache (opens in a new tab): Cache SQL database tables locally with acceleration and cache SQL query results in memory.
• S3 Cache (opens in a new tab): Cache S3 and object store data locally with smart refresh skip for unchanged files.
• HTTP Cache (opens in a new tab): Cache HTTP API responses locally with request filtering, TTL, and stale-while-revalidate support.

Search and Retrieval

• Enterprise Search (opens in a new tab): Semantic and full-text-search search with hybrid vector and keyword capabilities.
• Object-Store Native Search (opens in a new tab): Enables SQL queries, hybrid search, and LLM inference on object-store data for security applications, delivering real-time insights.
• Simplifying Real-Time Data Collection and Search (opens in a new tab): Processes streaming and static data with integrated search for real-time insights in health-tech, focusing on application logic.

Retrieval-Augmented-Generation (RAG)

• RAG for Contextual Applications (opens in a new tab): Combines structured and unstructured data for context-rich AI outputs in SaaS chatbots, improving user interactions.
• RAG for AI-Powered Reporting (opens in a new tab): Generates dynamic, context-aware AI-driven reports for operational insights in health-tech, ensuring compliance and precision.

AI Applications and Agents

• Real-Time Decision-Making for Intelligent Applications (opens in a new tab): Powers instant, context-aware decisions for security applications by grounding AI in federated, low-latency datasets.
• Edge-Enabled AI Applications and Agents (opens in a new tab): Deploys AI applications across cloud and edge for low-latency decisions in security IoT use cases.
• Tool-Augmented AI with Model Context Protocol Server (opens in a new tab): Extends AI with custom tools via MCP server in finserv, integrating domain-specific APIs for enhanced functionality.
• Agentic AI Applications and Agents (opens in a new tab): Builds intelligent, autonomous agents for SaaS applications, enabling context-aware automation and decision-making.
• Multi-Tenant AI Agents (opens in a new tab): Deploy AI agents across many SaaS tenants with strict isolation and no per-tenant ETL pipelines.