Database Toolbox

与关系型数据库和 NoSQL 数据库交互

Database Toolbox 提供了多个函数和一个 App，可用来与关系型数据库和 NoSQL 数据库进行交互。这款工具箱支持兼容 ODBC 或 JDBC 的所有关系型数据库，并为 Apache Cassandra^®、MongoDB^® 和 Neo4j^® 提供 NoSQL 支持。

该工具箱提供了适用于 MySQL^®、PostgreSQL^® 和 SQLite 的原生接口，可以简化与数据库的交互。这些接口附带第三方驱动程序。这些驱动程序无需额外设置或安装，即可连接到已部署的环境和云环境中的数据库。

使用数据库资源管理器，您可以交互方式探查关系型数据并生成 MATLAB 代码，以实现数据库工作流自动化或可操作化。对于大型数据工作流，您可以直接对 SQL 查询运行查询筛选器。

将 AI 智能体连接至 Database Toolbox

将特定领域的专业能力引入您的智能体 AI 工作流。

了解更多

MATLAB Interface for DuckDB shown reducing multiple files into a single file, and as a database to query with MATLAB.

Use DuckDB to Query Files and DuckDB Databases

Use DuckDB to query data from files and databases directly. Store data in DuckDB databases and use SQL to prepare large datasets for analysis in MATLAB.

Documentation | Examples

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.

Data integrations

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