Apple Silicon Macs ship a built-in LLM via Apple FoundationModels. apfel exposes it as a UNIX tool and a local OpenAI-compatible server. 100% on-device. No API keys, no cloud.

In the process of creating a new project, I had to look up for databases to access basic book information. I found various articles, but mostly incomplete or outdated. I hope this 2025 updated summary will help you!