Agent skill

Recreate Test DB

by haru in haru/redmine_ai_helper

Recreate the Redmine test database from scratch (delete db/schema.rb and db/redmine.sqlite3test, then run core and plugin migrations with RAILSENV=test).

MITAuto-check passedBackend & APIs

Install Recreate Test DB

skills CLI
$ npx skills add haru/redmine_ai_helper --skill recreate-test-db -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install haru/redmine_ai_helper recreate-test-db --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/haru/redmine_ai_helper.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.claude/skills/recreate-test-db .claude/skills/recreate-test-db && rm -rf skills-src

Use ~/.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/

Facts

Skill name
recreate-test-db
GitHub stars
106
Token cost
~364 tokens
SKILL.md length
122 words
Files
1
Skills in repo
21
Repo updated
First seen
Licence
MIT

At a glance

Recreate the Redmine test database from scratch (delete db/schema.rb and db/redmine.sqlite3test, then run core and plugin migrations with RAILSENV=test).

  • Works in 5 steps: Delete the generated schema → Delete the test database → Run core migrations → …
  • The test DB is out of sync
  • Calls bundle and rails
  • Migrations changed

What it does

Recreate Test DB is an agent skill from haru/redmine_ai_helper. Recreate the Redmine test database from scratch (delete db/schema.rb and db/redmine.sqlite3test, then run core and plugin migrations with RAILSENV=test). Use when the test DB is out of sync, migrations changed, or the user asks to rebuild/reset the test database.

Its SKILL.md is about 360 tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Backend & APIs, covering Backend development. It works with SQLite. The repository describes itself as: A Redmine plugin that adds AI agents, MCP Server, smart completion, and vector search. The licence is MIT.

When your agent uses it

  • The test DB is out of sync
  • Migrations changed
  • The user asks to rebuild/reset the test database

Example prompts

  • “/recreate-test-db”

Workflow steps

5 steps, taken from the step headings in SKILL.md.

  1. Delete the generated schema
  2. Delete the test database
  3. Run core migrations
  4. Run plugin migrations
  5. Report

What it can do on your machine

Read from SKILL.md and the folder at commit 3cd87d6. 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

    Shell commands in SKILL.md call:

    • bundle
    • rails

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Recreate Test DB loads about 364 tokens when it runs. Until then it costs about 71 tokens; SKILL.md has 122 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~71
When it runs · the whole SKILL.md, loaded when a task matches
~364

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 passed

The automated check found no risky patterns in SKILL.md.

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); files beside SKILL.md are not scanned.

SKILL.md

The full file from haru/redmine_ai_helper at commit 3cd87d6, republished under its MIT licence (© haru). 122 words, ~364 tokens.

Download SKILL.mdSave it as .claude/skills/recreate-test-db/SKILL.md (or your agent's skills folder).
name
recreate-test-db
description
Recreate the Redmine test database from scratch (delete db/schema.rb and db/redmine.sqlite3_test, then run core and plugin migrations with RAILS_ENV=test). Use when the test DB is out of sync, migrations changed, or the user asks to rebuild/reset the test database.

Recreate Test Database

Rebuild the SQLite test database of the Redmine instance at /usr/local/redmine.

IMPORTANT: Never run rails test. Only run the steps below, and only when the user asks to rebuild the test DB. Never migrate the test DB on your own initiative.

Workflow

Run from /usr/local/redmine.

Step 1: Delete the generated schema

db/schema.rb is git-ignored and regenerated by migrations. It may be absent; that is fine.

bash
rm -f /usr/local/redmine/db/schema.rb
Step 2: Delete the test database
bash
rm -f /usr/local/redmine/db/redmine.sqlite3_test

Do NOT touch db/redmine.sqlite3 (the development DB).

Step 3: Run core migrations
bash
cd /usr/local/redmine && bundle exec rake db:migrate RAILS_ENV=test 2>&1 | tail -30
Step 4: Run plugin migrations

Core db:migrate does not run plugin migrations.

bash
cd /usr/local/redmine && bundle exec rake redmine:plugins:migrate RAILS_ENV=test 2>&1 | tail -30
Step 5: Report

State whether both migrations finished without errors and name the last migration applied in each. Do not run tests unless asked.

© haru, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in .claude/skills/recreate-test-db of haru/redmine_ai_helper.

Open the folder on GitHubat commit 3cd87d6

Compare with similar skills

Recreate Test DB 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.

Recreate Test DB compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Recreate Test DB this skillharu/redmine_ai_helper106—~364Automated safety check: PassMIT
Fastapi Backend Scaffold5zjk5/prompt-engineering127—~1.3kAutomated safety check: NotesNone
Domodomo Backend Fastapidarknecrocities/DomoDomo---All-in-one-Tool239—~17kAutomated safety check: PassNone
Junta Leiloeirossickn33/agentic-awesome-skills47k2 repos~1.6kAutomated safety check: PassMIT
Server Feature Devscragnog/HOT-Step-CPP171—~6.5kAutomated safety check: NotesMIT
Junta Leiloeirosdiegosouzapw/awesome-omni-skills159—~3.7kAutomated safety check: PassMIT

Similar skills

  • Fastapi Backend Scaffold

    5zjk5/prompt-engineering

    生成标准 FastAPI 后端分层架构目录脚手架。当用户需要从零搭建 FastAPI 后端、重构后端目录结构、或创建新的后端项目时触发此技能。技能内置 LLM 多模型客户端(支持重试、流式、备用切换)、会话级日志、SQLite 数据访问层、SSE 流式 API 示例等生产级模板代码,一键生成完整可运行的后端骨架。触发场景包括"搭建后端"、"创建 FastAPI…

    127 GitHub stars~1.3k tokensUpdated 23 days ago
    Backend & APIsAuto-check: notes
  • Domodomo Backend Fastapi

    darknecrocities/DomoDomo---All-in-one-Tool

    Maintain DomoDomo’s local FastAPI application, routers, SQLite models, local services, and Python utilities.

    239 GitHub stars~17k tokensUpdated 2 days ago
    Backend & APIsAuto-check passed
  • Junta Leiloeiros

    sickn33/agentic-awesome-skills

    Coleta e consulta dados de leiloeiros oficiais de todas as 27 Juntas Comerciais do Brasil.

    47k GitHub starsUsed in 2 repos~1.6k tokens
    Backend & APIsAuto-check passed
  • Server Feature Dev

    scragnog/HOT-Step-CPP

    Guides adding or modifying a feature in the HOT-Step CPP Node/TypeScript server (Express route + service pattern, better-sqlite3 schema changes, engine calls via aceClient, logging, tsx watch dev…

    171 GitHub stars~6.5k tokensUpdated yesterday
    Backend & APIsAuto-check: notes
  • Junta Leiloeiros

    diegosouzapw/awesome-omni-skills

    Skill: Leiloeiros das Juntas Comerciais do Brasil workflow skill.

    159 GitHub stars~3.7k tokensUpdated 3 mo ago
    Backend & APIsAuto-check passed
  • Laravel Testing

    HoangNguyen0403/agent-skills-standard

    Write Pest feature tests with RefreshDatabase, mock external services, and create test data with Eloquent Factories in Laravel.

    571 GitHub stars~989 tokensUpdated yesterday
    Backend & APIsAuto-check passed

More from haru/redmine_ai_helper

All 21 skills in this repo
  • Commit

    haru/redmine_ai_helper

    Stage the current changes and create a git commit with a properly formatted English message.

    106 GitHub stars~1.1k tokensUpdated yesterday
    Auto-check: notes
  • Create Pull Request

    haru/redmine_ai_helper

    Create a pull request from the current branch. An agent skill from haru/redmine_ai_helper.

    106 GitHub stars~1.5k tokensUpdated yesterday
    Auto-check passed
  • Create Release Branch

    haru/redmine_ai_helper

    Create a release branch for a given version. An agent skill from haru/redmine_ai_helper.

    106 GitHub stars~599 tokensUpdated yesterday
    Auto-check passed
  • Qlty Check

    haru/redmine_ai_helper

    Code quality checks, formatting, and metrics via qlty CLI. An agent skill from haru/redmine_ai_helper.

    106 GitHub starsUsed in 2 repos~628 tokens
    Auto-check passed
  • Redmine Playwright Login

    haru/redmine_ai_helper

    Connect to the running Redmine instance and log in via the Playwright MCP browser, using REDMINEPLAYRIGHTURL/REDMINEPLAYRIGHTUSER/REDMINEPLAYRIGHTPASSWORD environment variables.

    106 GitHub stars~796 tokensUpdated yesterday
    Auto-check passed
  • Create Release Notes

    haru/redmine_ai_helper

    Generate Redmine.org release notes from a GitHub release tag.

    106 GitHub stars~768 tokensUpdated yesterday
    Auto-check passed

Works with

Categories

Questions about Recreate Test DB

What does Recreate Test DB do?

Recreate the Redmine test database from scratch (delete db/schema.rb and db/redmine.sqlite3test, then run core and plugin migrations with RAILSENV=test). Recreate Test DB is an agent skill from haru/redmine_ai_helper.sqlite3test, then run core and plugin migrations with RAILSENV=test).

When should I use Recreate Test DB?

Recreate Test DB fits situations like: the test DB is out of sync; migrations changed; the user asks to rebuild/reset the test database.

How do I install Recreate Test DB in Claude Code?

Run `npx skills add haru/redmine_ai_helper --skill recreate-test-db -a claude-code`. Or copy the skill folder (.claude/skills/recreate-test-db in haru/redmine_ai_helper) into .claude/skills/recreate-test-db in your project. Claude Code loads it when a task matches its description.

How do I install Recreate Test DB in Codex?

Run `npx skills add haru/redmine_ai_helper --skill recreate-test-db -a codex`. Or copy the skill folder (.claude/skills/recreate-test-db in haru/redmine_ai_helper) into .agents/skills/recreate-test-db in your project. Codex loads it when a task matches its description.

Can I use Recreate Test DB 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 haru/redmine_ai_helper --skill recreate-test-db -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/recreate-test-db, .gemini/skills/recreate-test-db, .github/skills/recreate-test-db and .opencode/skills/recreate-test-db in your project.

What does Recreate Test DB need to run?

Going by SKILL.md and its folder, Recreate Test DB needs the command-line tools its instructions call (bundle and rails).

Does Recreate Test DB access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Recreate Test DB safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Recreate Test DB use?

Recreate Test DB is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Recreate Test DB use?

About 364 tokens (SKILL.md is roughly 1.5k 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 Recreate Test DB?

Skills that share tags, products or a category with Recreate Test DB: Fastapi Backend Scaffold (5zjk5/prompt-engineering, 127 stars), Domodomo Backend Fastapi (darknecrocities/DomoDomo---All-in-one-Tool, 239 stars), Junta Leiloeiros (sickn33/agentic-awesome-skills, 47k stars) and Server Feature Dev (scragnog/HOT-Step-CPP, 171 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Recreate Test DB?

haru (a GitHub user) maintains it in haru/redmine_ai_helper, which has 106 GitHub stars. The repository holds 21 skills in this directory. The repository was last updated on October 8, 2026.

Source: haru/redmine_ai_helper on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.