Mysql

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-selection. Blocks all write operations (INSERT, UPDATE, DELETE, DROP, etc.) for safety.

448 stars 49 forksDatabases

Install

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add sanjay3290/ai-skills --skill mysql
Manual install
git clone --depth 1 https://github.com/sanjay3290/ai-skills.git /tmp/ai-skills
mkdir -p ~/.claude/skills
cp -r /tmp/ai-skills/skills/mysql ~/.claude/skills/mysql

Personal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.

From the SKILL.md

# 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
Read the full skill on GitHub

Details

Skill name
mysql
Repository
sanjay3290/ai-skills
Path
skills/mysql/SKILL.md
License
Apache-2.0
Repo updated
10 September 2026
Listed in
BehiSecc/awesome-claude-skills, ComposioHQ/awesome-claude-skills, heilcheng/awesome-agent-skills, VoltAgent/awesome-agent-skills

FAQ

What does the Mysql skill do?

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-selection. Blocks all write operations (INSERT, UPDATE, DELETE, DROP, etc.) for safety.

How do I install the Mysql skill?

skills CLI (Claude Code, Cursor, Codex and more): npx skills add sanjay3290/ai-skills --skill mysql. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is Mysql popular?

It lives in sanjay3290/ai-skills, which has 448 GitHub stars and 49 forks, and is included in 4 curated skill lists.

Related skills

Notebooklm

448

sanjay3290/ai-skills

Query and manage Google NotebookLM notebooks with persistent profile auth, source sync, batch/multi queries, and structured exports. Use when user asks to query NotebookLM, 'ask my notebook', shares NotebookLM notebook URLs, wants to list/create notebooks, manage sources, do bulk folder sync, dedupe, or audit exports.

Data & AnalyticsIn 4 lists49

Azure Devops

448

sanjay3290/ai-skills

Manage Azure DevOps projects, work items, repos, PRs, pipelines, wikis, test plans, security alerts, variable groups, environments/approvals, branch policies, and attachments. Use when user asks to: manage sprints, create/update work items, list repos, create PRs, run pipelines, search code, manage wiki pages, check security alerts, manage variable groups, approve deployments, or configure branch policies. Covers 13 domains with 99 tools via REST API.

DevOps & CloudIn 4 lists49

Deep Research

448

sanjay3290/ai-skills

Execute autonomous multi-step research using Google Gemini Deep Research Agent. Use for: market analysis, competitive landscaping, literature reviews, technical research, due diligence. Takes 2-10 minutes but produces detailed, cited reports. Costs $2-5 per task.

Research & ScienceIn 4 lists49

PostgreSQL Queries

448

sanjay3290/ai-skills

Execute safe read-only SQL queries against PostgreSQL databases. Analyze and explore your database with Claude.

DatabasesIn 4 lists49

Mssql

448

sanjay3290/ai-skills

Execute read-only SQL queries against multiple Microsoft SQL Server databases. Use when: (1) querying MSSQL/SQL Server 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-selection. Blocks all write operations (INSERT, UPDATE, DELETE, DROP, etc.) for safety.

DatabasesIn 4 lists49

Clickhouse Best Practices

562

ClickHouse/agent-skills

MUST USE when reviewing ClickHouse schemas, queries, or configurations. Contains 31 rules that MUST be checked before providing recommendations. Always read relevant rule files and cite specific rules in responses.

DatabasesIn 1 list38

Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.