SQL LRS
An xAPI learning record store that runs on SQLite or your existing SQL database
The facts
- Licence
- Apache-2.0 — OSI approved
- Pricing
- Open source
- Deployment
- Self-hosted
- Platforms
- Linux · Windows · macOS · Web
- Vendor
- Yet Analytics, Inc.
- Headquarters
- United States
Standards support
Every line says where the claim came from. We do not test conformance ourselves and we issue no badge of our own.
| Standard | Supported | Provenance | Checked | Note |
|---|---|---|---|---|
| SCORM 1.2 | No | editor-checked · 24 Aug 2026 | — | |
| SCORM 2004 | No | editor-checked · 24 Aug 2026 | — | |
| xAPI | Yes | editor-checked · 24 Aug 2026— source, opens in a new tab | Supports xAPI 1.0.3 and 2.0.0, selected per request by the X-Experience-API-Version header. The repository's own test suite runs the ADL LRS conformance suite against a live instance for both versions, so the claim is checkable rather than asserted. | |
| cmi5 | No | editor-checked · 24 Aug 2026 | There is no cmi5 code in the repository. An LRS is a prerequisite for cmi5 and will happily store the statements a cmi5 course sends, but the launch side — fetch URL, AU session state, move-on evaluation — is not here and needs a separate cmi5 launcher. | |
| AICC | Not stated | — | — | — |
| LTI | Not stated | — | — | — |
- Claimed
- — the vendor states it. We have not confirmed it.
- Checked
- — an editor confirmed it on the date shown.
- Verified
- — an official registry lists it, and we link to the entry.
Editor's notes
SQL LRS is the sensible default for anyone who needs a learning record store and does not want to buy one. The design decision that distinguishes it is in the name: statements go into an ordinary SQL database — SQLite, Postgres, MySQL or MariaDB — rather than a document store or a proprietary engine. That means your existing backup, replication, monitoring and reporting practice applies unchanged, and any analyst who can write SQL can query the data without an API key.
It is well suited to two quite different jobs. As a development LRS it runs on SQLite from a single binary, which makes it practical to keep one on a laptop while building xAPI content. As a production store it deploys via Docker or a JAR, supports OIDC for admin authentication, and has documented AWS deployment patterns.
What it is not is an analytics product. There are no dashboards to speak of, no learner-facing reporting, and no course-authoring anything. Nor is it a cmi5 system: it will store cmi5 statements, but launching AUs is somebody else's code.
Maintenance is strong. v0.9.8 shipped in August 2026, and the project runs the ADL conformance suite against both xAPI 1.0.3 and 2.0.0 in its own CI — a level of self-verification that is rare here and the main reason to trust its standards claims.
Listed on scorm-tools.com
Maintainers and vendors are welcome to show the listing badge in a README or on a product page. It is free, it does not require a claim, and there is nothing to buy.
Get the embed code