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 server for self-hosted use).

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

Admin API

9 items

DuckDB Syntax

14 items

MCP Server

16 items

MotherDuck SQL

39 items

MotherDuck Wasm client

Connect browser applications to MotherDuck using the DuckDB WebAssembly client and Hybrid Query Execution.

Postgres Endpoint

Connection parameters, SSL options, session settings, and limitations for the MotherDuck Postgres wire protocol endpoint