MySQL
Connect directly to your MySQL or MariaDB databases to read, insert, update, or delete records. Use prepared statements to prevent SQL injection and seamlessly map your database rows to downstream workflow actions.
What can you do with MySQL?
Secure Prepared Statements
Safely bind dynamic workflow variables to your SQL queries using '?' placeholders, completely negating the risk of malicious SQL Injection attacks.
Automatic Data Mapping
Automatically transforms the raw relational database response rows into standard nLink JSON array objects, making it incredibly easy to loop through the results.
Secure Credential Vault
Connect securely using nLink's encrypted credential system. Your raw database passwords are encrypted at rest and never exposed inside the workflow configuration.
Detailed Usage & Configuration
The MySQL node transforms nLink into a powerful Database-as-a-Service pipeline tool, allowing you to directly query and manipulate your central databases without the need to build intermediate custom APIs.
1. Executing Safe Queries
Never concatenate dynamic variables directly into your SQL string! Instead, always use the ? symbol as a placeholder.
SELECT * FROM users WHERE status = ? AND created_at > ?After writing your query, configure the Query Parameters list in the Node UI and pass in your dynamic workflow variables sequentially. nLink will securely bind these parameters under the hood using native Go database drivers.
2. Handling Results
If you execute a SELECT query returning 100 rows, the node will output 100 individual JSON items natively in nLink. You can immediately attach an Iterator node or an HTTP Request node to process each row individually.
If you execute an UPDATE or DELETE, the node will return an object containing the affectedRows count.