Does it support legacy CHAR(1) 'Y/N' flags?

No, this skill enforces the use of native BOOLEAN types for 'YN' suffixes to ensure modern type safety and better integration with application-layer boolean logic.

What if a specific term is missing from the dictionary?

The skill intelligently combines individual word abbreviations from a standard word list (standard_words.json) to form a compliant compound name if a direct term match isn't found.

How does this skill handle different programming languages?

It includes a predefined mapping table that translates standard database domains into the appropriate native types for Java (JPA), TypeScript (TypeORM/Prisma), and Python (SQLAlchemy/Django).

How are primary keys and foreign keys handled?

In the application layer, an entity's own primary key is simplified to 'id', while foreign key references maintain their full prefix (e.g., customerSn) to ensure clarity in relationships.

Data Standard Terminology Mapper

Name: Data Standard Terminology Mapper
Author: ASTRA-TECHNOLOGY-COMPANY-LIMITED

byASTRA-TECHNOLOGY-COMPANY-LIMITED

0•

Gestión de Bases de Datos

Automatically enforces standardized database naming conventions and terminology across SQL, ORM entities, and migration files.

The Data Standard Terminology Mapper is a specialized Claude Code skill designed to bring rigorous consistency to database schema and application-layer code. It translates business requirements into standardized English abbreviations for physical database columns while simultaneously expanding those terms into readable, full English names for entity fields, DTOs, and VOs. By enforcing specific suffix patterns, table prefixes, and cross-language data type mappings (Java, TypeScript, Python), it ensures that your data layer remains professional, searchable, and compliant with modern architectural standards like the ASTRA methodology.

Características Principales

01Smart boolean conversion mapping legacy Y/N patterns to native BOOLEAN types with is/has prefixes

02Strict table prefixing rules (TB, TC, TH, TL, TR) for clear schema organization

030 GitHub stars

04Automated terminology translation using a standardized dictionary and word-combining logic

05Multi-language data type mapping for SQL, JPA, TypeORM, and SQLAlchemy

06Dual-layer naming conversion: abbreviated for DB columns and full English for application fields

Casos de Uso

01Writing SQL DDL and migration files that follow consistent domain-driven data type rules

02Generating production-ready JPA or TypeORM entities that match strict corporate naming standards

03Refactoring legacy database fields into descriptive, type-safe application-layer objects

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add astra-technology-company-limited/astra-methodology data-standard

For use in Claude.ai and ChatGPT

Download Skill