# Mysql

> MySQL database — execute queries, manage transactions, and perform CRUD operations on MySQL databases. Supports SELECT, INSERT, UPDATE, DELETE, stored procedures, and batch transactions via `robomotion mysql`. Do NOT use for PostgreSQL, MSSQL, MongoDB, or other databases.

- Skill: `robomotionio/mysql` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds@latest add robomotionio/mysql`
- Raw SKILL.md: https://api.skillmd.com/api/skills/robomotionio/mysql/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- License: Apache-2.0
- Author: robomotionio (https://skillmd.com/u/robomotionio)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/robomotionio/mysql

---

# MySQL

The `robomotion mysql` CLI connects to MySQL databases for SQL operations. It executes queries and non-query statements, manages transactions with batch support, runs stored procedures, and handles full CRUD workflows.

## When to use
- Execute SQL SELECT queries against MySQL tables
- Run INSERT, UPDATE, DELETE, and DDL statements
- Execute stored procedures with parameters
- Use batch transactions for atomic operations

## Prerequisites
- `robomotion` CLI installed
- Package installed: `robomotion install mysql`
- MySQL connection credentials configured via Robomotion vault

## IMPORTANT: Session Mode Required for Multi-Step Operations
Each CLI command runs as a **separate process** — connection IDs from `connect` do NOT persist across calls.
You MUST use `--session` on `connect` and pass `--session-id` to all subsequent commands.

## Workflow
1. Install (once): `robomotion install mysql`
2. Connect with session:
   ```
   robomotion mysql connect --session --output json
   # → {"outConnectionId":"<conn-id>","session_id":"<session-id>"}
   ```
3. Use the returned `conn-id` and `session-id` in all subsequent commands:
   ```
   robomotion mysql execute_query --conn-id "<conn-id>" --session-id "<session-id>" --output json
   ```
4. Disconnect when done:
   ```
   robomotion mysql disconnect --conn-id "<conn-id>" --session-id "<session-id>" --output json
   ```

**Always** append `--output json` to get structured JSON results.

## Commands Reference
- `robomotion mysql backup_database --connection-id --backup-file-path [--opt-parameters] --session-id "<session-id>" --output json`
  Creates a backup of the MySQL database to a file
- `robomotion mysql commit_transaction --transaction-id --output json`
  Commits a database transaction to make all changes permanent
- `robomotion mysql connect [--opt-parameters] --session --output json`
  Connects to a MySQL database server using Database credentials
- `robomotion mysql disconnect --connection-id --session-id "<session-id>" --output json`
  Closes an existing MySQL database connection
- `robomotion mysql insert_table --connection-id --transaction-id --database-table --table [--opt-parameters] --session-id "<session-id>" --output json`
  Inserts table data into a MySQL database table
- `robomotion mysql execute_non_query --connection-id --transaction-id --func [--opt-parameters] --session-id "<session-id>" --output json`
  Executes a SQL command that does not return data (INSERT, UPDATE, DELETE, etc.)
- `robomotion mysql execute_query --connection-id --transaction-id --func [--opt-parameters] --session-id "<session-id>" --output json`
  Executes a SQL SELECT query and returns the results as a table
- `robomotion mysql restore_database --connection-id --backup-file-path [--opt-parameters] --session-id "<session-id>" --output json`
  Restores a MySQL database from a backup file
- `robomotion mysql start_transaction --connection-id [--opt-parameters] --session-id "<session-id>" --output json`
  Starts a new database transaction for atomic operations
- `robomotion mysql wait_column --connection-id --table [--opt-parameters] --session-id "<session-id>" --output json`
  Waits until a new column is added to a specified table
- `robomotion mysql wait_row --connection-id --table --sort-by [--opt-parameters] --session-id "<session-id>" --output json`
  Waits until a new row is inserted into a specified table
- `robomotion mysql wait_table --connection-id --table [--opt-parameters] --session-id "<session-id>" --output json`
  Waits until a new table matching the pattern is created in the database

## Environment
- ROBOMOTION_API_TOKEN (if vault credentials are needed)