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/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;
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