--- title: "Serverless DuckDB Data Warehouse for Data Teams | MotherDuck" description: "Serverless DuckDB cloud data warehouse for data teams. Run DuckDB in the cloud for fast, efficient analytics. Ingest and transfrom your data with Flights, give context to agents with Guides, and build visuals with Dives. Source controlled end-to-end." canonical: "https://motherduck.com/product/data-teams/" --- # A serverless DuckDB data warehouse for data teams ## Run DuckDB SQL locally and in the cloud, with isolated compute for every user and built-in collaboration. [Get Started](https://auth.motherduck.com/authorize?app_source=web&response_type=code&client_id=bza3KWQpxRAFlTlRFXUo29AOg9xD7zcp&redirect_uri=https%3A%2F%2Fapp.motherduck.com%2F&state=STATE&auth_flow=signup&screen_hint=signup&ext-ph_distinct_id=158b878a-8920-412d-b1ec-699b0c0e526a) LEARN MORE YouTube video preview Why MotherDuckWhy MotherDuckWhy MotherDuckWhy MotherDuckWhy MotherDuckWhy MotherDuckWhy MotherDuckWhy MotherDuckWhy MotherDuckWhy MotherDuckWhy MotherDuckWhy MotherDuckWhy MotherDuck ## Isolated compute for every analyst Each user gets a dedicated serverless runtime, so analysts can work without competing for shared warehouse resources. Develop locally and then ship to the cloud with the same database. ### Each user gets their own compute instance “duckling” MotherDuck’s per-user tenancy model enables teams to configure each org member individually. By default, each user in an Organization, or team, has their own dedicated, serverless isolated runtime. CPU visibility is provided per-user for simple, straightforward cost attribution and usage auditing. ### Push work down to the client MotherDuck turns users’ laptops into local, easy-to-use execution nodes. DuckDB’s unique portability enables teams to work locally and in the cloud with the same database. Since queries process closer to where data is stored, local compute is saved for analytical processing. ## A faster SQL and Python workflow Use your favorite agent & the DuckDB python library to rapidly build and iterate on python notebooks. Simply use SQL interchangably with data frames and offload larger queries to MotherDuck. ### AI-enabled UI and workflows As the primary work surface for many analysts, our mission is to make MotherDuck’s UI your preferred place to quickly hone in on the data that matters. Stay focused on getting answers quickly and editing complex SQL queries auto-magically with [FixIt](https://motherduck.com/blog/introducing-fixit-ai-sql-error-fixer/). Alternatively, use the [Column Explorer](https://motherduck.com/blog/introducing-column-explorer/)’s automated sparklines and summary stats to hone your analysis. Once added to your data toolkit, we think you’ll take to it like a duck to water. ### Versatile SQL and Python Support MotherDuck builds on DuckDB’s portable nature and allows you to integrate it directly into your data analysis workflows. With comprehensive support for enhanced and traditional SQL, users do not have to compromise on query readability, even in a Python environment. You can even run Python scripts and Jupyter notebooks or transfer data between DuckDB and pandas dataframes. For additional flexibility, DuckDB also has a dataframe-style API, giving SQL and Python users something to quack about. ### Backed by the modern duck stack MotherDuck complements and [integrates with your existing data stack](https://motherduck.com/ecosystem/). Thanks to DuckDB’s momentum, our flock of partners is ready to ensure your analytics workflows take flight with local and remote queries. Many of our partners already support DuckDB, and some even use it in their core product as a cache or batch processing engine. For DuckDB users, getting started is as easy as executing `‘.open md:’` in the CLI. ## MotherDuck UI See it in action! MotherDuck UI Video Preview ### Query, Upload, share Join MotherDuck Co-founder, Ryan Boyd, for a tour of the MotherDuck UI and see how you can: - Query data from the public_data share - Get a bird’s eye view of your data with the [Column Explorer](https://motherduck.com/blog/introducing-column-explorer/), and see how result sets are stored in DuckDB running in the browser to enable faster filtering and pivoting - Upload data from the local machine to MotherDuck - Write basic analytic queries and use [FixIt](https://motherduck.com/blog/introducing-fixit-ai-sql-error-fixer/) to catch SQL syntax errors - Share uploaded data with colleagues ## Analytics beyond a laptop MotherDuck keeps DuckDB's efficient, embeddable engine while adding cloud compute and storage. Teams use it for datasets from a few CSVs to many terabytes. ### DuckDB's columnar engine DuckDB uses columnar, vectorized execution for analytical workloads. MotherDuck extends that engine to managed cloud compute and adds differential storage and zero-copy sharing to add even more scale. ### Run queries across local and cloud compute [Dual execution](https://motherduck.com/blog/announcing-motherduck-duckdb-in-the-cloud/) routes work to your laptop, the cloud, or both, then returns one result. Use local compute when it is available and scale beyond local memory when you need to. ## Features [Serverless DuckDBRun DuckDB SQL analytics in a serverless cloud data warehouse. Dual execution runs query stages on your laptop, in the cloud, or across both, and zero-copy shares let teammates query the same data.More Details](/product/) [MCP for AI agentsConnect Claude, ChatGPT, Cursor, or any MCP-compatible agent to MotherDuck. Natural-language questions come back as accurate, traceable SQL, running in sandboxed compute.More Details](/product/mcp-server/) [Share business contextGuides give AI agents shared business context on every query, so natural-language answers stay accurate for the people who know the business.More Details](/docs/key-tasks/guides/) [Live data visualizationsDives are live, interactive visualizations built by an AI agent or with SQL — filter and drill down on live data, share them, or embed them in your app.More Details](/product/dives/) [Scheduled data pipelinesFlights are scheduled Python data pipelines that run inside MotherDuck. Describe a source and your agent writes, deploys, and schedules the ingestion job.More Details](/product/flights/) [Isolated computeHypertenancy gives each user, customer, or AI agent an isolated DuckDB instance — high concurrency with no shared clusters or noisy neighbors, plus up to 16 read-scaling replicas.More Details](/product/hypertenancy/) ## Architecture Managed DuckDB-in-the-cloud ## Ducking simple cloud data warehouse pricing Blazing fast analytics without flyaway costs [Learn more](/product/pricing/) ## Ecosystem Modern Duck Stack ### CLOUD DATA WAREHOUSE ### Sources ### AI Agents [IngestionMORE INFO](/ecosystem/?category=Ingestion)[Business IntelligenceMORE INFO](/ecosystem/?category=Business+Intelligence)[Reverse ETLMORE INFO](/ecosystem/?category=Reverse+ETL)[TransformationMORE INFO](/ecosystem/?category=Transformation)[Data Science & AIMORE INFO](/ecosystem/?category=Data+Science+%26+AI) [OrchestrationMORE INFO](/ecosystem/?category=Orchestration) [Data QualityMORE INFO](/ecosystem/?category=Data+Quality) ## Case Studies