jobe-skills/ebook-library
Use when the user asks about a Calibre ebook library or book collection: find books, search metadata or full text in EPUB/AZW3 files, or locate book paths via Calibre databases.
100
1.35x
Quality
100%
Does it follow best practices?
Impact
100%
1.35xAverage score across 3 eval scenarios
calibre-schema.mdreferences/
Calibre Database Schema Reference
metadata.db
books
| Column | Type | Description |
|---|---|---|
| id | INTEGER | Primary key |
| title | TEXT | Book title |
| sort | TEXT | Sort key |
| path | TEXT | Relative path from library root |
| author_sort | TEXT | Author name for sorting |
| has_cover | BOOL | Cover image exists |
| uuid | TEXT | Unique identifier |
authors
| Column | Type |
|---|---|
| id | INTEGER |
| name | TEXT |
books_authors_link
| Column | Type |
|---|---|
| book | INTEGER |
| author | INTEGER |
data (file formats)
| Column | Type | Description |
|---|---|---|
| id | INTEGER | Primary key |
| book | INTEGER | FK to books |
| format | TEXT | EPUB, PDF, AZW3, etc. |
| name | TEXT | Filename without extension |
Other tables
series,books_series_link- Series infotags,books_tags_link- Tags/categoriespublishers,books_publishers_link- Publisherscomments- Book descriptionsidentifiers- ISBN, etc.
full-text-search.db
books_text (content table)
| Column | Type | Description |
|---|---|---|
| id | INTEGER | Primary key |
| book | INTEGER | FK to metadata.db books |
| format | TEXT | Source format |
| searchable_text | TEXT | Full extracted text |
books_fts (FTS5 virtual table)
Uses Calibre's custom tokenizer - not usable outside Calibre.
Query books_text directly with LIKE for content search.
Path Resolution
Full path to a book file:
{library_root}/{books.path}/{data.name}.{data.format.lower()}Example:
/path/to/Calibre Library/Ted Dunning/Practical Machine Learning (915)/Practical Machine Learning - Ted Dunning.pdf