SQL LRS review
A capable free LRS for teams comfortable running their own xAPI infrastructure.
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
SQL LRS is an open-source Learning Record Store for receiving, validating, storing, and exposing xAPI statements, attachments, and documents. It is aimed at developers, data engineers, learning engineers, government, education, and enterprise teams that need control over learning-data infrastructure. The web administration interface supports credential management, statement browsing, monitoring, authentication, and API scope management. OpenID Connect authentication is also supported, alongside configurable reactions for conditional logic and generated xAPI statements.
The Community / Open Source plan is Apache 2.0 licensed, self-hosted, and backed by SQL storage. Deployment options include SQLite, PostgreSQL, MariaDB, and MySQL, giving teams flexibility to align the LRS with an existing database environment. SQL LRS supports xAPI 1.0.3 and 2.0.0, stores attachments and documents, and provides CSV statement downloads. Its ecosystem also connects with Apache Superset, Microsoft Power BI, Tableau, and Looker, making it suitable for teams that plan to analyze learning records in established business-intelligence tools.
The main trade-off is operational ownership: SQL LRS is self-hosted rather than vendor-hosted, so the adopting team is responsible for deployment and ongoing infrastructure management. It also lacks multitenancy, which limits its fit for organizations needing separated tenant environments in one system. Separate implementation and support contracts are available, but the product's core positioning remains a free, open-source deployment. Choose SQL LRS when xAPI compatibility, database choice, export access, and direct control matter most. Consider another LRS when managed hosting or multitenant administration is a requirement.
SQL LRS pros and cons
- Where it wins
- Supports xAPI 1.0.3 and 2.0.0 with attachments and documents
- Connects to SQLite, PostgreSQL, MariaDB, and MySQL
- Exports statements to CSV and supports BI integrations
- Where it doesn't
- Requires self-hosted deployment and infrastructure management
- Does not provide multitenant capabilities
- Implementation and support are handled through separate contracts
SQL LRS fact sheet, pricing and score →
Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. Bought places stand at the number bought; this page and our disclosure say so. Paying vendors may get a fuller, more detailed review from our editors, and that review can change their score. How we rank.
Last updated · How we research and update