Mysql

This is a read-only MySQL query tool that connects to multiple databases through a JSON config file. You can run SELECT queries, explore schemas, and list tables without worrying about accidentally modifying data. It enforces read-only mode at the MySQL session level and blocks anything that isn't a SELECT or SHOW command. The multi-database setup with descriptions is clever since Claude can auto-select the right connection based on what you're asking about. Watch out for the credentials sitting in a local JSON file, though the docs do tell you to chmod 600 it. Good for ad-hoc queries and exploration when you want guardrails against destructive operations.

skills.sh installs: 430
GitHub stars: 454
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add sanjay3290/ai-skills --skill mysql --agent claude-code

Installs into .claude/skills of the current project.

Files

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:

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
    }
  ]
}