Reset PostgreSQL sequences after explicit-ID seed inserts.
npx skills add https://github.com/sage-base/sagebase --skill seed-file-management
Please help me install this Agent Skill. Skill: seed-file-management Source: https://github.com/sage-base/sagebase/tree/main/.claude/skills/seed-file-management Command: npx skills add https://github.com/sage-base/sagebase --skill seed-file-management
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.
Run seed generation or apply seed updates with explicit IDs, and ensure the sequence is reset to max(id) + 1.
High-intent search queries and answers about installing and using this skill.
Sequence gaps occur because manually inserting explicit IDs does not advance the underlying sequence. This skill solves sequence gaps by enforcing sequence resets using the COALESCE(MAX(id)) pattern after explicit-ID inserts.
You can make seed scripts idempotent by using UPSERT patterns and conflict handling. This enables safe re-runs of seed scripts by updating existing rows instead of duplicating data or causing constraint violations.
The best way to reset sequences is applying a COALESCE(MAX(id)) pattern to set the sequence to max(id) + 1 after explicit-ID inserts, preventing future sequence collisions during subsequent data generation.
Yes, you can use UPSERT patterns for deterministic initial data setup. This skill supports UPSERT-based updates during seed generation and migrations to ensure reliable initial data management across database projects.
You need to reset sequences after inserting explicit IDs whenever you require deterministic IDs in seed data, migrations, or initial data setup to prevent sequence collisions and maintain database structural integrity.
motormetricsSeed databases with realistic development and test data using Faker.js.
JaiminVadadoriyaValidate database integrity and test forward and backward migrations.
berkcangumusisikGenerate and synchronize Prisma seed data with idempotent upserts.
ThinkOodleImplement UUID primary keys in Ruby on Rails with PostgreSQL and SQLite.
