What naming convention does this skill enforce?

The skill enforces snake_case for all database fields and sub-structs within JSONB columns to maintain consistency across the schema.

Which field types are available?

Available types include StringField, UUIDField, IntField (for integers and booleans), DecimalField, IntConstantField, and StructField for JSONB.

Can I control API visibility with this skill?

Yes, it supports 'public' tags that determine if a field is returned in a view or editable via public endpoints.

Does it support UUID fields?

Yes, UUID fields are fully supported and are automatically configured with nullable defaults (default:"null" null:"true").

How are boolean values handled in this skill?

This skill avoids traditional boolean types, instead using smallint fields with 0/1 values for better cross-database compatibility.

Database Column Creator

Name: Database Column Creator
Author: griffnb

bygriffnb

0•

データベース管理

Streamlines the creation and update of database columns using standardized Go struct tags and naming conventions.

This skill automates the process of defining database schemas within Go applications by enforcing strict naming conventions and implementation patterns. It ensures all fields and JSONB sub-structs follow snake_case, replaces standard booleans with smallint 0/1 fields for better compatibility, and handles complex struct tag annotations for migrations, nullability, and indexing. It is designed to help developers maintain consistent backend architecture and data integrity when adding or modifying database columns.

主な機能

010 GitHub stars

02Implements specialized field types including UUID, Decimal, and IntConstant

03Automates Go struct tag generation for columns, types, and constraints

04Manages smallint logic for boolean values to ensure database consistency

05Enforces snake_case naming for all database fields and JSONB sub-structs

06Supports public visibility tags for controlling API endpoint access

ユースケース

01Designing complex JSONB structures with proper snake_case sub-fields

02Adding new columns to existing database tables with standardized Go annotations

03Configuring database constraints like uniqueness and indexing during development

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add griffnb/claude-plugins db-new-column

For use in Claude.ai and ChatGPT

Download Skill