Integration
Automate with MySQL
MySQL stores your application data. NVS connects MySQL row events to your CRM, reporting tools, and monitoring systems so your data flows automatically to where it needs to go.
Use Cases
When a new row is inserted into the orders table in MySQL, the order data is extracted and a fulfillment webhook is sent to the warehouse management system.
Trigger
New Order Row
mysql.trigger
Fires when a new row is inserted into the orders table.
Extract Order Fields
nvs.set
Order ID, customer ID, product SKUs, quantities, and shipping address extracted.
Validate Order Data
nvs.condition
Required fields checked before triggering fulfillment.
Output
Send Fulfillment Webhook
http.request
Order payload sent to the warehouse API. Fulfillment ID stored back to the row.
Every Monday morning, a MySQL query runs against the sales database, and the results are automatically written to a Google Sheets reporting dashboard.
Trigger
Monday 7am
schedule.cron
Weekly reporting query runs before the business week begins.
Run Sales Query
mysql.query
Weekly revenue, order count, and top products queried from the sales tables.
Format Report Data
nvs.set
Query results formatted into rows with column headers matching the Sheets template.
Output
Write to Google Sheets
google.sheets
Report data written to the weekly summary tab in the reporting sheet.
Every night, MySQL sessions open for more than 24 hours are identified and killed. A report of the killed sessions is sent to the #infrastructure Slack channel.
Trigger
Nightly 2am
schedule.cron
Session cleanup runs in the low-traffic overnight window.
Query Long-Running Sessions
mysql.query
Sessions with connection time > 24 hours queried from information_schema.
IF
Any Stale Sessions?
nvs.condition
Checks whether long-running sessions exist.
NO
Output
Done
nvs.end
No stale sessions. Database is healthy.
YES
Kill Stale Sessions
mysql.query
KILL command executed for each stale session ID.
Output
Report to #infrastructure
slack.message
Slack report: count of killed sessions with user names and connection durations.