DuckDB-NSQL

DuckDB-NSQL is a specialized text-to-SQL model optimized for DuckDB syntax and analytical query patterns, developed in collaboration with MotherDuck. The model understands DuckDB-specific functions, OLAP query patterns, and Parquet/CSV file handling that distinguish DuckDB from traditional databases. Particularly effective for data analysts working with local files, data lakes, or MotherDuck’s cloud DuckDB service. The model handles common analytical patterns including time-series aggregations, window functions, and complex joins across multiple file sources. Available through Hugging Face with integration examples for Jupyter notebooks and Python scripts. Page should cover: DuckDB-specific capabilities, MotherDuck integration, analytical query patterns, file source handling, comparison with general-purpose SQL models, and use cases for data analysis workflows.