010123 multi language translations
Skill natuleadan/skills/skills/010123-multi-language-translations
Multi-domain agent skills collection for AI coding agents (Claude, Cursor, Copilot, OpenCode, and more). Covers programming, biology, cooking, and future domains. Installable via npx skills add.
npx -y skills add natuleadan/skills --skill 010123-multi-language-translationsAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
One thing to look at
- 2 stars2 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.
What its author says it does
Copied from the file, not written here
Multi-language translations — per-entity translation tables, assembler pattern (fetch all, filter in-memory), cache invalidation, and slug per locale.
The file declares its own license as MIT. That is the author’s claim about this one file, and it is not the same thing as the license GitHub reports for the repository, which is listed with the other numbers below.
SKILL.md
1.5 KB, as published. Nobody here has run it
Multi-Language Translations
When to use
When building applications that need to display content in multiple languages without hardcoding translations or using third-party services.
References
| Topic | File |
|---|---|
| Per-entity translation tables | references/translation-tables.md |
| Assembler pattern (fetch all, filter in-memory) | references/assembler-pattern.md |
| Cache invalidation across languages | references/cache-invalidation.md |
| Slug resolution per locale | references/slug-resolution.md |
| Direction from language table | references/language-direction.md |
Quick checklist
-
sys_languages: code PK, name, direction (ltr/rtl), isActive, isDefault - Per-entity
{entity}_translationstables withUNIQUE(entity_id, language_code) -
UNIQUE(slug, language_code)for per-language URL trees - Assembler: SQL JOIN all translations → in-memory
.find(lang)→ fallback to first - Cache: single key per entity (all languages bundled), tag-based invalidation
- Slug resolution:
getTranslationSlug(entity, slug, fromLang, toLang) - Direction:
sys_languages.direction→<html dir>→ DirectionProvider - FK protection:
ON DELETE RESTRICTon language_code FK