# MotherDuck Documentation - Data Transformation

> Transform your data inside MotherDuck

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 Data Transformation context](https://motherduck.com/docs/integrations/transformation/llms-full.txt) (5 pages; 36,155 bytes; ~9,036 tokens).

## Direct pages

- [dbt with DuckDB and MotherDuck](https://motherduck.com/docs/integrations/transformation/dbt): Data Build Tool (dbt) is an open-source command-line tool that enables data analysts and engineers to transform data in their warehouses by defining SQL in model files. It bring the composability of programming languages to SQL while automating the mechanics of updating tables.
- [dbt Cloud with MotherDuck](https://motherduck.com/docs/integrations/transformation/dbt-cloud): Connect dbt Cloud to MotherDuck natively through the Postgres endpoint using dbt's built-in Postgres adapter, with no self-hosted proxy.
- [Data Transformation](https://motherduck.com/docs/integrations/transformation): Transform your data inside MotherDuck
- [Paradime](https://motherduck.com/docs/integrations/transformation/paradime): Modern data transformation platform for building and managing data pipelines. It integrates with MotherDuck for running data transformation projects against MotherDuck.
- [SQLMesh](https://motherduck.com/docs/integrations/transformation/sqlmesh): SQLMesh is a data transformation tool for building and managing data pipelines. It integrates with MotherDuck for running data transformation projects against MotherDuck.