Skills
.Work. You
Rest

seed-file-management

Official

Safely manage seed data with deterministic resets

Software Engineering#testing#postgresql#migrations#sequence#seed#upsert#initial-data
Authorsage-base
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Seed data management in PostgreSQL often leads to sequence gaps when IDs are explicitly assigned. This skill defines guidelines to safely create, modify, and apply seed files while preventing sequence collisions.

Core Features & Use Cases

  • Sequence resets after explicit-ID inserts using COALESCE(MAX(id)) patterns to set the corresponding id sequence
  • Idempotent seeds via UPSERT patterns and conflict handling to allow re-running seed scripts safely
  • File structure & naming rules to keep seeds organized and deterministic

Quick Start

Run seed generation or apply seed updates with explicit IDs, and ensure the sequence is reset to max(id) + 1.

Dependency Matrix

Required Modules

None required

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: seed-file-management
Download link: https://github.com/sage-base/sagebase/archive/main.zip#seed-file-management

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.