LiorCohen/sdd / plugin/fullstack-typescript/skills/components/database/database-scaffolding
database-scaffolding
VerifiedScaffolds PostgreSQL database component with migrations, seeds, and management scripts.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 6.0 KB |
| schemas/input.schema.json | config | 519 B |
| schemas/output.schema.json | config | 1.4 KB |
| templates/README.md | markdown | 2.6 KB |
| templates/migrations/001_initial_schema.sql | other | 910 B |
| templates/package.json | manifest | 62 B |
| templates/seeds/001_seed_data.sql | other | 711 B |
templates/migrations/001_initial_schema.sql
View on GitHub-- Migration: 001_initial_schema
-- Description: Initial database schema for {{PROJECT_NAME}}
-- Created: {{DATE}}
BEGIN;
-- Create application schema
CREATE SCHEMA IF NOT EXISTS app;
-- Set search path for this session
SET search_path TO app, public;
-- Example table structure (customize for your domain)
-- See: skills/postgresql/references/schema-management.md
-- CREATE TABLE app.users (
-- id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
-- email TEXT UNIQUE NOT NULL,
-- created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
-- updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
-- );
-- CREATE TABLE app.audit_log (
-- id BIGSERIAL PRIMARY KEY,
-- table_name TEXT NOT NULL,
-- record_id UUID NOT NULL,
-- action TEXT NOT NULL,
-- changed_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
-- changed_by UUID REFERENCES app.users(id)
-- );
-- Add your initial schema here
COMMIT;
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| 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: 119k | Updated | Claude CodeCodex | Verified | Install |
| 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: 119k | Updated | Claude CodeCodex | Verified | Install |
| 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: 118k | Updated | Claude CodeCodex | Verified | Install |
| 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: 118k | Updated | Claude CodeCodex | Verified | Install |