Skills
.Work. You
Rest

db-defaults-generated

Community

Ensure column defaults and generated columns are correctly configured

Software Engineering#performance#database#data integrity#default#generated column
AuthorHainrixz
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill audits column defaults and generated columns, ensuring they are correctly configured to maintain data integrity and performance.

Core Features & Use Cases

  • Audit Timestamp Defaults: Checks for created_at/updated_at defaults set by application code instead of database defaults.
  • Derived Value Generation: Ensures derived values are stored as GENERATED ALWAYS AS ... STORED to prevent data drift.
  • Non-deterministic Defaults: Identifies defaults that should be dynamic or missing NOT NULL constraints.
  • Identity/Sequence Hygiene: Validates serial vs GENERATED ... AS IDENTITY usage and sequence ownership.
  • Use Case: Use this Skill to maintain a high-quality database schema by ensuring all defaults and generated columns are correctly implemented.

Quick Start

Run the db-defaults-generated skill to audit your database schema for correct column defaults and generated columns.

Dependency Matrix

Required Modules

None required

Components

scripts

💻 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: db-defaults-generated
Download link: https://github.com/Hainrixz/claude-db/archive/main.zip#db-defaults-generated

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 620,000+ vetted skills library on demand.