MySQL

Open-source relational database

Go to site

Integrate the MySQL API with the Firebase Admin SDK API

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

Popular Ways to Connect MySQL with Firebase Admin SDK

1
-
6
of
7
integrations by popularity

Popular MySQL and Firebase Admin SDK Triggers

1
-
5
of
5
triggers by popularity

Popular MySQL and Firebase Admin SDK Actions

1
-
2
of
2
actions by popularity

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 Firebase Admin SDK

const admin = require('firebase-admin')

// Enter values for the following parameters below this code step,
// These get passed to the initializeApp method below.
const { projectId, clientEmail, privateKey } = auths.firebase_admin_sdk

// Before passing the privateKey to the initializeApp constructor,
// we have to replace newline characters with literal newlines
const formattedPrivateKey = privateKey.replace(/\\n/g, '\n')

// See https://firebase.google.com/docs/reference/admin/node/admin.credential.html#cert
if (!admin.apps.length) {
  admin.initializeApp({
    credential: admin.credential.cert({
      projectId,
      clientEmail,
      privateKey: formattedPrivateKey,
    })
  })
}