Database Toolbox

MAJOR UPDATE

 

Database Toolbox 

Interact with relational and NoSQL databases

Get a free trial
View pricing

Database Toolbox™ provides functions and an app for interacting with relational and NoSQL databases. The toolbox supports any ODBC-compliant or JDBC-compliant relational database and provides NoSQL support for Apache Cassandra®, MongoDB®, and Neo4j®.

Native interfaces for MySQL®, PostgreSQL®, and SQLite provide functionality that streamlines interaction with your database. The interfaces ship with third-party drivers that connect to your database in deployed and cloud environments without additional setup or installation.

With the Database Explorer app, you can explore relational data interactively and generate MATLAB® code to automate or operationalize database workflows. For large data workflows, you can run query filters directly on your SQL queries.

What Is Database Toolbox?.
Video length is 2:14.
What Is Database Toolbox?
Access and Explore Relational Data with the Database Explorer App.
Video length is 9:00.

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.

Documentation | Examples

Interface for ODBC or JDBC driver configuration shown with MATLAB as well as on-premises and cloud-based SQL database icons.

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.

Documentation | Examples

Icons for pre-packaged drivers and MATLAB beside an icon representing MySQL, PostgreSQL, and SQLite with a bidirectional arrow between them.

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.

Documentation | Examples

Data going into a database with the sqlwrite function, and data going into MATLAB with the sqlread function.

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.

Documentation | Examples

A diagram showing a dataset with 1 TB of data being filtered into a MATLAB file with 1 KB of data via RowFilter.

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.

Documentation | Examples

A diagram showing connections from MATLAB to Neo4j, MongoDB, and Cassandra through pre-packaged drivers.

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.

Documentation | Examples

Product Resources:

Documentation Functions Technical articles User stories Requirements Release notes Videos Examples
Fulcrum Asset Management Develops Custom Quantitative Risk Management System

“MATLAB makes it easy to access financial data from internal databases and external data service providers without building extra software. With MATLAB we can process that data using risk management techniques developed by our own experts and scale the system as we add more funds.”

Athanasios Bolmatis, Fulcrum Asset Management
View more customer stories

Get a Free Trial

30 days of exploration at your fingertips.

Start now

Ready to Buy?

Get pricing information and explore related products.

View pricing Contact sales

Are You a Student?

Your school may already provide access to MATLAB, Simulink, and add-on products through a campus-wide license.

Get MATLAB