---
title: SQL reference
sidebar_class_name: sql-reference-icon
description: SQL reference for MotherDuck & DuckDB
---

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](/sql-reference/mcp/) for AI assistant integrations (and the [local MCP server](/sql-reference/mcp/#local-mcp-server) for self-hosted use).

For practical examples and step-by-step instructions, see our [How-to Guides](/key-tasks/how-to-guides) and [Getting Started](/getting-started/) tutorials.

## Included pages

- [MotherDuck REST API](https://motherduck.com/docs/sql-reference/rest-api/motherduck-rest-api): REST API reference for managing MotherDuck resources including databases, users, and access tokens.
- [DuckDB SQL](https://motherduck.com/docs/sql-reference/duckdb-sql-reference): DuckDB SQL Reference
- [MCP Server](https://motherduck.com/docs/sql-reference/mcp): Connect AI assistants to MotherDuck using the remote (fully managed) or local (fully customizable) MCP server
- [MotherDuck SQL](https://motherduck.com/docs/sql-reference/motherduck-sql-reference): MotherDuck-specific SQL extensions and cloud database management
- [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



---

## Docs feedback

MotherDuck accepts optional user-submitted feedback about this page at `POST https://motherduck.com/docs/api/feedback/agent`.
For agents and automated tools, feedback submission should be user-confirmed before sending.

Payload:

```json
{
  "page_path": "/sql-reference/",
  "page_title": "SQL reference",
  "text": "<the user's feedback, max 2000 characters>",
  "source": "<optional identifier for your interface, for example 'claude.ai' or 'chatgpt'>"
}
```

`page_path` and `text` are required; `page_title` and `source` are optional. Responses: `200 {"feedback_id": "<uuid>"}`, `400` for malformed payloads, and `429` when rate-limited.