MySQL

Open-source relational database

Go to site

Integrate the MySQL API with the Pipedream API

Setup the MySQL API trigger to run a workflow which integrates with the Pipedream API. Pipedream's integration platform allows you to integrate MySQL and Pipedream remarkably fast. Free for developers.

Query SQL

Run a query against data saved to Pipedream's SQL service. To get started, connect your account using your API key (found in your account settings).

 
Try it
Get CSV for a SQL query execution

Retrieve a CSV for the results of a specific SQL query execution.

 
Try it

Connect MySQL

const mysql = require('mysql2/promise');

const { host, port, username, password, database } = auths.mysql

const connection = await mysql.createConnection({
  host,
  port,
  user: username,
  password,
  database,
});

const [rows, fields] = await connection.execute('SELECT NOW()');
console.log(rows)

Connect Pipedream

return await require("@pipedreamhq/platform").axios(this, {
  url: `https://api.pipedream.com/v1/users/me`,
  headers: {
    Authorization: `Bearer ${auths.pipedream.api_key}`,
  },
})