Skip to content

LiorCohen/sdd / plugin/fullstack-typescript/skills/components/database/database-scaffolding

database-scaffolding

Verified

Scaffolds PostgreSQL database component with migrations, seeds, and management scripts.

templates/seeds/001_seed_data.sql

View on GitHub
-- Seed: 001_seed_data
-- Description: Initial seed data for {{PROJECT_NAME}}
-- Created: {{DATE}}

BEGIN;

SET search_path TO app, public;

-- Use ON CONFLICT for idempotent seeds
-- See: skills/postgresql/references/seed-data.md

-- Example: Reference data
-- INSERT INTO app.status_types (code, name) VALUES
--     ('active', 'Active'),
--     ('inactive', 'Inactive'),
--     ('pending', 'Pending')
-- ON CONFLICT (code) DO UPDATE SET name = EXCLUDED.name;

-- Example: Test user (development only)
-- INSERT INTO app.users (id, email) VALUES
--     ('00000000-0000-0000-0000-000000000001', 'admin@example.com')
-- ON CONFLICT (id) DO UPDATE SET email = EXCLUDED.email;

-- Add your seed data here

COMMIT;
deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall