matlab-use-duckdb

What problem does it solve?

This Skill helps you avoid slow and memory-heavy MATLAB data pipelines by generating correct DuckDB-backed MATLAB code that performs filtering, aggregation, and file-to-table analytics directly in SQL.

Core Features & Use Cases

• DuckDB connection guidance: Uses duckdb() (optionally file-backed) with proper isopen(conn) verification and safe closing via close(conn).
• File analytics pushdown: Uses fetch with SQL read_csv/read_parquet/read_xlsx patterns to prevent the load-then-query anti-pattern.
• In-database workflows: Supports creating portable development databases via duckdb("file.duckdb"), importing with sqlwrite, and querying with sqlread or complex SQL via fetch.
• Extensions support: Installs and loads extensions (e.g., excel) when the query requires them.
• Guardrails and correctness: Warns against unsupported patterns such as databasePreparedStatement for DuckDB and encourages reserved-keyword-safe column handling (e.g., using renamevars).

Quick Start

Ask the agent to generate a DuckDB-powered MATLAB solution that queries your large CSV or Parquet file directly with SQL filtering and aggregation using fetch and read_csv or read_parquet.