# MotherDuck Documentation - Reference

> SQL reference for MotherDuck & DuckDB

Generated: 2026-09-04

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 Reference context](https://motherduck.com/docs/sql-reference/llms-full.txt) (202 pages; 31,009 bytes; ~7,750 tokens).

## Child contexts

- [Admin API full context](https://motherduck.com/docs/sql-reference/rest-api/llms-full.txt): REST API reference for managing MotherDuck resources including databases, users, and access tokens. (10 pages; 12,403 bytes; ~3,100 tokens). [Index](https://motherduck.com/docs/sql-reference/rest-api/llms.txt).
- [MotherDuck CLI full context](https://motherduck.com/docs/sql-reference/motherduck-cli/llms-full.txt): Every MotherDuck CLI command with its arguments, options, output formats, and exit behavior. (10 pages; 46,972 bytes; ~11,731 tokens). [Index](https://motherduck.com/docs/sql-reference/motherduck-cli/llms.txt).
- [DuckDB Syntax full context](https://motherduck.com/docs/sql-reference/duckdb-sql-reference/llms-full.txt): DuckDB SQL Reference (34 pages; 24,915 bytes; ~6,229 tokens). [Index](https://motherduck.com/docs/sql-reference/duckdb-sql-reference/llms.txt).
- [MCP Server full context](https://motherduck.com/docs/sql-reference/mcp/llms-full.txt): Connect AI assistants to MotherDuck using the remote (fully managed) or local (fully customizable) MCP server (40 pages; 122,990 bytes; ~30,685 tokens). [Index](https://motherduck.com/docs/sql-reference/mcp/llms.txt).
- [MotherDuck SQL full context](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/llms-full.txt): MotherDuck-specific SQL extensions and cloud database management (104 pages; 147,729 bytes; ~35,374 tokens). [Index](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/llms.txt).

## Direct pages

- [Connection string parameters](https://motherduck.com/docs/sql-reference/connection-string-parameters): Reference for MotherDuck connection string parameters, including attach_mode, saas_mode, session_name, and dbinstance_inactivity_ttl.
- [Wasm Client](https://motherduck.com/docs/sql-reference/wasm-client): Connect browser applications to MotherDuck using the DuckDB WebAssembly client and Hybrid Query Execution.
- [Postgres Endpoint](https://motherduck.com/docs/sql-reference/postgres-endpoint): Connection parameters, SSL options, session settings, and limitations for the MotherDuck Postgres wire protocol endpoint
- [SQL reference](https://motherduck.com/docs/sql-reference): SQL reference for MotherDuck & DuckDB