skills.rest
Spectaculous-Code
Spectaculous-CodeOFFICIAL
Explore all skills by this author →
GitHub

translation-sync

Syncs Finnish and English Bible topic and term translations via SQL and TypeScript.

Updated Dec 19, 2025
Search Tags:#content management#localization#translation#english#bible#finnish
One-click install
npx skills add https://github.com/Spectaculous-Code/raamattu-nyt --skill translation-sync-spectaculous-code
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: translation-sync
Source: https://github.com/Spectaculous-Code/raamattu-nyt/tree/main/.claude/skills/translation-sync
Command: npx skills add https://github.com/Spectaculous-Code/raamattu-nyt --skill translation-sync-spectaculous-code

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) and scripts (resource) components.

What problem does it solve?

This Skill streamlines the process of managing and synchronizing Finnish and English translations for Bible topics and terms, ensuring consistency and completeness across the application.

Core Features & Use Cases

  • Topic Translation Management: Sync topic names and slugs between Finnish and English.
  • Term Translation Cache: Manage AI-generated and manual translations for specific terms.
  • Validation & Export/Import: Validate translation completeness and bulk update translations via CSV.
  • Use Case: A content manager needs to add new theological topics to the app. They can use this Skill to export a list of untranslated topics, get them translated, and then import the Finnish versions back into the database, ensuring all core topics are available in both languages.

Quick Start

Use the translation-sync skill to find all topics that do not have Finnish translations.

Frequently Asked Questions about translation-sync

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I sync Finnish and English Bible topic translations in a database?▼

To sync Finnish and English Bible topic translations, this Skill syncs topic names and slugs by updating the topical_topics database table, ensuring both language versions match using SQL queries and TypeScript.

How do I export and import CSV translation data for bulk content updates?▼

You can export untranslated topics to a CSV file, get them translated, and import the updated Finnish versions back into the database to bulk update term_translations and topical_topics records.

Can I validate translation completeness for English and Finnish content?▼

Yes, you can validate translation completeness by checking the term_translations and topical_topics tables for missing English or Finnish entries, ensuring all theological terms and topics are available.

Does this translation sync tool work without external dependencies?▼

Yes, this Skill operates independently without external dependencies, using internal scripts and references to manage AI-generated and manual translations directly in your database.

How do I manage the term translation cache for AI-generated content?▼

You manage the term translation cache by updating the term_translations database table, allowing you to store, modify, and sync AI-generated and manual translations for specific terms.

What is the best way to add new localized topics to a bilingual application?▼

The best way to add localized topics is to export untranslated topic lists, translate the content, and import the Finnish versions back into the database to sync topical_topics records.

Related Skills

Explore More Content & Communication Skills→
benjaminwesternbenjaminwestern
3

duckdb

Query, transform, and analyze CSV, Parquet, and JSON files with SQL.

Community
Intermediate
githubgithub
37.6k

vscode-ext-localization

Localize VS Code extension resources across languages in package.json, walkthroughs, and code messages.

Official
Basic
alceupassosalceupassos

cli

Manage LobeHub services and automate tasks via command-line interface using Bun and Node.js.

Community
Advanced
SkylerCookSkylerCook

i18n-bdp-trans-seed

Generate multilingual translation term tables and SQL scripts for dictionary storage.

Community
Intermediate