MySQL API Integrations
Build and run workflows using the MySQL API. Use 1000s of source-available triggers and actions across 1000+ apps. Or write custom code to integrate any app or API in seconds.
Overview#
MySQL is a powerful database management system used by some of the largest organizations in the world, including Facebook, Google, and Amazon. MySQL is an open-source relational database management system (RDBMS), as well as a popular choice for web applications used by millions of websites.
Some applications that can be built using the MySQL API include:
- A web application that stores and retrieves data from a MySQL database
- A desktop application that uses a MySQL database for data storage
- A mobile application that interacts with a MySQL database
module.exports = defineComponent({
props: {
mysql: {
type: "app",
app: "mysql",
}
},
async run({steps, $}) {
const mysql = require('mysql2/promise');
const { host, port, username, password, database } = this.mysql.$auth
const connection = await mysql.createConnection({
host,
port,
user: username,
password,
database,
});
const [rows, fields] = await connection.execute('SELECT NOW()');
console.log(rows)
},
})
Choose an API to Connect with MySQL API#
1-12of1000+apps by most popular
Popular MySQL Integrations#
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), orAccessible from an SSH server that you route MySQL requests through
After that, enter the following values:
- host: The hostname or IP address of your MySQL server
- port:
3306, unless you run MySQL on a different port - username: The account username to log in
- password: The account password to log in
- database: The name of the MySQL database to run queries against