How do I install the DB Query skill?

Run npx skillmds@latest add sizzlecar/db-query in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is DB Query safe to use?

This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with DB Query?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is DB Query free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published DB Query?

sizzlecar (@sizzlecar) published this skill. Their other Agent Skills are listed on their SkillMD profile.

DB Query by sizzlecar — Agent Skill

Name: DB Query
Author: sizzlecar

File contents

Database Query Skill

Environment Variables

Variable	Required	Default	Description
`DB_HOST`	Yes	—	MySQL server hostname or IP
`DB_USER`	Yes	—	Database username
`DB_PASS`	Yes	—	Database password
`DB_NAME`	No	—	Default database name
`DB_PORT`	No	3306	MySQL server port

Important

All required environment variables (DB_HOST, DB_USER, DB_PASS, etc.) are pre-configured. Do NOT ask the user for database credentials — just run the query directly.

Workflow

Verify connectivity before running queries:

mysql -h "$DB_HOST" -P "${DB_PORT:-3306}" -u "$DB_USER" -p"$DB_PASS" -e "SELECT 1" 2>&1

Run queries using the mysql CLI with these flags for clean output:

mysql -h "$DB_HOST" -P "${DB_PORT:-3306}" -u "$DB_USER" -p"$DB_PASS" "$DB_NAME" -e "YOUR SQL" --batch --skip-column-names

For tabular output (human-readable), omit --skip-column-names:

mysql -h "$DB_HOST" -P "${DB_PORT:-3306}" -u "$DB_USER" -p"$DB_PASS" "$DB_NAME" -e "YOUR SQL" --table

Export to CSV:

mysql -h "$DB_HOST" -P "${DB_PORT:-3306}" -u "$DB_USER" -p"$DB_PASS" "$DB_NAME" -e "YOUR SQL" --batch | tr '\t' ',' > output.csv

Safety Rules

NEVER run DROP, TRUNCATE, DELETE, or UPDATE without explicit user confirmation
NEVER modify database schema (ALTER TABLE, CREATE TABLE, DROP TABLE) without approval
Always use LIMIT for exploratory queries to avoid fetching millions of rows
Use --batch mode for programmatic output, --table for human display
Mask passwords in any output shown to the user — never echo $DB_PASS

Query Patterns

Explore schema: SHOW TABLES, DESCRIBE table_name, SHOW CREATE TABLE table_name
Row counts: SELECT COUNT(*) FROM table_name
Sample data: SELECT * FROM table_name LIMIT 10
Aggregations: Use GROUP BY with COUNT, SUM, AVG for summaries
Date filtering: WHERE created_at >= DATE_SUB(NOW(), INTERVAL 7 DAY)

---name: db-querydescription: Query MySQL databases, summarize results, and export to CSV/Excel. Use when the user asks to check data, run SQL queries, export tables, or generate data reports from a database.---# Database Query Skill## Environment Variables| Variable | Required | Default | Description ||----------|----------|---------|-------------|| `DB_HOST` | Yes | — | MySQL server hostname or IP || `DB_USER` | Yes | — | Database username || `DB_PASS` | Yes | — | Database password || `DB_NAME` | No | — | Default database name || `DB_PORT` | No | 3306 | MySQL server port |## ImportantAll required environment variables (DB_HOST, DB_USER, DB_PASS, etc.) are pre-configured. Do NOT ask the user for database credentials — just run the query directly.## Workflow1. **Verify connectivity** before running queries: ``` mysql -h "$DB_HOST" -P "${DB_PORT:-3306}" -u "$DB_USER" -p"$DB_PASS" -e "SELECT 1" 2>&1 ```2. **Run queries** using the mysql CLI with these flags for clean output: ``` mysql -h "$DB_HOST" -P "${DB_PORT:-3306}" -u "$DB_USER" -p"$DB_PASS" "$DB_NAME" -e "YOUR SQL" --batch --skip-column-names ```3. **For tabular output** (human-readable), omit `--skip-column-names`: ``` mysql -h "$DB_HOST" -P "${DB_PORT:-3306}" -u "$DB_USER" -p"$DB_PASS" "$DB_NAME" -e "YOUR SQL" --table ```4. **Export to CSV**: ``` mysql -h "$DB_HOST" -P "${DB_PORT:-3306}" -u "$DB_USER" -p"$DB_PASS" "$DB_NAME" -e "YOUR SQL" --batch | tr '\t' ',' > output.csv ```## Safety Rules- NEVER run `DROP`, `TRUNCATE`, `DELETE`, or `UPDATE` without explicit user confirmation- NEVER modify database schema (`ALTER TABLE`, `CREATE TABLE`, `DROP TABLE`) without approval- Always use `LIMIT` for exploratory queries to avoid fetching millions of rows- Use `--batch` mode for programmatic output, `--table` for human display- Mask passwords in any output shown to the user — never echo `$DB_PASS`## Query Patterns- **Explore schema**: `SHOW TABLES`, `DESCRIBE table_name`, `SHOW CREATE TABLE table_name`- **Row counts**: `SELECT COUNT(*) FROM table_name`- **Sample data**: `SELECT * FROM table_name LIMIT 10`- **Aggregations**: Use `GROUP BY` with `COUNT`, `SUM`, `AVG` for summaries- **Date filtering**: `WHERE created_at >= DATE_SUB(NOW(), INTERVAL 7 DAY)`

Frequently asked questions

DB Query