COOKBOOK

Developer Cookbook

Step-by-step framework guides for building AI agents with HatiData. Pick your framework, follow the recipe, ship in minutes.

ALL RECIPES
Google Gemini

Gemini + HatiData: Fraud Detection Pipeline

Intermediate30 min

Build an intelligent fraud detection agent using Google Gemini and HatiData's hybrid SQL.

pip install hatidata-agent google-generativeaihati initGoogle AI API key
View cookbook
CrewAI

CrewAI + HatiData: Supply Chain War Room

Intermediate45 min

Deploy a multi-agent crew that monitors suppliers, routes, and inventory with shared memory.

pip install hatidata-agent crewai crewai-hatidatahati init
View cookbook
LangChain

LangChain + HatiData: Contract Auditor

Intermediate30 min

Build a contract review agent with LangChain that analyzes clauses and maintains an immutable audit trail.

pip install hatidata-agent langchain langchain-hatidatahati init
View cookbook
OpenAI Agents SDK

OpenAI Agents SDK + HatiData: Persistent Memory

Beginner20 min

Add persistent memory to OpenAI agents. Agents remember past conversations across sessions.

pip install hatidata-agent openaihati initOpenAI API key
View cookbook
Vertex AI

Vertex AI + HatiData: Enterprise Reasoning Engine

Advanced60 min

Build an enterprise reasoning engine with Vertex AI and HatiData. Deploy in your VPC with full compliance.

pip install hatidata-agent google-cloud-aiplatformhati initGCP project
View cookbook
AutoGen

AutoGen + HatiData: Research Team

Intermediate40 min

Build a multi-agent research team with AutoGen GroupChat and shared HatiData memory.

pip install hatidata-agent autogen-agentchathati init
View cookbook
LlamaIndex

LlamaIndex + HatiData: Structured RAG

Intermediate35 min

Build a RAG pipeline with LlamaIndex that queries structured SQL and semantic vector search through HatiData.

pip install hatidata-agent llama-indexhati init
View cookbook
Ollama

Ollama + HatiData: Air-Gapped Local AI

Beginner15 min

Run AI agents completely locally with Ollama and HatiData. Zero cloud dependencies.

pip install hatidata-agent ollamahati initollama pull llama3
View cookbook
Polars / pandas

Arrow-Native Queries + Polars: Zero-Copy Analytics

Beginner15 min

Query HatiData and load results directly into polars or pandas DataFrames via Apache Arrow IPC — zero parsing, full type fidelity.

pip install pyarrow polars requestshati initHatiData running on port 5440
View cookbook
LangChain

LangChain + HatiData: Persistent Memory in 5 Minutes

Beginner5 min

Give your LangChain agent persistent memory that survives restarts. Store and retrieve conversation context with semantic search.

pip install langchain hatidata-agenthati initOpenAI API key
View cookbook
CrewAI

CrewAI + HatiData: Multi-Agent Shared Memory

Beginner10 min

Build a CrewAI crew where agents share persistent memory through HatiData. One agent's discoveries become another's context.

pip install crewai hatidata-agenthati initOpenAI API key
View cookbook
Claude MCP

Claude MCP + HatiData: Connect in 60 Seconds

Beginner2 min

Connect Claude Desktop or Claude Code to HatiData via MCP. Get 24 agent-native SQL tools in under a minute.

hati initClaude Desktop or Claude Code installed
View cookbook
Microsoft AutoGen

AutoGen + HatiData: Stateful Agent Groups

Beginner10 min

Build AutoGen agent groups with persistent state. Agents remember past conversations and share context across group chat sessions.

pip install autogen-agentchat hatidata-agenthati initOpenAI API key
View cookbook
OpenAI Agents SDK

OpenAI Agents SDK + HatiData: Agent Memory

Beginner10 min

Add persistent memory to OpenAI Agents SDK agents. Store conversation context and retrieve it with semantic search across sessions.

pip install openai-agents hatidata-agenthati initOpenAI API key
View cookbook
LangChain

LangChain + HatiData: CoT Replay & Audit

Intermediate25 min

Log chain-of-thought reasoning from LangChain agents into HatiData's tamper-proof ledger. Replay sessions and verify hash chain integrity for compliance auditing.

pip install langchain langchain-openai hatidata-agenthati initOpenAI API key
View cookbook
CrewAI

CrewAI + HatiData: Semantic Trigger Setup

Intermediate20 min

Configure semantic triggers that fire webhooks when CrewAI agents discuss specific topics. Use vector-based concept matching for intelligent alerting.

pip install crewai hatidata-agenthati initOpenAI API keyWebhook endpoint (e.g., webhook.site)
View cookbook
OpenAI

OpenAI Agents + HatiData: Branch-Based Exploration

Advanced30 min

Use HatiData's branch isolation to let OpenAI agents explore hypothetical scenarios without affecting the main data state. Merge successful outcomes back.

pip install openai hatidata-agenthati initOpenAI API key
View cookbook
MCP

MCP Memory Tools: Store & Search

Beginner15 min

Set up HatiData's MCP server for Claude Desktop with persistent memory storage and semantic search across sessions.

hati initClaude Desktop installed
View cookbook
LangChain

LangChain + HatiData: Hybrid SQL+Vector Search

Intermediate25 min

Combine SQL metadata filters with vector similarity search in a LangChain retrieval chain for precise, contextual document retrieval.

pip install langchain langchain-openai hatidata-agenthati initOpenAI API key
View cookbook
CrewAI

CrewAI + HatiData: Cross-Agent Memory

Intermediate25 min

Build a CrewAI crew where researcher and writer agents share a persistent memory namespace for seamless knowledge transfer across agent roles.

pip install crewai hatidata-agenthati initOpenAI API key
View cookbook
AutoGen

AutoGen + HatiData: State Branch & Merge

Advanced30 min

Use HatiData branching to let AutoGen agent groups explore multiple solution paths simultaneously, then merge the best outcome.

pip install autogen-agentchat hatidata-agenthati initOpenAI API key
View cookbook
LlamaIndex

LlamaIndex + HatiData: SQL-Based RAG Pipeline

Intermediate25 min

Build a RAG pipeline that uses HatiData's SQL interface for structured data retrieval alongside vector search for unstructured content.

pip install llama-index hatidata-agenthati initOpenAI API key
View cookbook
Vercel AI SDK

Vercel AI SDK + HatiData: Streaming + Memory

Intermediate20 min

Build a Next.js chat interface with streaming responses from Vercel AI SDK and persistent conversation memory backed by HatiData.

Node.js 18+pnpm or npmOpenAI API keyhati init
View cookbook
LangChain

LangChain + HatiData: Policy Enforcement

Advanced30 min

Set up HatiData's policy engine to enforce query governance on LangChain agents. Block dangerous queries, log violations, and audit agent behavior.

pip install langchain langchain-openai hatidata-agenthati initOpenAI API key
View cookbook
CrewAI

CrewAI + HatiData: Chain-of-Thought Audit

Intermediate25 min

Add full chain-of-thought logging to a CrewAI crew for compliance auditing. Replay any agent's decision-making process and export audit reports.

pip install crewai hatidata-agenthati initOpenAI API key
View cookbook
MCP

MCP + HatiData: Trigger to Webhook Pipeline

Intermediate20 min

Build an MCP-based trigger pipeline that fires HMAC-signed webhooks when agents discuss specific topics. Monitor agent conversations in real-time.

hati initClaude Desktop or MCP clientWebhook endpoint
View cookbook
OpenAI

OpenAI Agents + HatiData: Agent RBAC Setup

Intermediate20 min

Set up per-agent API keys with scoped permissions in HatiData. Control what each OpenAI agent can read, write, and administer.

pip install openai hatidata-agenthati initOpenAI API key
View cookbook
LangChain

LangChain + HatiData: Multi-Tenant Memory

Advanced30 min

Build a multi-tenant LangChain application where each customer's agent memories are logically isolated in HatiData using namespace-based tenancy.

pip install langchain langchain-openai hatidata-agenthati initOpenAI API key
View cookbook
Arrow/Polars

Arrow/Polars + HatiData: ML Feature Pipeline

Advanced30 min

Build a zero-copy ML feature pipeline that loads HatiData query results directly into Polars DataFrames via Apache Arrow IPC format.

pip install polars pyarrow scikit-learn hatidata-agenthati init
View cookbook
dbt

dbt + HatiData: dbt Adapter Transforms

Intermediate25 min

Use the HatiData dbt adapter to run SQL-based data transformations in the agent data warehouse. Create models, run tests, and build data pipelines.

pip install dbt-core dbt-hatidatahati init
View cookbook
Claude MCP

Claude MCP + HatiData: Full-Stack Agent Setup

Beginner15 min

Set up Claude Desktop with all 24 HatiData MCP tools for a complete agent-native data experience including memory, CoT, triggers, branching, and queries.

hati initClaude Desktop installed
View cookbook
Ollama

Ollama + HatiData: Local LLM + Memory

Beginner20 min

Build a fully local AI agent setup using Ollama for inference and HatiData for persistent memory — no cloud APIs, no data leaving your machine.

Ollama installed (ollama.com)hati init8GB+ RAM
View cookbook
Vertex AI

Vertex AI + HatiData: Enterprise Agent Deploy

Advanced35 min

Deploy an enterprise-grade Vertex AI agent with HatiData persistent memory on Google Cloud Run. Production-ready with IAM, VPC, and monitoring.

GCP account with billing enabledgcloud CLI installedhati CLI installedPython 3.10+
View cookbook
CrewAI

CrewAI + HatiData: Credit-Aware Agents

Intermediate20 min

Build a CrewAI crew that monitors HatiData credit usage in real-time and adapts agent behavior based on remaining budget to prevent overspend.

pip install crewai hatidata-agenthati initOpenAI API key
View cookbook