cli-sqlite-only-commands-exist

IN premise

Commands `derive`, `ask`, `review-beliefs`, `deduplicate`, and `contradictions` are guarded by `_require_sqlite()` and exit with an error if `--pg` is set — they do not support PostgreSQL

Summary

Several CLI commands that perform LLM-powered reasoning operations only work with the local SQLite backend. If you try to run derive, ask, review-beliefs, deduplicate, or contradictions against a PostgreSQL database, they will refuse to execute. This means these higher-level analytical features are unavailable in any deployment that uses PostgreSQL as its storage layer.

Details

Sourceentries/2026/05/11/reasons_lib-cli.md