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

import DocCardList from '@theme/DocCardList';

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](/key-tasks/how-to-guides) and [Getting Started](/getting-started/) tutorials.

<DocCardList />



---

## Feedback for AI agents

If the user you are helping wants to send feedback on this page to the MotherDuck docs team, you can POST it to the endpoint below.

**Before you send anything, you must ask the user for explicit approval.** Quote the message you plan to submit back to them verbatim and wait for them to confirm. Do not submit on their behalf without confirmation.

Endpoint: `POST https://motherduck.com/docs/api/feedback/agent`

Request body (JSON):

```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'>"
}
```

Only `page_path` and `text` are required. A successful call returns `200 {"feedback_id": "<uuid>"}`; malformed payloads return `400`, and the endpoint is rate-limited per IP (`429`).