Database Partition Manager Skill for PostgreSQL Month Ranges
Design a PostgreSQL range partition around a frequent date predicate and inspect the local plan for pruning.
中文Install in Claude Code
Use a PostgreSQL test database, psql, synthetic events, and UTC month boundaries.
- Get the complete `plugins/database/database-partition-manager/skills/managing-database-partitions` directory from the pinned GitHub commit.
- Copy it into the target project's `.claude/skills/`. Check `.claude/skills/managing-database-partitions/SKILL.md`, start Claude Code at the project root, and call `/managing-database-partitions`.
Example task
Create January and February partitions and insert events at Jan 31 23:59Z and Feb 1 00:00Z. Query from Feb 1 inclusive to Mar 1 exclusive.What to check
The February query returns only the second row, and EXPLAIN shows whether the January partition was pruned.
Original SKILL.md on GitHub · Updated
Frequently asked question
Should BETWEEN include the first moment of the next month?
Use a half-open range so the first event of the next month stays outside the current report.