tdc-database
CommunityManage The Dreamer's Cave MySQL DB.
AuthorAlex-65
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill provides an automated, reliable workflow to manage The Dreamer's Cave MySQL database, including schema evolution, migrations, data seeding, and safe backups/restores, reducing manual DB toil and drift across environments.
Core Features & Use Cases
- Schema management: maintain the canonical schema with sql/schema.sql and coordinated migrations.
- Migrations & seeding: apply incremental migrations from sql/migrations and seed initial data from sql/seeds.
- Backup & restore: create consistent backups and restore from them using standard MySQL CLI tools for disaster recovery and environment replication.
- Use Case: a developer initializes a new environment by reproducing production schema, running migrations, seeding data, and setting up a local database identical to production.
Quick Start
Run the following commands to get started:
- Initialize from scratch: ./sql/scripts/init_db.sh --drop-existing
- Apply pending migrations: ./sql/scripts/migrate.sh
- Create a backup: ./sql/scripts/backup.sh tdcweb_backup
- Restore from backup: ./sql/scripts/restore.sh /path/to/tdcweb_backup.sql.gz
Dependency Matrix
Required Modules
mysqlmysqldumpgzipgunzip
Components
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: tdc-database Download link: https://github.com/Alex-65/tdcweb/archive/main.zip#tdc-database Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.