FAQ: How to save data from a webhook to MySQL via an SSH server

To save data from a webhook to a MySQL database through an SSH tunnel, take a look at these docs and this workflow.

The workflow is triggered on HTTP requests. When you copy the workflow, Pipedream will generate your own unique HTTP endpoint URL that you can put into any webhook provider.

The step that runs a MySQL query through an SSH tunnel currently just runs SELECT NOW() on the connected database. But you can run any Node.js code in that step, so I’d recommend checking out the docs for the node-mysql2 package to see how to run other queries like INSERTs. You can reference the data from the incoming HTTP request in your query.