Agent skill

Memorains DB Backup

by redTreeOnWall in redTreeOnWall/memorains

Back up the memorains production database and download the dump to the local backups/ directory.

MITAuto-check passedDevOps & Cloud

Install Memorains DB Backup

skills CLI
$ npx skills add redTreeOnWall/memorains --skill memorains-db-backup -a claude-code

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

GitHub CLI
$ gh skill install redTreeOnWall/memorains memorains-db-backup --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/redTreeOnWall/memorains.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.agents/skills/memorains-db-backup .claude/skills/memorains-db-backup && 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
memorains-db-backup
GitHub stars
127
Token cost
~565 tokens
SKILL.md length
155 words
Files
1
Skills in repo
3
Repo updated
First seen
Licence
MIT

At a glance

Back up the memorains production database and download the dump to the local backups/ directory.

  • Works in 5 steps: Dump the database → Compress the dump → Download to local backups/ directory → …
  • The user wants to back up
  • SKILL.md covers Prerequisites, Determine the target host, Backup Steps and Database Connection Details, plus 2 more sections
  • Calls ssh, scp and podman

What it does

Memorains DB Backup is an agent skill from redTreeOnWall/memorains. Back up the memorains production database and download the dump to the local backups/ directory. Use when the user wants to back up, dump, export, or download the memorains database, or mentions database backup, DB snapshot, or saving the database.

Its SKILL.md is about 570 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 DevOps & Cloud, covering Backup and disaster recovery and Database administration. It works with MariaDB. The licence is MIT.

When your agent uses it

  • The user wants to back up
  • Download the memorains database
  • Mentions database backup
  • Saving the database

Example prompts

  • “/memorains-db-backup”

Requirements

  • Docker

Workflow steps

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

  1. Dump the database
  2. Compress the dump
  3. Download to local backups/ directory
  4. Verify integrity
  5. Clean up remote temp file

What it can do on your machine

Read from SKILL.md and the folder at commit 5a34ebc. 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:

    • ssh
    • scp
    • podman

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

  • Network

    No URLs in SKILL.md. Its commands use ssh and scp, which can reach the network depending on how they are called.

    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

Memorains DB Backup loads about 565 tokens when it runs. Until then it costs about 67 tokens; SKILL.md has 155 words of instructions outside code blocks.

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

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 redTreeOnWall/memorains at commit 5a34ebc, republished under its MIT licence (© redTreeOnWall). 155 words, ~565 tokens.

Download SKILL.mdSave it as .claude/skills/memorains-db-backup/SKILL.md (or your agent's skills folder).
name
memorains-db-backup
description
Back up the memorains production database and download the dump to the local backups/ directory. Use when the user wants to back up, dump, export, or download the memorains database, or mentions database backup, DB snapshot, or saving the database.

Memorains DB Backup

Back up the remote MariaDB database and download the compressed dump to the local backups/ directory.

Prerequisites

  • SSH access to the target server — if the user didn't specify which server, ask
  • Server must have podman running with the reno_note_mariadb container

Determine the target host

If the user already specified a host, use it. Otherwise, ask: "Which server should I back up?"

In all commands below, replace <HOST> with the actual hostname.

Backup Steps

1. Dump the database
bash
ssh <HOST> "podman exec reno_note_mariadb mariadb-dump -u doc -p123456 document > /tmp/memorains_backup_<HOST>_\$(date +%Y%m%d_%H%M%S).sql"
2. Compress the dump
bash
ssh <HOST> "ls -t /tmp/memorains_backup_<HOST>_*.sql | head -1 | xargs gzip -f && ls -lh /tmp/memorains_backup_<HOST>_*.sql.gz | tail -1"
3. Download to local backups/ directory
bash
scp <HOST>:/tmp/memorains_backup_<HOST>_<TIMESTAMP>.sql.gz <PROJECT_ROOT>/backups/

If the download is slow (file may be 50-80MB), add -o ConnectTimeout=30 -o ServerAliveInterval=15 to the scp command and use a generous timeout.

4. Verify integrity
bash
gzip -t <PROJECT_ROOT>/backups/memorains_backup_<HOST>_<TIMESTAMP>.sql.gz && echo "✅ Backup complete and verified"
5. Clean up remote temp file
bash
ssh <HOST> "rm /tmp/memorains_backup_<HOST>_*.sql.gz"

Database Connection Details

ParameterValue
Containerreno_note_mariadb
Databasedocument
Userdoc
Password123456

These come from docker-compose.yml in the deployed package.

Output

A timestamped, gzip-compressed SQL dump saved in <PROJECT_ROOT>/backups/:

backups/memorains_backup_<HOST>_20260628_152430.sql.gz

Restore (if needed)

bash
gunzip < memorains_backup_<HOST>_<TIMESTAMP>.sql.gz | podman exec -i reno_note_mariadb mariadb -u doc -p123456 document

© redTreeOnWall, 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 .agents/skills/memorains-db-backup of redTreeOnWall/memorains.

Open the folder on GitHubat commit 5a34ebc

Compare with similar skills

Memorains DB Backup 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.

Memorains DB Backup compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Memorains DB Backup this skillredTreeOnWall/memorains127—~565Automated safety check: PassMIT
AWS Rdssickn33/agentic-awesome-skills47k2 repos~3.3kAutomated safety check: PassMIT
Planning Disaster Recoveryancoleman/ai-design-components525—~3.1kAutomated safety check: PassMIT
Database Backupssickn33/agentic-awesome-skills47k2 repos~3.1kAutomated safety check: NotesMIT
Postgresql Devsecsickn33/agentic-awesome-skills47k2 repos~2.5kAutomated safety check: NotesMIT
Alloydb Basicsgoogle/skills21k—~1.7kAutomated safety check: PassApache-2.0

Similar skills

  • AWS Rds

    sickn33/agentic-awesome-skills

    Provision and manage RDS databases. An agent skill from sickn33/agentic-awesome-skills.

    47k GitHub starsUsed in 2 repos~3.3k tokens
    DevOps & CloudAuto-check passed
  • Planning Disaster Recovery

    ancoleman/ai-design-components

    Design and implement disaster recovery strategies with RTO/RPO planning, database backups, Kubernetes DR, cross-region replication, and chaos engineering testing.

    525 GitHub stars~3.1k tokensUpdated 10 mo ago
    DevOps & CloudAuto-check passed
  • Database Backups

    sickn33/agentic-awesome-skills

    Implement database backup strategies. An agent skill from sickn33/agentic-awesome-skills.

    47k GitHub starsUsed in 2 repos~3.1k tokens
    DatabasesAuto-check: notes
  • Postgresql Devsec

    sickn33/agentic-awesome-skills

    Administer PostgreSQL databases. An agent skill from sickn33/agentic-awesome-skills.

    47k GitHub starsUsed in 2 repos~2.5k tokens
    DatabasesAuto-check: notes
  • Alloydb Basics

    google/skills

    Official

    Manages clusters, instances, and backups for AlloyDB for PostgreSQL, and integrates with AlloyDB Model Context Protocol (MCP) tools for automated database operations.

    21k GitHub stars~1.7k tokensUpdated today
    DatabasesAuto-check passed
  • Alloydb Basics

    davila7/claude-code-templates

    Manages clusters, instances, and backups for AlloyDB for PostgreSQL, and integrates with AlloyDB MCP tools for automated database operations including AI-powered search and vector capabilities.

    33k GitHub stars~611 tokensUpdated today
    DatabasesAuto-check passed

More from redTreeOnWall/memorains

  • Memorains GitHub Release

    redTreeOnWall/memorains

    Tag a new version, create a GitHub release with organized release notes, build all packages, and upload artifacts.

    127 GitHub stars~1.3k tokensUpdated today
    Auto-check passed
  • Memorains Deploy

    redTreeOnWall/memorains

    Deploy memorains to production servers. An agent skill from redTreeOnWall/memorains.

    127 GitHub stars~974 tokensUpdated today
    Auto-check: warnings

Works with

Categories

Questions about Memorains DB Backup

What does Memorains DB Backup do?

Back up the memorains production database and download the dump to the local backups/ directory. Memorains DB Backup is an agent skill from redTreeOnWall/memorains. Back up the memorains production database and download the dump to the local backups/ directory.

When should I use Memorains DB Backup?

Memorains DB Backup fits situations like: the user wants to back up; download the memorains database; mentions database backup; saving the database.

How do I install Memorains DB Backup in Claude Code?

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

How do I install Memorains DB Backup in Codex?

Run `npx skills add redTreeOnWall/memorains --skill memorains-db-backup -a codex`. Or copy the skill folder (.agents/skills/memorains-db-backup in redTreeOnWall/memorains) into .agents/skills/memorains-db-backup in your project. Codex loads it when a task matches its description.

Can I use Memorains DB Backup 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 redTreeOnWall/memorains --skill memorains-db-backup -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/memorains-db-backup, .gemini/skills/memorains-db-backup, .github/skills/memorains-db-backup and .opencode/skills/memorains-db-backup in your project.

What does Memorains DB Backup need to run?

Going by SKILL.md and its folder, Memorains DB Backup needs the command-line tools its instructions call (ssh, scp and podman). Our summary lists: Docker.

Does Memorains DB Backup access the network?

SKILL.md contains no URLs. Its commands use ssh, which can reach the network depending on how they are called. This is read from the text; nothing was executed.

Is Memorains DB Backup 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 Memorains DB Backup use?

Memorains DB Backup 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 Memorains DB Backup use?

About 565 tokens (SKILL.md is roughly 2.3k 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 Memorains DB Backup?

Skills that share tags, products or a category with Memorains DB Backup: AWS Rds (sickn33/agentic-awesome-skills, 47k stars), Planning Disaster Recovery (ancoleman/ai-design-components, 525 stars), Database Backups (sickn33/agentic-awesome-skills, 47k stars) and Postgresql Devsec (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 Memorains DB Backup?

redTreeOnWall (a GitHub user) maintains it in redTreeOnWall/memorains, which has 127 GitHub stars. The repository holds 3 skills in this directory. The repository was last updated on October 9, 2026.

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