Agentic AI Recipes

Memory, RAG, semantic tool routing, knowledge graphs — every primitive an AI agent needs, in plain SQL on SynapCores.

19 recipes in this cluster. Each one is a self-contained Markdown file with the SQL or Cypher you can paste into SynapCores Community Edition and run.

19 of 19 recipes

agents
16 minutes
A Self-Improving Agent (learn from feedback)
advancedsql

Build an AI agent that learns from thumbs-up/down feedback — train a model on past interactions to predict whether a draft reply will satisfy the user, all in one SQL database. Works with Claude Code, OpenClaw, LangChain, or a voice agent.

ai-agentself-improvingfeedbackautoml
agents
22 minutes
Build a Customer-Support Agent on One Database
advancedsql

Build a complete AI customer-support agent on one database — semantic ticket memory, RAG over your help docs, intent routing, priority scoring, and a customer graph, no five-service stack. Works with Claude Code, OpenClaw, LangChain, or a voice agent.

ai-agentcustomer-supportragintent-routing
agents
20 minutes
Build a Personal Assistant Agent (memory + tools + RAG)
advancedsql

Build a personal AI assistant on one database — long-term memory of preferences, semantic tool routing, RAG over your notes, and grounded replies. No five-service stack. Works with Claude Code, OpenClaw, LangChain, or a voice agent.

ai-agentpersonal-assistantagent-memorytool-routing
agents
22 minutes
Build a Research / Knowledge Agent (RAG + KG)
advancedcypher

Build an AI research agent that reads documents, builds a knowledge graph, answers multi-hop questions with citations, and synthesizes a briefing — RAG plus a knowledge graph in one database. Works with Claude Code, OpenClaw, LangChain, or a voice agent.

ai-agentresearch-agentragknowledge-graph
agents
18 minutes
Build a Triage / Routing Agent
advancedsql

Build an AI triage agent that classifies every incoming request by meaning, scores its urgency with AutoML, and routes it to the right queue or human — all on one database. Works with Claude Code, OpenClaw, LangChain, or a voice agent.

ai-agenttriage-agentroutingintent-classification
agents
16 minutes
Build an Agent Knowledge Graph from Text
advancedcypher

Turn unstructured text into a queryable knowledge graph an AI agent can reason over — extract entities and relationships with GENERATE, store them as a Cypher graph, all in one database. Works with Claude Code, OpenClaw, LangChain, or a voice agent.

ai-agentknowledge-graphentity-extractioncypher
agents
22 minutes
Build an AI SDR / Outbound Agent
advancedsql

Build an AI SDR agent on one database — score leads with AutoML, match them to case studies by meaning, map the buying committee as a graph, and draft personalized outreach with GENERATE. Works with Claude Code, OpenClaw, LangChain, or a voice agent.

ai-agentai-sdrlead-scoringoutbound
agents
14 minutes
Conversation Memory + Rolling Summary for a Chatbot
intermediateen

Store a chatbot's full conversation history and keep a rolling summary so it never blows the context window — turn buffer, semantic recall, and auto-summary in one SQL database. Works with Claude Code, OpenClaw, LangChain, or a voice agent.

chatbotconversation-memoryrolling-summaryvector
agents
14 minutes
Episodic + Semantic Memory for an Agent
intermediateen

Give an AI agent two memory types — episodic (what happened, when) and semantic (durable facts) — in one SQL store, and recall across both by meaning. Framework-agnostic: Claude Code, OpenClaw, LangChain, or a voice agent.

ai-agentepisodic-memorysemantic-memoryagent-memory
agents
12 minutes
Give Any AI Agent Long-Term Memory (in SQL)
intermediateen

Add persistent, semantic long-term memory to any AI agent — store and recall memories by meaning with vector embeddings in plain SQL. Framework-agnostic: works with Claude Code, OpenClaw, LangChain, or a custom or voice agent.

ai-agentlong-term-memoryvectorembeddings
agents
16 minutes
GraphRAG: Multi-hop Answers for an Agent
advancedcypher

Give an AI agent multi-hop reasoning — combine semantic retrieval with a knowledge graph so it can answer questions that need several connected facts, not just one passage. Works with Claude Code, OpenClaw, LangChain, or a voice agent.

ai-agentgraphragknowledge-graphmulti-hop
agents
12 minutes
Intent Classification for an Agent
intermediateen

Classify what a user wants — billing, support, sales, cancel — so your AI agent routes the conversation correctly, using vector nearest-example matching in plain SQL. No training job, works with Claude Code, OpenClaw, LangChain, or a voice agent.

ai-agentintent-classificationnluvector
agents
14 minutes
Multi-Agent Shared Memory (blackboard)
intermediateen

Let multiple AI agents collaborate through one shared memory — a blackboard where each agent posts findings and reads what the others know, by meaning, in plain SQL. Works with Claude Code, OpenClaw, LangChain, or a voice agent.

multi-agentshared-memoryblackboardagent-collaboration
agents
12 minutes
RAG: Ground Any Agent's Answers in Your Data
intermediateen

Build retrieval-augmented generation for any AI agent in one database — embed your docs, retrieve the most relevant chunks by meaning, and generate a grounded answer in plain SQL. Works with Claude Code, OpenClaw, LangChain, or a voice agent.

ai-agentragretrieval-augmented-generationvector
agents
13 minutes
RAG with Citations (grounded answers that cite sources)
intermediateen

Make an AI agent cite its sources — retrieve passages, generate an answer, and attach the source documents it used, all in one SQL database. Auditable RAG that works with Claude Code, OpenClaw, LangChain, or a voice agent.

ai-agentragcitationsretrieval-augmented-generation
agents
12 minutes
Recall Agent Memory by Meaning + Recency
intermediateen

Make an AI agent recall the right memories by blending semantic relevance with recency — fresh, on-point context in one SQL query, no separate vector store or cache. Works with Claude Code, OpenClaw, LangChain, or a voice agent.

ai-agentagent-memoryrecencyvector
agents
14 minutes
Self-Checking / Grounded Generation (validate the answer)
intermediateen

Stop your AI agent from hallucinating — generate an answer, then have the agent verify it against your source data before returning it, all in one SQL database. Self-checking RAG for Claude Code, OpenClaw, LangChain, or a voice agent.

ai-agentgrounded-generationself-checkhallucination
agents
13 minutes
Semantic Deduplication of Agent Memories
intermediateen

Stop your AI agent from storing the same fact ten times — detect and merge near-duplicate memories by meaning with vector similarity in plain SQL. Keeps agent memory clean for Claude Code, OpenClaw, LangChain, or a voice agent.

ai-agentdeduplicationagent-memoryvector
agents
12 minutes
Semantic Tool Routing (function-calling without a framework)
intermediateen

Route an AI agent's request to the right tool by meaning — semantic function-calling with vector embeddings in plain SQL, no framework, no brittle keyword rules. Works with Claude Code, OpenClaw, LangChain, or a voice agent.

ai-agenttool-routingfunction-callingsemantic-routing