MySQL API Integrations
Build and run workflows using the MySQL API. Use 1000s of source-available triggers and actions across 2,000+ apps. Or write custom code to integrate any app or API in seconds.
Overview#
The MySQL application on Pipedream enables direct interaction with your MySQL databases, allowing you to perform CRUD operations—create, read, update, delete—on your data with ease. You can leverage these capabilities to automate data synchronization, report generation, and event-based triggers that kick off workflows in other apps. With Pipedream's serverless platform, you can connect MySQL to hundreds of other services without managing infrastructure, crafting complex code, or handling authentication.
import mysql from '@pipedream/mysql';
export default defineComponent({
props: {
mysql,
},
async run({steps, $}) {
// Component source code:
// https://github.com/PipedreamHQ/pipedream/tree/master/components/mysql
const queryObj = {
sql: "SELECT NOW()",
values: [], // Ignored since query does not contain placeholders
};
const { rows } = await this.mysql.executeQuery(queryObj);
return rows;
},
});Choose an API to Connect with MySQL API#
1-24of2,000+apps by most popular
Example Use Cases#
Automated Data Backup Workflow: Automatically back up specific tables or datasets from MySQL to cloud storage services like Google Drive or Amazon S3 at regular intervals. This flow can be set up to trigger on a schedule, ensuring your data is consistently backed up without manual intervention.
Real-time Customer Data Sync: Sync new customer information from a CRM platform like Salesforce or HubSpot to your MySQL database in real time. Whenever a new contact is added to the CRM, the workflow triggers and inserts or updates the corresponding record in MySQL, keeping your customer data aligned across systems.
Email Alerts on Database Changes: Monitor specific tables in your MySQL database for changes, such as new entries or updates to existing records. Use this trigger to send email notifications through SendGrid or another email service whenever there's a significant database modification, keeping relevant stakeholders informed.
Popular MySQL Triggers#
Emit new event when you add or modify a new row in a table. See the docs here
Emit new event when new rows are returned from a custom query. See the docs here
Emit new event when a new table is added to a database. See the docs here
Authentication#
MySQL uses API keys for authentication. When you connect your MySQL account, Pipedream securely stores the keys so you can easily authenticate to MySQL APIs in both code and no-code steps.
Before you connect to your MySQL database from Pipedream, please make sure your database is either:
- Accessible from the public internet (You may need to add a firewall rule on
0.0.0.0/0on port 3306), or - Accessible from a static IP that you've configured using a VPC in Pipedream, and enabled the workflow to connect through that VPC
SSL Setup
Configure SSL on your MySQL database by providing the CA (Certificate Authority), and choosing between Full Verification, Verify Certificate Authority (CA), or Skip Verification. Skipping verification is not recommended as this has serious security implications.