automating-database-backups
について
このスキルは、PostgreSQL、MySQL、MongoDB、SQLiteに対応し、スケジュール設定、圧縮、暗号化、復元のためのスクリプトを生成することで、データベースのバックアップを自動化します。開発者がバックアップ自動化や災害復旧手順の導入を必要とする際に起動されます。バックアップスケジュールの設定や復元スクリプトの作成などのリクエストにご利用ください。
クイックインストール
Claude Code
推奨/plugin add https://github.com/jeremylongshore/claude-code-plugins-plusgit clone https://github.com/jeremylongshore/claude-code-plugins-plus.git ~/.claude/skills/automating-database-backupsこのコマンドをClaude Codeにコピー＆ペーストしてスキルをインストールします
ドキュメント
Overview
This skill streamlines the creation of database backup solutions. It generates scripts, configures schedules, and provides comprehensive restore procedures, ensuring data safety and efficient recovery.
How It Works
- Analyze Requirements: Determines the database type (PostgreSQL, MySQL, MongoDB, or SQLite) and backup requirements (frequency, retention).
- Generate Scripts: Creates backup scripts with compression and encryption.
- Schedule Backups: Sets up cron jobs for automated, scheduled backups.
- Document Restore: Generates clear, concise restore procedures.
When to Use This Skill
This skill activates when you need to:
- Create a backup schedule for a database.
- Automate the database backup process.
- Generate scripts for database restoration.
- Implement a disaster recovery plan for a database.
Examples
Example 1: Setting up Daily Backups for PostgreSQL
User request: "Create daily backups for my PostgreSQL database."
The skill will:
- Generate a
pg_dumpscript with compression and encryption. - Create a cron job to run the backup script daily.
Example 2: Automating Weekly Backups for MongoDB
User request: "Automate weekly backups for my MongoDB database."
The skill will:
- Generate a
mongodumpscript with compression and encryption. - Create a cron job to run the backup script weekly and implement a retention policy.
Best Practices
- Retention Policies: Implement clear retention policies to manage storage space.
- Testing Restores: Regularly test restore procedures to ensure data integrity.
- Secure Storage: Store backups in secure, encrypted locations, preferably offsite.
Integration
This skill can integrate with cloud storage plugins (S3, GCS, Azure) for offsite backup storage and monitoring plugins for backup success/failure alerts.
GitHub リポジトリ
関連スキル
content-collections
メタThis skill provides a production-tested setup for Content Collections, a TypeScript-first tool that transforms Markdown/MDX files into type-safe data collections with Zod validation. Use it when building blogs, documentation sites, or content-heavy Vite + React applications to ensure type safety and automatic content validation. It covers everything from Vite plugin configuration and MDX compilation to deployment optimization and schema validation.
creating-opencode-plugins
メタThis skill provides the structure and API specifications for creating OpenCode plugins that hook into 25+ event types like commands, files, and LSP operations. It offers implementation patterns for JavaScript/TypeScript modules that intercept and extend the AI assistant's lifecycle. Use it when you need to build event-driven plugins for monitoring, custom handling, or extending OpenCode's capabilities.
evaluating-llms-harness
テストThis Claude Skill runs the lm-evaluation-harness to benchmark LLMs across 60+ standardized academic tasks like MMLU and GSM8K. It's designed for developers to compare model quality, track training progress, or report academic results. The tool supports various backends including HuggingFace and vLLM models.
sglang
メタSGLang is a high-performance LLM serving framework that specializes in fast, structured generation for JSON, regex, and agentic workflows using its RadixAttention prefix caching. It delivers significantly faster inference, especially for tasks with repeated prefixes, making it ideal for complex, structured outputs and multi-turn conversations. Choose SGLang over alternatives like vLLM when you need constrained decoding or are building applications with extensive prefix sharing.