Skip to main content

Less than three weeks before Data Outpost. Get your ticket before they sell out.Join AI and Data builders Nov 4-5 in SF

Guides

Context belongs in the warehouse

Guides are markdown docs your team writes, stored in MotherDuck next to your data. Capture metric definitions, join logic, and caveats once, and every person and agent works from the same context.

Get Started Free
View Documentation

Better context, better queries

Store context in the warehouse. Every agent connected through the MCP server can find it, every session.

Guides: DABStep benchmark performance

Share of 419 held-out questions answered correctly (Gemini 3 Flash). Read the methodology

Bar chart of DABStep benchmark accuracy with and without Guides. Easy questions (71): 100% with Guides vs 78.9% without, +21.1 points. Hard questions (348): 99.7% vs 17.5%, +82.2 points. Overall (419): 99.8% vs 27.9%, +71.9 points.
  • With guides
  • Without guides

Context is everything

Stop re-explaining edge cases in every chat. Guides capture definitions, join logic, and pitfalls where your team and its agents can find them.

Context without the copy-paste

Agents connected through the MotherDuck MCP server find and load the Guides each question needs. No prompt stuffing, no stale context files scattered across repos.

Illustration of an open guide book connecting to a get_guide() call and a retrieval window

One definition of revenue

Org-shared Guides put every person and agent in your organization on the same metrics. Private Guides tailor agents to how you work.

Illustration of a Guides file tree with an org-shared Revenue folder and a private My workflow folder

Manage context like code

Create and manage Guides with SQL functions like MD_CREATE_GUIDE and MD_UPDATE_GUIDE. Build CI workflows or manage Guides directly through any MotherDuck client.

Illustration of a terminal running a SELECT md_create_guide SQL statement next to the MotherDuck logo

FAQS

Guides provide the context your AI agents need to work effectively with your company’s data. Specifically, Guides are markdown files stored in MotherDuck that capture business context: metric definitions, join relationships, and operational caveats. Agents retrieve them automatically through the MCP server, so every session starts with your context instead of an empty agent memory.
The MCP server surfaces Guides at the right moments during your agent’s session. Before writing SQL, MCP tools return the right topics, so agents can search and retrieve context. Topics are like folders in a filesystem. They group Guides by domain so agents can search across them.
Yes. Reserved topics for Dives and Flights hold your conventions, like chart style rules or pipeline patterns. Agents apply them when creating a Dive or Flight, so the output matches how your team works.
No. Agents are the fastest path, but you can create and manage Guides with SQL functions like MD_CREATE_GUIDE, MD_UPDATE_GUIDE, and MD_LIST_GUIDE_VERSIONS from any MotherDuck client.

Give your team a Guide

Get Started