Mass edit of a section of all flows?

Questions
#1

I have multiple HTTP request nodes that have in the node somewhere a URL. I have this URL in similar nodes across multiple workflows.

In MySQL I can use things like

UPDATE xxxxxx SET xxxxxx = REPLACE(xxxxx, 'https://xxxxx', 'https://yyyyy');

Can I do something similar across all of my n8n flows? IF so whats the best way to do this?

Im using Postgres

#2

Hi @RedPacketSec

Easiest thing would be to create a workflow to grab all workflows with the n8n node. update the JSON and update the workflows with the n8n node again.
Other thing would be to construct some kind of Postgres query doing the same in the workflows table of the n8n database.