Be sure all database fields are snakecase Be sure all sub structs that are in jsonb collumns are also snakecase Be sure to not use booleans for fields, use smallint 0/1

Struct Tag Annotations

Critical: Struct tags control database migrations and constraints. Include all relevant tags:

Name     *fields.StringField `column:"name" type:"text" default:"":"false"`
Email    *fields.StringField `column:"email" type:"text" default:"" unique:"true"`
Age      *fields.IntField    `column:"age" type:"integer" default:"0" null:"true"`
Status   *fields.IntConstantField[Status] `column:"status" type:"smallint" default:"1"`
Settings *fields.StructField[*Settings] `column:"settings" type:"jsonb" default:"{}"`

Available Tags:

column:"name" – Database column name (required)
type:"text|jsonb|smallint|integer|uuid|date|datetime|bigint" – Database column type (required) note that all 'boolean' type things should be a smallint 0/1
default:"value/null" – Default value for column
null:"true" – Whether column allows NULL, dont add if not nullable
unique:"true" – Whether column has unique constraint, dont add if not unique
index:"true" – Whether to create index on column, dont add if not indexed
public:"view|edit" - For public endpoints, determines whether or not the field is returned (view or edit) or on updates if its editable by the user (edit), dont add if not public facing
IMPORTANT - for all UUID fields, they must have default:"null" null:"true"

Field Types

StringField – Text/string columns
UUIDField – UUID columns
IntField – Integer columns / Bool fields with smallint 0/1 values
DecimalField – Decimal/numeric columns
IntConstantField[T] – Enum/constant fields
StructField[T] – JSONB/struct columns

All fields provide .Set(val) and .Get() methods. Struct fields have a .GetI() for when errors do not need to be checked

npx skills add https://smithery.ai