메뉴
Expert assistant for managing Finnish/English content translations in the KR92 Bible Voice project. Use when syncing topic translations, managing translation cache, validating translation completeness, or importing/exporting CSV translations.
기본적으로 소스를 먼저 확인하는 Prompt가 선택됩니다. 직접 명령으로 전환하거나 로컬 사본을 다운로드할 수도 있습니다.
설치 여부를 결정하기 전에 SKILL.md와 SkillsMP에 표시된 보조 파일을 읽어 보세요.
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
직접 명령은 검토 Prompt를 거치지 않습니다. 실행하기 전에 소스를 확인하세요.
npx skills add https://github.com/Spectaculous-Code/raamattu-nyt --skill translation-sync명령은 한 줄로 유지됩니다. 복사하기 전에 가로로 스크롤해 전체 내용을 확인하세요.
로컬 사본을 원하시나요? SkillsMP에서 현재 제공할 수 있는 파일을 다운로드하세요.
Keeps documentation synchronized with code: API/architecture docs, README, CLAUDE.md, the AI index manifest (Docs/ai-index/manifest.yml — domains, task_playbooks, generated catalogues), ASCII flow diagrams, feature/system explanations, and reporting changes to the Obsidian vault. Use when (1) updating or generating docs, (2) updating the AI index / manifest ("ai index", "päivitä manifesti", "add domain/task playbook", "regenerate catalog"), (3) drawing ASCII flow/workflow diagrams ("piirrä kaavio"), (4) explaining how something works ("miten toimii", "selitä arkkitehtuuri"), or (5) reporting to Obsidian ("vault", "raportoi obsidianiin").
Manage biblical topics in Raamattu Nyt. Use for creating/editing topics + Finnish translations, topic relations (related/opposite/broader/narrower), validating FI translations & pronunciations (Voikko/Omorfi), reviewing qa_status='unchecked', bulk translation updates, aliases/synonyms, fixing mistranslated FI topic names, and the taxonomy tree (parent_id hierarchy, roots, orphans, cycles, re-parenting after merges). ALSO the structured topic schema (`structured_schema`): type templates, claims + sources, the async generation queue (/ohjaamo/topics/generation), draft review, and the Matthew Henry claim-verification pass — plus the PLANNED verse schema generated from Matthew Henry (design lives in Obsidian, not yet in code). ALSO the source corpora behind topic content — which reference work feeds which column, where the local files live (`Docs/data/`), and how to expand ISBE coverage without re-scraping. Triggers: aihe, topic, teema, taksonomia, hierarkia, alias, merge/yhdistäminen, aiheskeema, jae-skeema, str
Analyse a Bible verse's topic areas and link verses to topics in Raamattu Nyt (bible_schema.topical_references — the jae↔aihe link table). Use for: (1) tagging a single verse/passage — given a reference, find/assign its topics and insert topical_references; (2) per-book/chapter COVERAGE scans for under-tagged verses; (3) junk/QA CLEANUP of bad references (over-wide range refs, cluster bleed, wrong scope); (4) SOURCE-based rematch from easton_articles / smiths_articles to topical_references. Triggers: "tägää jae", "liitä jae aiheeseen", "jakeen aihealueet", "analysoi jakeen aiheet", "aihekattavuus", "topical_references", "roskaviite", "junk ref", "cluster bleed", "coverage gap", "Easton/Smith rematch", "verse topic tagging". Also owns (5) the VERSE SCHEMA (jae-skeema) — Matthew Henry turned into a structured Finnish exposition per outline point, and the verification of its claims against the bounded English source; triggers: "jae-skeema", "jakeiden skeema", "Matthew Henry", "rakenteinen suomennos", "structured
SKILL.md 표시 중
SOC 직업 분류 기준
| name | translation-sync |
| description | Expert assistant for managing Finnish/English content translations in the KR92 Bible Voice project. Use when syncing topic translations, managing translation cache, validating translation completeness, or importing/exporting CSV translations. |
Caches Finnish ↔ English term translations for search:
term_fi TEXT
main_term_en TEXT
synonyms_en TEXT[]
ai_main_term_en TEXT
ai_synonyms_en TEXT[]
source TEXT -- 'topic', 'ai', 'manual'
Topic names in both languages:
slug TEXT -- English slug
name_en TEXT -- English name
name_fi TEXT -- Finnish name (can be null)
slug_fi TEXT -- Finnish slug (can be null)
is_core BOOLEAN
User: "Find all topics that don't have Finnish translations"
Assistant:
-- Find topics without Finnish translation
SELECT
id,
slug,
name_en,
name_fi,
slug_fi,
CASE
WHEN name_fi IS NULL slug_fi
name_fi
slug_fi
missing_fields
bible_schema.topical_topics
name_fi slug_fi
is_core , name_en;
() total_topics,
(name_fi) translated_topics,
() (name_fi) missing_translations,
ROUND( (name_fi) (), ) percent_translated
bible_schema.topical_topics;
User: "Import topic translations from CSV file"
Assistant:
First, create CSV format:
slug,name_fi,slug_fi
forgiveness,anteeksianto,anteeksianto
grace,armo,armo
salvation,pelastus,pelastus
faith,usko,usko
love,rakkaus,rakkaus
Then, SQL to import:
-- Create temporary table for import
CREATE TEMP TABLE topic_translations_import (
slug TEXT,
name_fi TEXT,
slug_fi TEXT
);
-- Import CSV (via Supabase Dashboard or psql)
\copy topic_translations_import FROM 'translations.csv' CSV HEADER;
-- Update topics with translations
UPDATE bible_schema.topical_topics t
SET
name_fi = i.name_fi,
slug_fi = i.slug_fi
FROM topic_translations_import i
WHERE t.slug = i.slug;
-- Report on updates
SELECT
COUNT(*) as updated_count
FROM bible_schema.topical_topics t
JOIN topic_translations_import i ON t.slug = i.slug;
-- Clean up
DROP TABLE topic_translations_import;
TypeScript implementation for admin panel:
// Component for CSV import
import { useState } from "react";
import { supabase } from "@/integrations/supabase/client";
import { useToast } from "@/hooks/use-toast";
import { Button } from "@/components/ui/button";
import { Input } from "@/components/ui/input";
export const TopicTranslationImporter = () => {
const [file, setFile] = useState<File | null>(null);
const [preview, setPreview] = useState<any[]>([]);
const { toast } = useToast();
const handleFileChange = async (e: React.ChangeEvent<HTMLInputElement>) => {
const selectedFile = e.target.files?.[0];
if (!selectedFile) return;
setFile(selectedFile);
// Parse CSV for preview
const text = await selectedFile.text();
const lines = text.split('\n').filter(l => l.trim());
const headers = lines[0].split(',');
const data = lines.slice(1).map(line => {
const values = line.split(',');
return {
slug: values[0],
name_fi: values[1],
slug_fi: values[2]
};
});
setPreview(data.slice(0, 5)); // Show first 5 for preview
};
const handleImport = async () => {
if (!file) return;
try {
const text = await file.text();
const lines = text.split('\n').filter(l => l.trim());
const updates = lines.slice(1).map(line => {
const [slug, name_fi, slug_fi] = line.split(',');
return { slug, name_fi, slug_fi };
});
// Update in batches
let updated = 0;
for (const update of updates) {
const { error } = await supabase
.from('topical_topics')
.update({
name_fi: update.name_fi,
slug_fi: update.slug_fi
})
.eq('slug', update.slug);
if (!error) updated++;
}
toast({
title: "Import complete",
description: `Updated ${updated} topics`
});
} catch (error) {
toast({
title: "Import failed",
description: error.message,
variant: "destructive"
});
}
};
return (
<div className="space-y-4">
<Input
type="file"
accept=".csv"
onChange={handleFileChange}
/>
{preview.length > 0 && (
<div>
<h4>Preview (first 5 rows):</h4>
<pre className="bg-gray-100 p-2 rounded">
{JSON.stringify(preview, null, 2)}
</pre>
</div>
)}
<Button onClick={handleImport} disabled={!file}>
Import Translations
</Button>
</div>
);
};
User: "Add term translation to cache"
Assistant:
// Function to add/update term translation
async function addTermTranslation(
termFi: string,
mainTermEn: string,
synonymsEn: string[],
source: 'manual' | 'ai' | 'topic'
) {
const { data, error } = await supabase.rpc('upsert_term_translation', {
p_term_fi: termFi,
p_main_term_en: mainTermEn,
p_synonyms_en: synonymsEn,
p_source: source
});
if (error) throw error;
return data;
}
// Usage
await addTermTranslation('armo', 'grace', ['mercy', 'favor'], 'manual');
await addTermTranslation('rakkaus', 'love', ['charity', 'affection'], 'manual');
await addTermTranslation('pelastus', 'salvation', ['redemption'], 'manual');
User: "Export all topics with their translations to CSV"
Assistant:
// Export topics to CSV
async function exportTopicsToCSV() {
const { data: topics, error } = await supabase
.from('topical_topics')
.select('slug, name_en, name_fi, slug_fi, is_core')
.order('name_en');
if (error) throw error;
// Create CSV content
const headers = ['slug', 'name_en', 'name_fi', 'slug_fi', 'is_core'];
const rows = topics.map(t => [
t.slug,
t.name_en,
t.name_fi || '',
t.slug_fi || '',
t.is_core ? 'true' : 'false'
]);
const csv = [
headers.join(','),
...rows.map(row => row.map(cell => `"${cell}"`).join(','))
].join('\n');
// Download file
const blob = new Blob([csv], { type: 'text/csv' });
const url = URL.createObjectURL(blob);
const a = document.createElement('a');
a.href = url;
a.download = `topics-export-${new Date().toISOString().split('T')[0]}.csv`;
a.click();
URL.revokeObjectURL(url);
}
// Component
import { Button } from "@/components/ui/button";
import { Download } from "lucide-react";
export const TopicExporter = () => {
return (
<Button onClick={exportTopicsToCSV} variant="outline">
<Download className="h-4 w-4 mr-2" />
Export Topics CSV
</Button>
);
};
User: "Check translation quality and completeness"
Assistant:
-- Translation Quality Report
WITH stats AS (
SELECT
COUNT(*) as total,
COUNT(name_fi) as has_fi_name,
COUNT(slug_fi) as has_fi_slug,
COUNT(CASE WHEN name_fi IS NOT NULL AND slug_fi IS NOT NULL THEN 1 END) as fully_translated,
COUNT(CASE WHEN is_core = true THEN 1 END) as total_core,
COUNT(CASE WHEN is_core = true AND name_fi IS NOT NULL THEN 1 END) as core_translated
FROM bible_schema.topical_topics
)
SELECT
total as "Total Topics",
fully_translated as "Fully Translated",
has_fi_name as "Has Finnish Name",
has_fi_slug as "Has Finnish Slug",
total_core as "Core Topics",
core_translated as "Core Translated",
ROUND(100.0 * fully_translated / total, 2) || '%' as "Completion %",
ROUND(100.0 * core_translated / total_core, 2) || '%' as "Core Completion %"
FROM stats;
-- Find problematic translations
SELECT
slug,
name_en,
name_fi,
slug_fi,
is_core,
CASE
WHEN name_fi IS NULL THEN 'Missing Finnish name'
WHEN slug_fi IS NULL THEN 'Missing Finnish slug'
WHEN LENGTH(name_fi) < 2 THEN 'Finnish name too short'
WHEN name_fi = name_en THEN 'Not translated (same as English)'
ELSE 'OK'
END as issue
FROM bible_schema.topical_topics
WHERE
name_fi IS NULL
OR slug_fi IS NULL
OR LENGTH(name_fi) < 2
OR name_fi = name_en
ORDER BY is_core DESC, name_en;
# Export topics for translation
SELECT slug, name_en, name_fi, slug_fi
FROM bible_schema.topical_topics
WHERE name_fi IS NULL
ORDER BY is_core DESC, name_en;
-- Via CSV import (see Example 2)
-- Check for issues after import
SELECT COUNT(*) FROM bible_schema.topical_topics WHERE name_fi IS NULL;
SELECT COUNT(*) FROM bible_schema.topical_topics WHERE slug_fi IS NULL;
Use Edge Function for batch translation:
// Edge Function: topic-translations
async function batchTranslateTopics(topics: string[]) {
const results = [];
for (const topic of topics) {
const { data } = await supabase.functions.invoke('translate-search-term', {
body: {
term: topic,
direction: 'en-fi',
forceAI: true
}
});
results.push({
original: topic,
translated: data.translated
});
}
return results;
}
| English | Finnish | Slug |
|---|---|---|
| Grace | Armo | armo |
| Faith | Usko | usko |
| Love | Rakkaus | rakkaus |
| Salvation | Pelastus | pelastus |
| Forgiveness | Anteeksianto | anteeksianto |
| Hope | Toivo | toivo |
| Prayer | Rukous | rukous |
| Worship | Ylistys | ylistys |
The translations can be managed via:
AdminTopicsPage - Topic translationsAdminTranslationsPage - Term translationsSee Docs/07-ADMIN-GUIDE.md for admin panel usage.
Docs/07-ADMIN-GUIDE.md for admin featuresDocs/03-API.md for term_translations tableDocs/06-AI-ARCHITECTURE.md for AI translation