Bible Lookup Helper Skill

Bible Lookup Helper

Context Files (Read First)

For schema and API details, read from Docs/context/:

Docs/context/db-schema-short.md - Bible schema tables
Docs/context/supabase-map.md - RPC functions list

Capabilities

Generate correct RPC function calls for Bible lookups
Validate OSIS reference formats
Suggest optimal lookup patterns (verse vs chapter vs range)
Provide book name aliases and normalization
Convert between different reference formats

Usage Examples

Example 1: Generate RPC call for single verse

User: "How do I fetch John 3:16 in Finnish?" Assistant:

const { data } = await supabase.rpc('get_verse_by_ref', {
  p_ref_book: 'John',
  p_chapter: 3,
  p_verse: 16,
  p_version_code: 'finstlk201',
  p_language_code: 'fi'
});

Example 2: Generate RPC call for chapter

User: "Get all verses from Genesis chapter 1" Assistant:

const { data: verses } = await supabase.rpc('get_chapter_by_ref', {
  p_ref_book: 'Genesis',
  p_chapter: 1,
  p_version_code: 'finstlk201',
  p_language_code: 'fi'
});

Example 3: Validate reference format

User: "Is '1. Joh.4:8' a valid reference?" Assistant: Yes, this is valid. It follows the Finnish format for numbered books:

Book: 1. Johannes (1 John)
Chapter: 4
Verse: 8

Alternative valid formats:

1 Joh.4:8 (without period after number)
1.Joh.4:8 (no space)
1 John 4:8 (English)

Example 4: Convert reference formats

User: "Convert 'Joh.3:16' to OSIS format" Assistant: OSIS format: John.3.16

Finnish formats accepted:

Joh.3:16 (with colon)
Joh.3.16 (with period)
Johannes 3:16 (full name)

Available RPC Functions

Single Verse

get_verse_by_ref(p_ref_book, p_chapter, p_verse, p_version_code, p_language_code)
→ {osis, text_content, verse_id}

Full Chapter

get_chapter_by_ref(p_ref_book, p_chapter, p_version_code, p_language_code)
→ [{book_code, book_name, chapter_number, verse_number, osis, text_content, verse_id, version_code}]

Verse Range

get_verses_by_ref(p_ref_book, p_chapter, p_verses[], p_version_code, p_language_code)
→ Same as chapter but filtered

Verse Study (with Strong's)

get_verse_study_data(p_version_code, p_book_name, p_chapter, p_verse)
→ Full study data including KJV Strong's tags

Text Search

search_text(p_query, p_version_code, p_limit)
search_text_extended(p_query, p_version_code, p_limit)
→ [{book_name, chapter_number, verse_number, osis, text_content, verse_id}]

Supported Bible Versions

| Code | Name | Language | |------|------|----------| | finstlk201 | Pyhä Raamattu (STLK 2017) - DEFAULT | Finnish | | finpr_finn | Pyhä Raamattu (1933/1938) | Finnish | | KJV | King James Version with Strong's | English |

Book Name Aliases

The system recognizes multiple formats:

Finnish: Joh, Johannes, Johanneksen evankeliumi
English: John, Jn, Gospel of John
Numbered books: 1. Joh, 1 Joh, 1Joh, 1 John
Moses books: 1. Moos, 1 Moos, Gen, Genesis

Best Practices

Always use RPC functions - Never query tables directly
Default version - Use finstlk201 for Finnish content
Cache results - Use React Query to cache lookups
Preload - Load next chapter for better UX
Error handling - Check for empty results
OSIS format - Use for cross-version references

Performance Tips

Single verse: ~20ms
Full chapter: ~50ms
Text search: ~100ms
Use indexed fields for best performance
Limit search results with p_limit parameter

Agent Skills: Bible Lookup Helper

Install this agent skill to your local

Skill Files