Overview
MotherDuck is a collaborative data warehouse that extends the power of DuckDB to the cloud. It combines the best of both worlds:
- Hybrid local-cloud processing: Query local data or scale to the cloud seamlessly
- Serverless architecture: No cluster management or infrastructure provisioning
- Collaborative features: Share queries, tables and results with team members
- DuckDB compatibility: Same intuitive SQL interface with cloud scalability
- Pay-for-use pricing: Only pay for the compute and storage you actually use
MotherDuck enables data analytics without the complexity of traditional data warehouses while maintaining the speed and simplicity of DuckDB.
Connecting
To connect to MotherDuck with DBCode, you’ll need:
-
Get a MotherDuck Access Token:
- Sign up or log in to your MotherDuck account
- Go to the dashboard settings page
- Generate and copy your service token
-
Connect in DBCode:
- Open the DBCode Extension in Visual Studio Code
- Click on the “Add Connection” icon
- Choose MotherDuck as the database type
- Paste your service token
- Provide optional connection name and database path
-
Start Analyzing Data: Once connected, you can begin running queries across your local and cloud data.
For detailed instructions on connecting to MotherDuck, refer to the Connect article.
MotherDuck Features in DBCode
DBCode enhances your MotherDuck experience with:
- SQL query editor: Write and execute queries with MotherDuck-specific syntax highlighting
- Data preview: Quickly inspect sample data from tables in your MotherDuck database
- File import integration: Easily load local CSV and other formats into MotherDuck
- Query performance visualization: Understand and optimize your query execution
- Results export: Save query results to local files in various formats
By using MotherDuck with DBCode, you can harness the power of DuckDB in the cloud while working directly within your familiar VS Code environment.
For more information about MotherDuck, check out MotherDuck.