Org-roam uses a SQLite database to perform caching. This integration is managed by the emacsql library. It should “just work”.