Execute read-only SQL queries against multiple MySQL databases. Use when: (1) querying MySQL databases, (2) exploring database schemas/tables, (3) running SELECT queries for data analysis, (4) checking database contents. Supports multiple database connections with descriptions for intelligent auto-s

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: 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 Query a database List tables Show schema Limit results Database Selection Match user intent to database description : User asks about Look for description containing users, accounts users, accounts, customers orders, sales orders, transactions, sales analytics, metrics analytics, metrics, reports logs, events logs, events, audit If unclear, run list and ask user which database. Safety Features Read only session : Connection uses MySQL SET SESSION TRANSACTION READ ONLY (primary protection) Query validation : Only SELECT, SHOW, DESCRIBE, EXPLAIN, WITH queries allowed Single statement : Multiple statements per query rejected SSL support : Configurable SSL with CA, client cert, and key support Query timeout : 30 second max execution time enforced (MySQL 5.7.8+) Memory protection : Max 10,000 rows per query to prevent OOM Column width cap : 100 char max per column for readable output Credential sanitization : Error messages don't leak passwords Troubleshooting Error Solution Config not found Create connections.json in skill directory Authentication failed Check username/password in config Connection timeout Verify host/port, check firewall/VPN SSL error Try "ssl disabled": true for local databases Permission warning Run chmod 600 connections.json max execution time not supported Upgrade to MySQL 5.7.8+ or MariaDB 10.1.1+ Exit Codes 0 : Success 1 : Error (config missing, auth failed, invalid query, database error) Workflow 1. Run list to show available databases 2. Match user intent to database description 3. Run tables or schema to explore structure 4. Execute query with appropriate LIMIT