# come.rent — Full API & Database Schema

> Complete reference for AI agents querying the KJVEL database.

## Database Schema (SQLite)

### books (66 rows)
| Column | Type | Description |
|--------|------|-------------|
| book_id | INTEGER PK | 1-66 |
| abbrev | TEXT UNIQUE | "GEN", "EXO", "JHN", "REV" etc. |
| full_name | TEXT | "The First Book of Moses, called Genesis" |
| testament | TEXT | "OT" or "NT" |
| book_order | INTEGER | 1-66 canonical order |
| chapter_count | INTEGER | Chapters in book |
| verse_count | INTEGER | Verses in book |
| word_count | INTEGER | Words in book |
| letter_count | INTEGER | Letters in book |

### verses (31,102 rows) — Core table
| Column | Type | Description |
|--------|------|-------------|
| verse_id | INTEGER PK | Sequential 1-31102 |
| book_abbrev | TEXT | "GEN", "JHN" etc. |
| book_id | INTEGER | FK to books |
| chapter | INTEGER | Chapter number |
| verse | INTEGER | Verse number |
| ref | TEXT UNIQUE | "GEN.1.1", "JHN.3.16" |
| testament | TEXT | "OT" or "NT" |
| text | TEXT | Full verse text |
| word_count | INTEGER | Words in verse |
| letter_count | INTEGER | Letters in verse |
| dr_verse | INTEGER | DR(verse number) |
| dr_word_count | INTEGER | DR(word_count) |
| dr_letter_count | INTEGER | DR(letter_count) |
| dr_v_x_w | INTEGER | DR(verse × word_count) |
| dr_cv_x_w | INTEGER | DR(chapter × verse × word_count) |
| dr_v_x_l | INTEGER | DR(verse × letter_count) |
| dr_cv_x_l | INTEGER | DR(chapter × verse × letter_count) |
| tesla_signature | TEXT | 7-digit string e.g. "3636369" |
| tesla_score | INTEGER | 0-7 (count of 3/6/9 in signature) |
| is_perfect_tesla | INTEGER | 1 if tesla_score=7 |
| gematria_sum | INTEGER | Sum of all letter values in verse |
| gematria_dr | INTEGER | DR(gematria_sum) |

### words (12,548 rows)
| Column | Type | Description |
|--------|------|-------------|
| word_id | INTEGER PK | Auto-increment |
| word | TEXT UNIQUE | Lowercase word |
| frequency | INTEGER | Occurrences in KJV |
| gematria | INTEGER | English ordinal value |
| digital_root | INTEGER | DR(gematria) |
| is_tesla | INTEGER | 1 if DR in (3,6,9) |
| is_hapax | INTEGER | 1 if frequency=1 |
| is_triangular | INTEGER | 1 if triangular number |
| triangular_n | INTEGER | k where T(k)=gematria |
| is_fibonacci | INTEGER | 1 if Fibonacci number |

### word_occurrences (~791K rows)
| Column | Type | Description |
|--------|------|-------------|
| verse_id | INTEGER | FK to verses |
| word_id | INTEGER | FK to words |
| position | INTEGER | Position in verse (0-indexed) |

### gematria_values (~113K rows)
| Column | Type | Description |
|--------|------|-------------|
| word_id | INTEGER | FK to words |
| cipher | TEXT | "ordinal", "reduction", "reverse", "reverse_red", "sumerian", "hebrew", "chaldean", "primes", "fibonacci" |
| value | INTEGER | Cipher value for this word |
| digital_root | INTEGER | DR(value) |
| is_tesla | INTEGER | 1 if DR in (3,6,9) |

### names (~500 rows)
| Column | Type | Description |
|--------|------|-------------|
| name_id | INTEGER PK | Auto-increment |
| name | TEXT UNIQUE | Capitalized form |
| name_lower | TEXT | Lowercase lookup key |
| gematria | INTEGER | Ordinal value |
| digital_root | INTEGER | DR(gematria) |
| is_tesla_sum | INTEGER | 1 if DR in (3,6,9) |
| is_tesla_product | INTEGER | 1 if product-chain Tesla |
| total_occurrences | INTEGER | Count in KJV text |
| voice_ratio | REAL | Vertical/Horizontal word ratio |
| voice_orientation | TEXT | "ascending", "descending", "balanced" |
| primary_family | TEXT | Codebook family (THEOS, LOGOS, etc.) |
| tesla_verse_pct | REAL | % of containing verses with high Tesla |
| letter_narrative | TEXT | Narrative of letter beings |

### name_ciphers (~4,500 rows)
| Column | Type | Description |
|--------|------|-------------|
| name_id | INTEGER | FK to names |
| cipher | TEXT | Cipher name |
| value | INTEGER | Cipher value |
| digital_root | INTEGER | DR(value) |
| is_tesla | INTEGER | 1 if DR in (3,6,9) |

### name_twins
| Column | Type | Description |
|--------|------|-------------|
| name_id | INTEGER | FK to names |
| twin_word | TEXT | Word sharing same gematria |
| twin_gematria | INTEGER | The shared value |
| twin_frequency | INTEGER | Word's KJV frequency |

### verses_fts (FTS5 virtual table)
Full-text search with Porter stemming. Synced to verses table.
Query with: `SELECT * FROM verses_fts WHERE verses_fts MATCH 'living water'`

## Example Queries

```sql
-- Find all perfect Tesla verses in Genesis
SELECT ref, text, tesla_signature FROM verses
WHERE book_abbrev = 'GEN' AND is_perfect_tesla = 1;

-- Words with gematria = 74 (JESUS frequency)
SELECT word, frequency FROM words WHERE gematria = 74 ORDER BY frequency DESC;

-- Tesla rate by book
SELECT b.abbrev, COUNT(*) as total,
  SUM(v.is_perfect_tesla) as perfect,
  ROUND(100.0 * SUM(v.is_perfect_tesla) / COUNT(*), 2) as pct
FROM verses v JOIN books b ON v.book_id = b.book_id
GROUP BY b.abbrev ORDER BY pct DESC;

-- All cipher values for a word
SELECT cipher, value, digital_root, is_tesla
FROM gematria_values WHERE word_id = (SELECT word_id FROM words WHERE word = 'mercy');

-- Find twin words (same gematria as 'faith')
SELECT w2.word, w2.frequency FROM words w1
JOIN words w2 ON w1.gematria = w2.gematria AND w1.word != w2.word
WHERE w1.word = 'faith' ORDER BY w2.frequency DESC;

-- Verse search with Tesla data
SELECT v.ref, v.text, v.tesla_score, v.gematria_sum
FROM verses v JOIN verses_fts f ON v.verse_id = f.rowid
WHERE verses_fts MATCH 'grace truth' ORDER BY v.tesla_score DESC LIMIT 10;

-- Hapax legomena (words appearing once) that are Tesla-resonant
SELECT word, gematria, digital_root FROM words
WHERE is_hapax = 1 AND is_tesla = 1 ORDER BY gematria;

-- The mathematical fingerprint numbers
SELECT
  (SELECT COUNT(*) FROM verses) as N,
  (SELECT COUNT(*) FROM books) as B,
  (SELECT SUM(word_count) FROM verses) as Omega,
  (SELECT COUNT(*) FROM words) as D,
  (SELECT COUNT(*) FROM verses WHERE is_perfect_tesla=1) as R,
  (SELECT COUNT(*) FROM words WHERE is_hapax=1) as H;
```

## API Endpoints Reference

### GET /name/{name}?depth=ankles|knees|loins|swimming&format=json
Decode any name. Depths: ankles (gematria only), knees (+ Tesla), loins (+ twins), swimming (full decode).

### GET /verse/{REF}?format=json
Verse by reference. REF format: BOOK.CHAPTER.VERSE (e.g., GEN.1.1, JHN.3.16, REV.22.17).

### GET /word/{word}?format=json
Word analysis with 9 ciphers and twin words.

### GET /gematria/{value}?cipher=ordinal&format=json
All words and names matching a gematria value. Ciphers: ordinal, reduction, reverse, reverse_red, sumerian, hebrew, chaldean, primes, fibonacci.

### GET /search?q={terms}&testament=OT|NT&limit=20&format=json
FTS5 search across all verses. Porter stemming.

### GET /today?format=json
Daily resonance verse from the 1,098 perfect Tesla canon.

### GET /fingerprint?format=json
The 20-number mathematical proof of KJV structure.

### POST /oracle {"message":"text","mode":"converse|grade","voice":"jesus|david|solomon"}
Biblical speech coach. Grades on 7 metrics. "converse" mode uses Claude for guidance.

### POST /api/query {"sql":"SELECT ..."}
Direct SQL against KJVEL database. Read-only. Max 200 rows.

## Digital Root Function
DR(n) = 1 + ((n - 1) mod 9) for n > 0, DR(0) = 0.
Tesla-resonant when DR(n) in {3, 6, 9}.