RAiN — Rivium AI Network
Back to Help

MySQL / MariaDB Search

Look things up in the business's own MySQL or MariaDB database. Read-only.

What it does

Reads the business's own MySQL or MariaDB database, read-only. The same job as Postgres Search, for the many Nigerian businesses running WordPress, WHMCS or a cPanel stack.

What you need

Connection string from MySQL / MariaDB. The database has to be reachable from the internet. A host of localhost copied out of wp-config.php will not work from here, and most shared hosts also need remote MySQL turned on for our IP.

Connecting it

Credentials belong to one project, not to your workspace and not to you. A system built for one client never runs on another client's account, and a package handed to a business runs on theirs.

  1. Open the project and stay on the Visual Editor tab.
  2. Open the Tools & Integrations rail on the right.
  3. Find this tool, open it, and paste the credential.

To change it later, open the same panel — you can leave the key blank to keep the stored one and change only the other field.

Using it in a step

An Action step runs one tool with the arguments you type, exactly as written, with no model involved — so it costs nothing per run and behaves the same every time. Add one from the canvas toolbar, choose MySQL / MariaDB Search, and fill in:

Field Required What goes in it
query no SQL, or a plain-language question. It only ever reads.
table no Optional. Narrows a plain-language question to one table.
limit no How many rows to return.

Values can carry results forward: {{previous}} is the step before, and {{row:column}} is a column from the row this run is about when the trigger fans out.

Press Try it to run the step on its own before committing to a whole sequence.

Using it with an agent

Tick MySQL / MariaDB Search on any agent that should be able to call it, and the agent decides when to. Use an agent when the judgement matters and an Action step when the certainty does.

A worked example

A hotel's booking system is MySQL behind WordPress. A morning run lists arrivals for the day and emails the front desk a printable list.

When it goes wrong

Connection refused from a shared host. Most shared hosts block remote MySQL until you add the calling IP under Remote MySQL in cPanel.

A host of localhost from wp-config.php will not work — that file is read by a server sitting next to the database, and we are not.

See also