Which databases are supported by this skill?

This skill provides specialized support and automation for PostgreSQL (psql), MySQL, and MongoDB (mongosh) environments.

How does it ensure database safety during partitioning?

The skill enforces a rigorous workflow involving prerequisites checks, backup requirements, non-production testing, and the creation of detailed rollback plans.

Does this skill help with data migration?

Yes, it provides a structured 5-step process that includes assessment, design, and implementation to safely transition data into partitioned structures.

Can it automate ongoing partition maintenance?

Yes, it generates operational artifacts including scripts, monitoring dashboards, and runbooks to assist with the ongoing management of partitions.

Database Partition Manager

Name: Database Partition Manager
Author: jeremylongshore

byjeremylongshore

•

897

데이터베이스 관리

Optimizes large-scale database performance by automating table partitioning strategies across PostgreSQL, MySQL, and MongoDB environments.

소개

The Database Partition Manager skill empowers Claude to design and implement efficient data partitioning strategies for high-volume databases. It guides the AI through assessing current table structures, selecting optimal partitioning keys (range, list, or hash), executing non-destructive implementations, and validating performance gains. This skill is indispensable for developers managing massive datasets who need to reduce query latency, improve index efficiency, and simplify data lifecycle management without manual overhead.

주요 기능

Performance benchmarking and validation against baseline metrics
Multi-database support for PostgreSQL, MySQL, and MongoDB
Safe implementation workflows with rollback and recovery planning
897 GitHub stars
Generation of operational runbooks and monitoring configurations
Automated partition strategy assessment and design

사용 사례

Refactoring monolithic audit logs into time-based partitions to improve query performance
Implementing tenant-based list partitioning to isolate customer data in multi-tenant apps
Automating the migration of legacy tables to partitioned structures to simplify data archival

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeremylongshore/claude-code-plugins-plus-skills managing-database-partitions

For use in Claude.ai and ChatGPT

Download Skill

GitHub

소개