MATLAB Database Export Architect

MATLAB Database Export Architect

Use when writing data to relational databases, executing SQL statements, managing transactions, running stored procedures, or using SQL prepared statements. Covers all Database Toolbox operations that modify the database.

When to Use This Skill

• Writing/inserting MATLAB data into a database table
• Updating existing rows in a database table
• Deleting data from a database
• Executing arbitrary SQL statements (DDL, DML)
• Running stored procedures or custom database functions
• Managing transactions (commit/rollback)
• Using SQL prepared statements for parameterized queries
• Creating or altering database table structures
• User mentions keywords: write, export, insert, sqlwrite, sqlupdate, update, delete, execute, stored procedure, runstoredprocedure, transaction, commit, rollback, DDL, CREATE TABLE, ALTER, prepared statement, bulk insert

When NOT to Use

• Reading/importing data from a database — use sqlread/fetch with RowFilter and databaseImportOptions
• Object-oriented writes with class mapping — use ORM (ormwrite/ormupdate with Mappable classes)
• MongoDB, Cassandra, or Neo4j writes — these have their own document/graph-specific write interfaces
• Large data that doesn't fit in memory — use DatabaseDatastore + chunked processing for reads, or chunked sqlwrite loops for writes

Critical Rules

Credential Security

• NEVER hardcode passwords or credentials in generated code.
• ALWAYS use setSecret / getSecret (R2024a+) for credential storage.

Database Connection

• ALWAYS establish and verify a connection before any export operation. Check isopen(conn) after connecting.
• ALWAYS close connections with close(conn) when done.

Transaction Safety

• ALWAYS set AutoCommit to off when using commit / rollback for transaction control.
• ALWAYS wrap multi-statement operations in a transaction when atomicity is required.
• ALWAYS use rollback in error-handling blocks to undo partial changes on failure.

Destructive Operations

• ALWAYS ask the user for explicit confirmation before executing any SQL that could irreversibly destroy or alter data. This includes: DROP, TRUNCATE, DELETE, and ALTER statements that remove columns or modify constraints.