The Database node contains a selection of tools for working with and manipulating the solution database – available to Administrator users only.
Please backup your database before using any of these tools.
If you don’t have access to your database or don’t know how to back it up, don’t use the tools.
Search & Replace
The Search & Replace tool lets you select a database, a table and a field – then search for and replace values therein (Figure 2.1).
Use Find to find all records matching a value, then Replace all to replace all values found with the content in the Replace with field.
The SQL Firehose tool is a tool for executing SQL statements against your database (Figure 3.1). SQL Firehose is a full SQL client, and supports all SQL operations.
SQL Firehose is only available for Administrators (not Admins) and angel users.
Using the Setup node you can change database connection configuration or add an alternative database connection to the solution (Figure 4.1).