M
MySQL Integration
Execute safe read-only SQL queries against MySQL databases with multi-connection support, SSL encryption, and defense-in-depth security
WhatIsIt
Execute safe read-only SQL queries against MySQL databases with multi-connection support, SSL encryption, and defense-in-depth security Built for use cases involving mysql, database, sql, data-analysis, query.
HowToUse
Create connections.json in the skill directory or ~/.config/claude/mysql-connections.json.
Security: Set file permissions to 600 since it contains credentials:
chmod 600 connections.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
}
]
}
KeyFeatures
- Execute safe read-only SQL queries against MySQL databases with multi-connection support, SSL encryption, and defense-in-depth security
- Database management and query optimization
- Data analysis and visualization capabilities