MySQL CRUD

Safely inspect, query, and change MySQL data through saved local profiles. The skill uses a Bash script and the mysql CLI; it does not depend on Python, pymysql, or jq.

Purpose

Use this skill for:

• saving reusable MySQL connection profiles
• direct MySQL CLI connections
• SSH tunnel connections to private MySQL hosts
• SSH remote execution where the database URL exists on a server, such as a remote .env file
• schema inspection
• select, insert, update, delete, and raw SQL

Output:

• JSON printed to stdout
• the same JSON saved to ./out/mysql-crud-<UTC timestamp>-<pid>.json by default