Integrate the SSH (key-based auth) API with the Supabase API

Setup the SSH (key-based auth) API trigger to run a workflow which integrates with the Supabase API. Pipedream's integration platform allows you to integrate SSH (key-based auth) and Supabase remarkably fast. Free for developers.

Popular Ways to Connect SSH (key-based auth) with Supabase#

Execute a Command with SSH (key-based auth) API on New Row Added from Supabase API

Supabase + SSH (key-based auth)

Try it

Execute a Command with SSH (key-based auth) API on New Webhook Event (Instant) from Supabase API

Supabase + SSH (key-based auth)

Try it

Popular SSH (key-based auth) and Supabase Triggers#

New Row Added from the Supabase API

Emit new event for every new row added in a table. See documentation here

Try it

New Webhook Event (Instant) from the Supabase API

Emit new event for every insert, update, or delete operation in a table. This source requires user configuration using the Supabase website. More information in the README. Also see documentation here

Try it

Popular SSH (key-based auth) and Supabase Actions#

Execute a Command with the SSH (key-based auth) API

Executes a command on a remote device. See SSH lib docs here

Try it

Delete Row with the Supabase API

Deletes row(s) in a database. See the docs here

Try it

Insert Row with the Supabase API

Inserts a new row into a database. See the docs here

Try it

Remote Procedure Call with the Supabase API

Call a Postgres function in a database. See the docs here

Try it

Select Row with the Supabase API

Selects row(s) in a database. See the docs here

Try it

Overview of SSH (key-based auth)#

The SSH (Secure Shell) key-based authentication API allows you to execute commands on a remote server securely. With Pipedream, leverage this capability to automate server management tasks, execute deployment scripts, or gather data from your server infrastructure. By integrating with other apps on Pipedream, you can create seamless workflows that trigger actions on your servers in response to various events.

Connect SSH (key-based auth)#

module.exports = defineComponent({
  props: {
    ssh: {
      type: "app",
      app: "ssh",
    }
  },
  async run({steps, $}) {
    const SSH2Promise = require('ssh2-promise')
    
    const { 
      host, 
      port,
      username, 
      privateKey,
    } = this.ssh.$auth
    
    const ssh = new SSH2Promise({
      host,
      port,
      username,
      privateKey,
    })
    
    await ssh.connect()
    console.log("Connection established")
    
    // Replace this with the command you'd like to run
    const resp = await ssh.exec("whoami")
    console.log(resp)
    
    await ssh.close()
  },
})

Overview of Supabase#

Supabase is a real-time backend-as-a-service that provides developers with a suite of tools to quickly build and scale their applications. It offers database storage, authentication, instant APIs, and real-time subscriptions. With the Supabase API, you can perform CRUD operations on your database, manage users, and listen to database changes in real time. When integrated with Pipedream, you can automate workflows that react to these database events, synchronize data across multiple services, or streamline user management processes.

Connect Supabase#

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    supabase: {
      type: "app",
      app: "supabase",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://${this.supabase.$auth.subdomain}.supabase.co/rest/v1/`,
      headers: {
        Authorization: `Bearer ${this.supabase.$auth.service_key}`,
        "apikey": `${this.supabase.$auth.service_key}`,
      },
    })
  },
})