# Mysql

> Manage MySQL databases via the mysql CLI. Use when querying, inspecting schema, or managing MySQL databases.

- Skill: `fworks-tech/mysql` (Agent Skill)
- Install (CLI): `npx skillmds@latest add fworks-tech/mysql`
- Raw SKILL.md: https://api.skillmd.com/api/skills/fworks-tech/mysql/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- License: MIT
- Author: fworks-tech (https://skillmd.com/u/fworks-tech)
- Updated: 2026-09-21
- Page: https://skillmd.com/skills/fworks-tech/mysql

---


# mysql

Use `mysql` to interact with MySQL databases.

## Common Commands

### Connection
- Connect: `mysql -h <host> -u <user> -p<password> <database>`
- Execute query: `mysql -e "SELECT * FROM table LIMIT 10" <database>`

### Inspection
- List databases: `SHOW DATABASES;`
- List tables: `SHOW TABLES;`
- Describe table: `DESCRIBE <table_name>;`

### Operations
- Execute from file: `mysql <database> < migration.sql`
- Export: `mysqldump -u <user> -p <database> > backup.sql`
- Import: `mysql <database> < backup.sql`

## Notes
- Avoid passing password as command-line argument in shared environments
- Use `~/.my.cnf` for stored credentials