mysql

# MySQL Read-Only Query Skill Execute safe, read-only queries against configured MySQL databases. ## Requirements - Python 3.8+ - mysql-connector-python: `pip install -r requirements.txt` ## Setup Create `connections.json` in the skill directory or `~/.config/claude/mysql-connections.json`. **Security**: Set file permissions to `600` since it contains credentials: ```bash chmod 600 connections.json ``` ```json { "databases": [ { "name": "production", "description": "Main app database - users, orders, transactions", "host": "db.example.com", "port": 3306, "database": "app_prod", "user": "readonly_user", "password": "your-password", "ssl_disabled": false } ] } ``` ### Config Fields | Field | Required | Description | |-------|----------|-------------| | name | Yes | Identifier for the database (case-insensitive) | | description | Yes | What data this database contains (used for auto-selection) | | host | Yes | Database hostname | | port | No | Port number (default: 3306) | | database | Yes | Database name | | user | Yes | Username | | password | Yes | Password | | ssl_disabled | No | Set to `true` to disable SSL (default: false) | | ssl_ca | No | Path to CA certificate file | | ssl_cert | No | Path to client certificate file | | ssl_key | No | Path to client private key file | ## Usage ### List configured databases ```bash python3 scripts/query.py --list ``` ### Query a database ```bash python3 scripts/query...