# MotherDuck Documentation - Loading data into MotherDuck

> Learn how to load data into MotherDuck from various sources

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 Loading data into MotherDuck context](https://motherduck.com/docs/key-tasks/loading-data-into-motherduck/llms-full.txt) (9 pages; 53,566 bytes; ~13,388 tokens).

## Direct pages

- [Loading Data Best Practices](https://motherduck.com/docs/key-tasks/loading-data-into-motherduck/considerations-for-loading-data): Understanding trade-offs and performance implications when loading data into MotherDuck
- [Data loading patterns](https://motherduck.com/docs/key-tasks/loading-data-into-motherduck/loading-patterns): Common data loading patterns for production pipelines, including incremental loads, upserts, deduplication, and idempotent operations in MotherDuck.
- [From Your Local Machine](https://motherduck.com/docs/key-tasks/loading-data-into-motherduck/loading-data-from-local-machine): Moving data from local to MotherDuck through the UI or programmatically.
- [Loading data to MotherDuck with Python](https://motherduck.com/docs/key-tasks/loading-data-into-motherduck/loading-data-md-python): Efficient methods for loading data from Python using DataFrames, temporary files, or bulk inserts.
- [From Cloud Storage or over HTTPS](https://motherduck.com/docs/key-tasks/loading-data-into-motherduck/loading-data-from-cloud-or-https): Load data into MotherDuck from S3, Azure, GCS, or public HTTPS URLs.
- [Load a DuckDB database into MotherDuck](https://motherduck.com/docs/key-tasks/loading-data-into-motherduck/loading-duckdb-database): Upload a local DuckDB database file to MotherDuck cloud storage.
- [From a PostgreSQL or MySQL Database](https://motherduck.com/docs/key-tasks/loading-data-into-motherduck/loading-data-from-postgres): Learn to load a table from your PostgreSQL or MySQL database into MotherDuck.
- [Via the Postgres Endpoint](https://motherduck.com/docs/key-tasks/loading-data-into-motherduck/loading-data-via-postgres-endpoint): Best practices for loading data into MotherDuck efficiently when you are connected through the Postgres endpoint.
- [Loading Data into MotherDuck](https://motherduck.com/docs/key-tasks/loading-data-into-motherduck): Learn how to load data into MotherDuck from various sources