Database Toolbox
Database Toolbox offers functions and an app for connecting to and working with relational and NoSQL databases. It supports any ODBC- or JDBC-compliant relational database and provides NoSQL compatibility with Apache Cassandra®, MongoDB®, and Neo4j®.
Built-in interfaces for MySQL®, PostgreSQL®, and SQLite simplify database interactions. These interfaces include third-party drivers that enable connections in deployed and cloud environments without requiring additional setup.
The toolbox provides straightforward read and write workflows for beginners, while giving advanced users full control for SQL-based operations. Using the Database Explorer app, you can interactively browse relational data and generate MATLAB code to automate or operationalize database tasks. For handling large datasets, query filters can be applied directly within SQL commands. Additionally, the toolbox includes an Object Relational Mapper (ORM), allowing MATLAB objects to seamlessly interact with database tables.
Database Explorer App
Use the Database Explorer app to visualize data from your relational database without requiring SQL knowledge. Generate MATLAB code or SQL scripts to operationalize your database workflows.
ODBC and JDBC Database Support
Connect to your ODBC- or JDBC-compliant relational database on premises or in the cloud. Interact with your tables programmatically or by executing SQL queries.
Native Interfaces for MySQL, PostgreSQL, and SQLite
Connect to your MySQL, PostgreSQL, or SQLite database without additional driver setup. Interact with your database via database-specific functions that provide greater performance than an ODBC or JDBC interface in MATLAB.
Interact with Databases Without Writing SQL
Import, export, and perform inner and outer joins on your relational database tables without writing SQL queries. Customize your import options to reduce post-processing steps.
Selective Import for Database Table Rows
Add custom filters to your import methods and apply them directly to your database queries to reduce the size of data imported and improve query performance.
NoSQL Support for MongoDB, Cassandra, and Neo4j
Connect to your MongoDB, Cassandra, and Neo4j NoSQL database without additional driver setup. Interact with your data programmatically or with a database-specific query language.
Object Relational Mapping (ORM)
Map your database tables directly to MATLAB classes to implement consistent, reusable database workflows without writing SQL queries.