MySQL

Databases & warehousesUsername & passwordConnection test available

MySQL database — SELECT 1 connectivity test.

OCNORA ships 1 typed MySQL operation. Each node has a schema-driven form, input and output tables beside its settings, and is pre-flighted by Workflow Health before your first real run.

Before you connect MySQL

Authentication
Username & password
Credential
the password, or {"password": "…"}
Connection test
Available: the stored credential can be checked against the provider when you add it. This is not a record that a test was run or passed.

What you can do with MySQL

Operations, grouped by what they do to your data.

Create and send 1

Nodes that use your MySQL connection

Beyond its own nodes, these generic nodes accept your MySQL credential. Each chooses the provider from the connection you select, so the same node also works with the other providers shown.

  • SQL Query
    db.query
    Run a parameterised SELECT/INSERT/UPDATE/DELETE against a Postgres or MySQL connection.
    Also works withPostgreSQL
  • SQL Upsert
    db.upsert
    INSERT … ON DUPLICATE KEY UPDATE one row (MySQL/MariaDB).

A sample MySQL workflow

  1. 1
    A core trigger
    Start the run from a chat, form, manual, schedule, webhook, workflow trigger — no MySQL trigger is needed.
  2. 2
    Run Querymysql.query
    Run a parameterised SQL query against a MySQL database.

An outline built from this provider’s node contracts, not a recorded run. Each step’s output fields are available to the next in the field picker.

Every node below has a reference page: what it does, the connection it needs, its config fields with types, constraints and examples, and the shapes it emits.

MySQL questions

How does OCNORA authenticate with MySQL?
With a stored Username & password credential, shaped the password, or {"password": "…"}. A connection test can check it when you add it.
What can I automate with MySQL?
1 typed operation, each with a reference page listing its config fields and the shapes it emits. The credential also drives 2 generic nodes.
What if the MySQL operation I need is not listed?
Where MySQL has an HTTP API, call it from the HTTP node with the same credential, or describe the step to the AI builder, which asks our team for a typed node when one is missing.
Are there templates that use MySQL?
Yes: 2 templates, listed above.
How are MySQL calls controlled?
Every call and every run step is audited, runs count against the execution budget, and Workflow Health pre-flights the workflow when you save it.

See your first MySQL workflow run.

Book a technical demo. We add the connection, pick a template or describe the workflow to Build with AI, and Workflow Health checks it before it runs.