Mysql
ericrisco/rsc-harness
A skill your agent uses when designing, querying, indexing or operating a MySQL or MariaDB database and engine-specific behaviour matters — schema and type choices, index design, reading EXPLAIN…
Queries MySQL or MariaDB databases declared in .env by label, read-only by default unless a connection explicitly allows writes.
Install MySQL and MariaDB Query Tool
$ npx skills add evolution-foundation/evo-nexus --skill db-mysql -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install evolution-foundation/evo-nexus db-mysql --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/evolution-foundation/evo-nexus.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.claude/skills/db-mysql .claude/skills/db-mysql && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "db-mysql" agent skill from https://github.com/evolution-foundation/evo-nexus/tree/main/.claude/skills/db-mysql into .claude/skills/db-mysql/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "db-mysql", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/evolution-foundation/evo-nexus/tree/main/.claude/skills/db-mysqlType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add evolution-foundation/evo-nexus --skill db-mysql -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install evolution-foundation/evo-nexus db-mysql --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/evolution-foundation/evo-nexus.git skills-src && mkdir -p .agents/skills && cp -r skills-src/.claude/skills/db-mysql .agents/skills/db-mysql && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "db-mysql" agent skill from https://github.com/evolution-foundation/evo-nexus/tree/main/.claude/skills/db-mysql into .agents/skills/db-mysql/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "db-mysql", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add evolution-foundation/evo-nexus --skill db-mysql -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install evolution-foundation/evo-nexus db-mysql --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/evolution-foundation/evo-nexus.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/.claude/skills/db-mysql .cursor/skills/db-mysql && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "db-mysql" agent skill from https://github.com/evolution-foundation/evo-nexus/tree/main/.claude/skills/db-mysql into .cursor/skills/db-mysql/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "db-mysql", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/evolution-foundation/evo-nexus.git --path .claude/skills/db-mysql--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add evolution-foundation/evo-nexus --skill db-mysql -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install evolution-foundation/evo-nexus db-mysql --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/evolution-foundation/evo-nexus.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/.claude/skills/db-mysql .gemini/skills/db-mysql && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "db-mysql" agent skill from https://github.com/evolution-foundation/evo-nexus/tree/main/.claude/skills/db-mysql into .gemini/skills/db-mysql/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "db-mysql", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install evolution-foundation/evo-nexus db-mysqlInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add evolution-foundation/evo-nexus --skill db-mysql -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/evolution-foundation/evo-nexus.git skills-src && mkdir -p .github/skills && cp -r skills-src/.claude/skills/db-mysql .github/skills/db-mysql && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "db-mysql" agent skill from https://github.com/evolution-foundation/evo-nexus/tree/main/.claude/skills/db-mysql into .github/skills/db-mysql/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "db-mysql", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add evolution-foundation/evo-nexus --skill db-mysql -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install evolution-foundation/evo-nexus db-mysql --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/evolution-foundation/evo-nexus.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/.claude/skills/db-mysql .opencode/skills/db-mysql && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "db-mysql" agent skill from https://github.com/evolution-foundation/evo-nexus/tree/main/.claude/skills/db-mysql into .opencode/skills/db-mysql/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "db-mysql", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
Facts
- Skill name
db-mysql- GitHub stars
- 544
- Token cost
- ~1.9k tokens
- SKILL.md length
- 427 words
- Files
- 2 (incl. scripts)
- Skills in repo
- 117
- Repo updated
- First seen
- Licence
- Custom licence
At a glance
Queries MySQL or MariaDB databases declared in .env by label, read-only by default unless a connection explicitly allows writes.
- Works in 4 steps: If the user doesn't specify a label, run… → Write the smallest SQL that answers the… → Run via query. Inspect the result. → …
- Exploring tables and schema in a configured MySQL or MariaDB database
- SKILL.md covers Setup — one-time, per database, Usage, Output shape and Guardrails, plus 3 more sections
- Runs Python scripts from its folder; calls python3 and uv; needs DB_MYSQL_1_PASSWORD
What it does
One or more DB_MYSQL_N_* blocks in a project's .env file get read, each labelled for a specific database such as an orders or analytics instance, and the right connection is picked by label or numeric index at call time. A bundled Python script lists configured connections, health-checks one, runs a read-only query, or explores tables and schema, always as a single JSON line on stdout.
Writes are refused unless the matching connection block sets ALLOW_WRITE=true, and a result that exceeds a row cap is truncated with the full result saved to a CSV log file instead of being re-run. Errors come back as structured JSON with a specific code, such as a missing label, a missing driver, or a blocked write.
When your agent uses it
- Exploring tables and schema in a configured MySQL or MariaDB database
- Running a read-only ad hoc query against a labelled database connection
- Auditing recent data in a specific environment without write access
Example prompts
- “List the tables in the orders-dev database connection.”
- “Run a count of customers created in the last 7 days against analytics-prod.”
- “Health-check every MySQL connection configured in .env.”
Requirements
- Python 3 with `pymysql`
- DB_MYSQL_N_* connection blocks in .env
Workflow steps
4 steps, taken from the first numbered list in SKILL.md.
- If the user doesn't specify a label, run accounts to see what's configured and pick the one that matches their intent. If ambiguous, ask.
- Write the smallest SQL that answers the question — prefer aggregates, LIMIT, and EXPLAIN before dumping rows.
- Run via query. Inspect the result.
- For performance-sensitive queries, load the deep-dive references below.
What it can do on your machine
Read from SKILL.md and the folder at commit 7f5dd76. It shows what the files ask for, not the result of running them.
Tool permissions
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Runs code
Ships 1 file in scripts/ (Python), which the agent can run.
Shell commands in SKILL.md call:
python3uv
From the folder's file list and the shell code blocks in SKILL.md.
Network
Links to these hosts (documentation or services it may open):
raw.githubusercontent.comgithub.com
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names these keys or tokens, usually read from environment variables:
DB_MYSQL_1_PASSWORD
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Context cost
MySQL and MariaDB Query Tool loads about 1.9k tokens when it runs. Until then it costs about 81 tokens; SKILL.md has 427 words of instructions outside code blocks.
Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.
Safety
Auto-check: notes
The automated check noted patterns worth knowing about, such as sudo or a known installer.
- NoteMentions a .env fileSKILL.md:3
MySQL / MariaDB databases configured in .env (DB_MYSQL_N_*). Use when the user asks to query, explore, or audit data in - NoteMentions a .env fileSKILL.md:19
y MySQL / MariaDB databases declared in `.env`. Connections follow the same numbered pattern as `SOCIAL_YOUTUBE_N_*` / ` - NoteMentions a .env fileSKILL.md:23
Add a block to `.env` (gitignored). Increment the index per connection: - NoteMentions a .env fileSKILL.md:32
SQL_1_PASSWORD=... # raw; .env is gitignored - NoteMentions a .env fileSKILL.md:104
nections` — no `DB_MYSQL_N_*` blocks in `.env`
Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); the scripts in this folder are not scanned.
SKILL.md
Its licence (Custom licence) doesn't allow us to republish the file, so here is its outline and opening line. It has 427 words (~1,942 tokens).
“Query MySQL / MariaDB databases declared in .env. Connections follow the same numbered pattern as SOCIAL_YOUTUBE_N_* / SOCIAL_INSTAGRAM_N_* — one block per database, labelled for humans, picked by label or index at call time.”
- name
- db-mysql
Files
SKILL.md and 1 other file (scripts) in .claude/skills/db-mysql of evolution-foundation/evo-nexus.
- SKILL.md
- scripts/db_client.py
Open the folder on GitHubat commit 7f5dd76
Compare with similar skills
MySQL and MariaDB Query Tool next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| MySQL and MariaDB Query Tool this skillevolution-foundation/evo-nexus | 544 | — | ~1.9k | Automated safety check: Notes | Custom licence | |
| Mysqlericrisco/rsc-harness | 156 | — | ~3.7k | Automated safety check: Pass | MIT | |
| Golang Databaseunxed/f4 | 240 | 2 repos | ~2.9k | Automated safety check: Pass | MIT | |
| Whodbxiaoyuge886/aigc | 198 | — | ~894 | Automated safety check: Pass | MIT | |
| Mysqlsickn33/agentic-awesome-skills | 47k | 2 repos | ~2.7k | Automated safety check: Notes | MIT | |
| Matlab Use Databasematlab/matlab-agentic-toolkit | 1.1k | — | ~3.1k | Automated safety check: Pass | Custom licence |
Similar skills
Golang Database
unxed/f4
Comprehensive guide for Go database access — parameterized queries, struct scanning, NULLable columns, transactions, isolation levels, SELECT FOR UPDATE, connection pool, batch processing, context…
Whodb
xiaoyuge886/aigc
Database operations including querying, schema exploration, and data analysis.
Mysql
sickn33/agentic-awesome-skills
Administer MySQL/MariaDB databases. An agent skill from sickn33/agentic-awesome-skills.
Matlab Use Database
matlab/matlab-agentic-toolkit
Reads from, writes to, and manages relational databases using MATLAB Database Toolbox.
Tsh SQL And Database Understanding
TheSoftwareHouse/copilot-collections
SQL writing and database engineering patterns, standards, and procedures.
More from evolution-foundation/evo-nexus
All 117 skills in this repoAI Image Creator
evolution-foundation/evo-nexus
Generates PNG images through OpenRouter models, with transparent backgrounds and reference-image edits, and describes existing images with multimodal vision.
MongoDB Query Client
evolution-foundation/evo-nexus
Runs read-only MongoDB finds, aggregations and collection listings against databases named in your .env, choosing the connection by label or index.
Postgres Query Client
evolution-foundation/evo-nexus
Runs read-only SQL queries and schema exploration against PostgreSQL databases declared in .env, chosen by label or index, with writes blocked unless a connection allows them.
Redis Inspector
evolution-foundation/evo-nexus
Reads keys and server state from Redis instances configured in .env through a read-only Python client, choosing connections by label or index.
Int Bling
evolution-foundation/evo-nexus
Bling ERP integration via API v3. An agent skill from evolution-foundation/evo-nexus.
Int Evo CRM
evolution-foundation/evo-nexus
Query and manage Evo AI CRM data via REST API. An agent skill from evolution-foundation/evo-nexus.
Related
Categories
Questions about MySQL and MariaDB Query Tool
What does MySQL and MariaDB Query Tool do?
Queries MySQL or MariaDB databases declared in .env by label, read-only by default unless a connection explicitly allows writes. env file get read, each labelled for a specific database such as an orders or analytics instance, and the right connection is picked by label or numeric index at call time. A bundled Python script lists configured connections, health-checks one, runs a read-only query, or explores tables and schema, always as a single JSON line on stdout.
When should I use MySQL and MariaDB Query Tool?
MySQL and MariaDB Query Tool fits situations like: exploring tables and schema in a configured MySQL or MariaDB database; running a read-only ad hoc query against a labelled database connection; auditing recent data in a specific environment without write access.
How do I install MySQL and MariaDB Query Tool in Claude Code?
Run `npx skills add evolution-foundation/evo-nexus --skill db-mysql -a claude-code`. Or copy the skill folder (.claude/skills/db-mysql in evolution-foundation/evo-nexus) into .claude/skills/db-mysql in your project. Claude Code loads it when a task matches its description.
How do I install MySQL and MariaDB Query Tool in Codex?
Run `npx skills add evolution-foundation/evo-nexus --skill db-mysql -a codex`. Or copy the skill folder (.claude/skills/db-mysql in evolution-foundation/evo-nexus) into .agents/skills/db-mysql in your project. Codex loads it when a task matches its description.
Can I use MySQL and MariaDB Query Tool in Cursor, Gemini CLI or GitHub Copilot?
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add evolution-foundation/evo-nexus --skill db-mysql -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/db-mysql, .gemini/skills/db-mysql, .github/skills/db-mysql and .opencode/skills/db-mysql in your project.
What does MySQL and MariaDB Query Tool need to run?
Going by SKILL.md and its folder, MySQL and MariaDB Query Tool needs Python for the scripts in its folder, the command-line tools its instructions call (python3 and uv) and credentials named DB_MYSQL_1_PASSWORD. Our summary lists: Python 3 with `pymysql`; DB_MYSQL_N_* connection blocks in .env.
Does MySQL and MariaDB Query Tool access the network?
SKILL.md names 2 domains. As links in the text: raw.githubusercontent.com and github.com. This is read from the text; nothing was executed.
Is MySQL and MariaDB Query Tool safe to install?
Our automated static check of SKILL.md found notes only (mentions a .env file), nothing it rates as a warning. It is not a guarantee. The check reads SKILL.md only: the scripts in the folder are not scanned, so read them before running anything.
What licence does MySQL and MariaDB Query Tool use?
MySQL and MariaDB Query Tool has a licence file (the repository's licence) that doesn't match a standard licence. Read it on GitHub before reusing the skill.
How many tokens does MySQL and MariaDB Query Tool use?
About 1.9k tokens (SKILL.md is roughly 7.8k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
What are the alternatives to MySQL and MariaDB Query Tool?
Skills that share tags, products or a category with MySQL and MariaDB Query Tool: Mysql (ericrisco/rsc-harness, 156 stars), Golang Database (unxed/f4, 240 stars), Whodb (xiaoyuge886/aigc, 198 stars) and Mysql (sickn33/agentic-awesome-skills, 47k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains MySQL and MariaDB Query Tool?
evolution-foundation (a GitHub organization) maintains it in evolution-foundation/evo-nexus, which has 544 GitHub stars. The repository holds 117 skills in this directory. The repository was last updated on May 13, 2026.
Source: evolution-foundation/evo-nexus on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.