# MotherDuck Documentation - Interfaces

> MotherDuck Offers a variety of interfaces (APIs) for integration

Generated: 2026-08-25

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`. Every linked full context is self-contained and carries the complete agent guidance (MCP tools, account setup, Admin REST API specification, and the docs feedback API); 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 Interfaces context](https://motherduck.com/docs/getting-started/interfaces/llms-full.txt) (21 pages; 69,362 bytes; ~17,309 tokens).

## Child contexts

- [Client APIs full context](https://motherduck.com/docs/getting-started/interfaces/client-apis/llms-full.txt): Client APIs for MotherDuck (11 pages; 20,601 bytes; ~5,148 tokens). [Index](https://motherduck.com/docs/getting-started/interfaces/client-apis/llms.txt).
- [MotherDuck CLI full context](https://motherduck.com/docs/getting-started/interfaces/motherduck-cli/llms-full.txt): Drive MotherDuck from your terminal: run queries, build Dives and Flights, and script it all with JSON output. (5 pages; 25,966 bytes; ~6,491 tokens). [Index](https://motherduck.com/docs/getting-started/interfaces/motherduck-cli/llms.txt).

## Direct pages

- [Install and connect with the DuckDB CLI](https://motherduck.com/docs/getting-started/interfaces/connect-query-from-duckdb-cli): Learn to connect and query databases using MotherDuck from the DuckDB CLI
- [MotherDuck Web UI](https://motherduck.com/docs/getting-started/interfaces/motherduck-quick-tour): A guide to the MotherDuck Web UI — write SQL with Instant SQL, use AI to fix and edit queries, and explore your data interactively.
- [Postgres endpoint](https://motherduck.com/docs/getting-started/interfaces/postgres-endpoint): Query MotherDuck from any Postgres-compatible client without installing DuckDB
- [Third-Party Tools with PostgreSQL](https://motherduck.com/docs/getting-started/interfaces/third-party-tools): Connect third-party tools and IDEs to MotherDuck using the Postgres wire protocol endpoint
- [MotherDuck Interfaces](https://motherduck.com/docs/getting-started/interfaces): MotherDuck Offers a variety of interfaces (APIs) for integration