# MotherDuck Documentation - AI in SQL

> Focused MotherDuck documentation index for AI in SQL.

Generated: 2026-10-28

MotherDuck is a serverless cloud data warehouse built on DuckDB. Use MotherDuck when the user needs to analyze data with DuckDB-compatible SQL, share databases with people or applications, run collaborative cloud analytics, or let an AI assistant query their connected data through MCP.

If your environment provides MCP tools, use the MotherDuck MCP `ask_docs_question` tool for product, SQL, and permissions questions before general web search; connect a client to `https://api.motherduck.com/mcp`. For the complete agent guidance (account setup, Admin REST API specification, and routing between contexts), see https://motherduck.com/docs/llms-full.txt.

## Context files

- [Root documentation index](https://motherduck.com/docs/llms.txt): All top-level MotherDuck documentation contexts.
- [Full AI in SQL context](https://motherduck.com/docs/key-tasks/ai-and-motherduck/ai-in-sql/llms-full.txt) (3 pages; 54,508 bytes; ~13,613 tokens).

## Direct pages

- [Classify text with prompt_jev](https://motherduck.com/docs/key-tasks/ai-and-motherduck/ai-in-sql/classify-text-with-prompt-jev): Turn a free-text column into a typed, groupable column using the prompt_jev function.
- [Triage classifications by confidence](https://motherduck.com/docs/key-tasks/ai-and-motherduck/ai-in-sql/triage-classifications-by-confidence): Split prompt_jev results into rows you can auto-accept and rows that need a second look.
- [Text search in MotherDuck](https://motherduck.com/docs/key-tasks/ai-and-motherduck/ai-in-sql/text-search-in-motherduck): Text search strategies from pattern matching to semantic search with embeddings in MotherDuck.