How to Use the New DuckDB UI – Fast, Free, and Local

@duckdb in partnership with MotherDuck, released a free local DuckDB UI! @mehdio walks through a getting started with the DuckDB UI Try now when launching the DuckDB CLI using `duckdb -ui` ☁️🦆 Start using DuckDB in the Cloud for FREE with MotherDuck : https://hubs.la/Q02QnFR40 📓 Resources DuckDB CLI install docs : https://duckdb.org/docs/installation/ DuckDB UI docs : https://duckdb.org/docs/stable/extens... DuckDB UI repository : https://github.com/duckdb/duckdb-ui DuckDB UI launch blog : https://duckdb.org/2025/03/12/duckdb-... ➡️ Follow Us LinkedIn:   / motherduck   X/Twitter :   / motherduck   Blog: https://motherduck.com/blog/ #duckdb #dataengineering #gettingstartedduckdbui DuckDB, the powerful in-process OLAP database, is a favorite for data developers, but exploring data via the DuckDB CLI can be cumbersome. This video introduces the new local DuckDB UI, a game-changer for your local data exploration experience. We'll show you how to install and launch this SQL notebook interface, which runs as a simple DuckDB UI extension, making data analysis more intuitive and accessible than ever before. Discover the core features of the DuckDB UI, from its interactive SQL notebook with familiar shortcuts to the insightful table explorer that provides instant metrics on your datasets. We demonstrate how this tool excels at local data analysis by loading and querying a massive 10GB, 42-million-row Parquet file in under a second. Learn DuckDB optimization techniques for handling large local files and see why it’s the perfect local SQL tool for data engineers and analysts. This tutorial also covers how to seamlessly bridge your local and cloud workflows by connecting the DuckDB UI to your MotherDuck account. With a single sign-on, you can access your cloud database and leverage cloud compute and storage directly from the same familiar interface. We'll query sample datasets like NYC service complaints, showcasing how to use DuckDB and MotherDuck together as a hybrid cloud data warehouse solution. Whether you're performing high-speed queries on local Parquet files or tapping into your cloud data warehouse, the DuckDB UI provides a smooth, powerful, and unified experience. This guide will help you master this essential developer tool to accelerate your data workflows. For feature requests or to contribute, head over to the GitHub repository. Watch with full transcript & resources: https://motherduck.com/videos/how-to-...