SQL reference

Complete SQL reference documentation for MotherDuck and DuckDB. This reference covers MotherDuck-specific SQL extensions, DuckDB's comprehensive SQL dialect, the Admin API for programmatic management, and the remote MCP Server for AI assistant integrations (and the local MCP for self-hosted use).

For practical examples and step-by-step instructions, see our How-to Guides and Getting Started tutorials.

MotherDuck SQL

31 items

Admin API

8 items

MCP Server

7 items

DuckDB Syntax

14 items

MotherDuck Wasm Client

MotherDuck is a managed DuckDB-in-the-cloud service.