Disclaimer: Yes, this post was created with the help of AI — why not?

I’ve been experimenting with Claude Code skills lately, and one of the most practical ones I’ve built is a personal book manager. The idea is simple: instead of juggling Goodreads, spreadsheets, or sticky notes, I can just talk to Claude Code and it handles my reading list for me.

What It Does Link to heading

The books skill gives Claude Code the ability to manage a personal library backed by a local SQLite database. It tracks:

  • Title, author, genre, and year published
  • A synopsis and — crucially — my own review notes after reading
  • Tags for flexible categorisation (e.g. stoicism, philosophy, classics)
  • A priority score (1–5) so I know what to pick up next
  • Where I heard about the book (source and source_notes)

Everything lives in a books.sqlite file right inside the project folder. No cloud account, no subscription, just a file I own.

How It Works Link to heading

The skill uses SQLite FTS5 for full-text search across titles, authors, descriptions, and personal reviews. That means I can ask things like:

“Find books related to consciousness”

and it runs a proper full-text query instead of a naive LIKE '%consciousness%'.

When I add a book with just a title, Claude Code automatically searches the web to fill in the missing details — description, genre, year published, and relevant tags. It’s a small touch that saves a lot of manual lookup.

Why a Skill and Not an App? Link to heading

I could have built a web app for this. But a Claude Code skill means there’s no UI to maintain, no deployment pipeline, and no context-switching — I’m already in the terminal, so I just describe what I want in plain English and it happens. The SQLite file is portable and inspectable with any standard tool.

It’s a good example of how small, focused skills can replace category-specific apps for personal workflows. If you’re already using Claude Code day-to-day, it’s worth thinking about what else you could offload to a skill.

I can also trigger the skill via Telegram — snap a photo of a book cover or just send the title, and it updates the database right away.