MotherDuck Guides
Product · SaaS / cloud software by MotherDuck
Context belongs in the warehouse for smarter AI agents.
MotherDuck Guides is a context layer that teaches AI agents business definitions and query patterns to ensure accurate, consistent natural-language data analysis. It is ideal for teams using agents like Claude or ChatGPT who need trustworthy answers grounded in their specific business logic.
- Languages
- English
Category: Data Governance
- Deployment
- Cloud (MotherDuck serverless data warehouse)
- Integrations
- Claude, ChatGPT, Cursor, and any MCP-compatible agent
- Editions
- Lite, Business, Enterprise
- Target Users
- Data Teams, App Developers, and AI Agents
- Primary Function
- Shared context for AI agent query accuracy
- Integration Method
- MotherDuck MCP Server
- Shared context for better AI agent performance
- Ensures consistent answers across different agents
- Teaches agents business definitions for revenue and pipeline
- Reduces hallucinations by providing schema context and runbooks
Overview
MotherDuck Guides is a context layer designed to improve the performance and accuracy of AI agents working within the MotherDuck serverless data warehouse. It allows businesses to define and share critical metrics such as revenue, pipeline, and active customer definitions across all team agents. By providing this shared business context, Guides ensure that natural-language questions result in trustworthy and consistent SQL queries. The system works by loading portable knowledge, including query patterns and schema context, on demand whenever an agent performs a task. This reduces hallucinations and ensures that agents understand the specific nuances of a company's data architecture, making data exploration accessible to non-technical users.
Agent Intelligence
- Shared Business Context: Guides provide a context layer that teaches AI agents business definitions for metrics like revenue, pipeline, and active customers.
- Consistency Layer: The system ensures that different people using different agents get consistent and trustworthy answers by sharing the same context.
- Query Accuracy Improvement: Guides add shared context to every query, helping natural-language questions result in accurate SQL without writing code.
- On-demand Knowledge Loading: Portable knowledge including query patterns, schema context, and runbooks is loaded on demand by agents.
Plan Integration
- Lite Plan Availability: Guides are included in the MotherDuck Lite plan for solo practitioners and hobbyists.
- Business Plan Integration: The Business plan includes Guides to provide shared context for better AI agent performance in production environments.
Use cases
- Data teams define revenue and pipeline metrics once to ensure all AI agents provide consistent answers across the company.
- Non-technical users ask natural-language questions and receive accurate SQL queries grounded in shared business context.
- AI agents use portable knowledge and runbooks from Guides to reduce hallucinations when exploring complex data schemas.
Specifications
- Deployment
- Cloud (MotherDuck serverless data warehouse)
- Integrations
- Claude, ChatGPT, Cursor, and any MCP-compatible agent
- Editions
- Lite, Business, Enterprise
- Target Users
- Data Teams, App Developers, and AI Agents
- Primary Function
- Shared context for AI agent query accuracy
- Supported Metrics
- Revenue, pipeline, active customers, and custom business definitions
- Integration Method
- MotherDuck MCP Server
- Context Types
- Query patterns, schema context, and runbooks
How it works
- Define Business Context: Users define business metrics, query patterns, and schema context within the MotherDuck platform.
- Share Context Layer: The defined context is shared across the organization's MotherDuck workspace.
- Agent Query Execution: When an AI agent (like Claude or ChatGPT) queries MotherDuck, it automatically loads the relevant Guide context to inform its SQL generation.
Pricing
- Lite Plan
- Included in $0 plan
- Business Plan
- Included in $250 per org / month + usage
- Enterprise Plan
- Included in Custom pricing
FAQ
How do MotherDuck Guides improve AI agent performance?
Guides provide a context layer that teaches agents business definitions for revenue, pipeline, and active customers, ensuring they understand the specific nuances of a company's data.
Are Guides available on the free Lite plan?
Yes, Guides are included in the MotherDuck Lite plan, which is available for free for solo practitioners and hobbyists.
Which AI agents work with MotherDuck Guides?
Guides are designed to work with AI agents like Claude, ChatGPT, and Cursor, specifically through the MotherDuck MCP server.
Added by AntSpace from public sources (motherduck.com).