Database

This extension enables direct interaction with relational databases. It allows you to execute queries to retrieve or write data.

Relational databases store structured data in tables composed of rows and columns. They are commonly used for transactional systems, reporting, analytics, and backend data storage. Communication with these databases typically occurs through SQL (Structured Query Language) and a database driver.

This extension uses a JDBC (Java Database Connectivity) connection, which provides a standardized way to connect to and interact with relational database systems. Any JDBC connector included in the class path should be available, but explicit support is so far provided for PostgreSQL, MySQL and Oracle Database.

Creating a plugin for this extension enables an MLM to:

• Execute SELECT queries to retrieve data
• Perform INSERT, UPDATE, and DELETE operations
• Integrate external database data into logic execution
• Persist computed results or system outputs

Configuration

The following parameters are required to establish a database connection:

• Username
• Password
• JDBC connection URL: The full JDBC connection string (e.g., jdbc:postgresql://localhost:5432/mydatabase) that defines:
  • Database type (e.g., PostgreSQL, MySQL, etc.)
  • Hostname or IP address
  • Port number
  • Database name
  • Optional connection parameters

TIP

Ensure that the database user has the appropriate permissions for the intended operations (read-only vs. read/write).

Example configuration

Usage

data:
    LET rows BE READ { FROM my-database-plugin WITH STATEMENT "SELECT * FROM ..." }

Retrieved rows are returned as a list of objects, where its fields and their values correspond to the columns.