🚀 MySQL adaptor v4.0.0 is now available

Adaptors & Templates
1

We’re excited to announce the release of MySQL adaptor v4.0.0, bringing improvements to database operations and SQL Injection protection for OpenFn workflows.

What’s new

This major version update focuses on security and reliability when working with MySQL databases:

Key improvements:

  • Enhanced SQL injection protection - Improved safeguards against SQL injection vulnerabilities in all database operations
  • Streamlined operation functions - All database operations (sql, insert, insertMany, etc.) now follow consistent, secure patterns

Why this matters

Security is critical when working with databases. This update ensures your workflows handle data safely, especially when:

  • Processing user-generated content or external data
  • Running bulk data synchronization workflows
  • Building multi-step data transformations
  • Managing high-frequency automated processes

Getting started

Update your adaptor: Change your workflow’s adaptor reference to @openfn/language-mysql@4.0.0

Review the documentation: Check out the full MySQL adaptor docs for updated examples and best practices.

See the complete changelog: mysql changelog | OpenFn/docs

2

The SQL injection protection alone makes this MySQL release worth upgrading to. Consistent operation patterns across the adaptor should also make OpenFn workflows easier to maintain and review, especially in larger data integration pipelines.

For teams working with integration platforms like MuleSoft, standardized and secure patterns are especially valuable when managing complex workflows across multiple systems.

Nice to see security getting prioritized at the framework level instead of leaving it entirely to workflow authors. The emphasis on SQL injection prevention aligns well with established secure coding practices outlined by OWASP SQL Injection Prevention Cheat Sheet.