matlab-read-database

What problem does it solve?

This skill prevents slow, memory-heavy MATLAB imports by ensuring row filtering, column selection, deduplication, and supported 2-table joins are executed on the relational database using MATLAB Database Toolbox pushdown capabilities.

Core Features & Use Cases

• Efficient imports with pushdown: Use sqlread for database tables and fetch for SQL queries so filtering and selected columns happen on the database side.
• Correct, scalable filtering and deduplication: Use RowFilter and databaseImportOptions (including SelectedVariableNames and ExcludeDuplicates) to avoid importing everything and filtering in MATLAB.
• Safe join strategy: Use sqlinnerjoin/sqlouterjoin for exactly two tables (with RowFilter), and fall back to explicit SQL via fetch for 3+ tables, aggregation, and complex queries.

Quick Start

Use matlab-read-database to import only needed columns and rows from a relational database table by applying RowFilter and SelectedVariableNames with sqlread, then use sqlinnerjoin/sqlouterjoin for a two-table join or fetch with explicit SQL for more complex multi-table/aggregation queries.