SQL LRS
SQL LRS is a self-hosted Learning Record Store for storing xAPI statements, attachments and documents.
What SQL LRS is
SQL LRS is a self-hosted Learning Record Store for storing xAPI statements, attachments and documents. It supports SQLite, Postgres, MariaDB and MySQL, and its built-in conditional logic can assess incoming activity and create internal xAPI statements for validated outcomes. SQL data can connect to analytics tools such as Power BI, Tableau, Looker and Apache Superset, as well as AI stacks that work with structured databases. Authentication options include OpenID and API credentials with keys, secrets and scopes. SQL LRS is available through GitHub, DockerHub and Platform One’s Iron Bank, but customers host their deployments themselves. The software is free under the Apache 2.0 license and may be used in commercial projects; implementation and support services are quoted separately. The maker says it conforms to IEEE 9274.1.1. SQL LRS is an LRS, not an LMS or content store: it does not create learning data or host learning content. Described use cases include collecting activity from LMS, AR/VR/XR and simulation systems, and exchanging learning data with business and AI systems.
Good
- Supports four listed database systems.
- Conditional logic can generate statements for validated outcomes.
- Lists Apache Superset and other analytics connections.
- Apache 2.0 license permits commercial use.
- Free software with self-hosted deployment options.
Watch out
- Customers must host the deployment themselves.
- It does not host learning content.
- It does not itself produce learning data.
- Implementation and support services are quoted separately.
Who it suits
SQL LRS may suit organizations that need to collect or exchange xAPI learning data and can host the software themselves. It may also fit teams connecting structured learning records to BI or AI systems.
Verdict
SQL LRS is a free, self-hosted option focused on storing and working with xAPI records. It is not a substitute for an LMS or content store, and service contracts are separate from the software.
Plans and prices
From SQL LRS's own pricing page, checked 30 Sep 2001.
| Plan | Price | What it gives you |
|---|---|---|
| SQL LRS | Free | Apache 2.0 open source · self-hosted · implementation and support services quoted separately |
| Open source | Free | Apache 2.0 license · self-hosted · SQL-backed xAPI storage · Always free |
The facts
Each one read from SQL LRS's own pages, with the date it was checked.
What it does
- AI data preparation
- The maker positions SQL LRS as preprocessing learning data into structured signals for analytics and AI systems.checked 15 Oct 2001
- Analytics connections
- The maker says SQL data can be used with tools such as Power BI, Tableau, Looker, and AI stacks that work with structured databases.checked 30 Sep 2001
- API scopes
- OIDC resource scopes include full access, read-only access, state documents, activity profiles and agent profiles, while admin functions use an admin scope.checked 15 Oct 2001
- Archived external fork
- The ADLNet SQL-LRS repository was archived on March 5, 2026 and is read-only, and it identifies itself as forked from Yet Analytics.checked 15 Oct 2001
- Authentication
- SQL LRS supports OpenID Connect over OAuth 2.0 for xAPI endpoints and administrative functions.checked 15 Oct 2001
- AWS deployment
- The documentation index links an example AWS deployment and CloudFormation material.checked 15 Oct 2001
- BI integrations
- Yet Analytics names Power BI, Tableau, Looker, Apache Superset and Grafana as tools that can connect through SQL.checked 15 Oct 2001
- Conditional logic
- Yet Analytics says SQL LRS includes an onboard conditional-logic engine that preprocesses incoming activity data.checked 15 Oct 2001
- CORS caveat
- The documentation says allowAllOrigins is permissive for testing and should be replaced with stricter CORS settings in deployed systems.checked 15 Oct 2001
- Database persistence
- The Docker instructions persist the SQLite database through a named Docker volume and allow mounted configuration, authority templates and TLS certificates.checked 15 Oct 2001
- Database support
- The documentation lists SQLite, Postgres, MariaDB, and MySQL support.checked 30 Sep 2001
- Deployment
- SQL LRS is available through GitHub, DockerHub, and Platform One’s Iron Bank, and customers host it themselves.checked 30 Sep 2001
- Deployment model
- The maker says customers host SQL LRS themselves and that Yet Analytics does not provide a hosted service.checked 15 Oct 2001
- Docker distribution
- Yet Analytics publishes Docker images named yetanalytics/lrsql with versioned and latest tags.checked 15 Oct 2001
- Documentation depth
- The documentation covers startup, TLS/HTTPS, authority configuration, Docker, OIDC, database-specific setup, configuration variables, HTTP endpoints, developer documentation, reactions, JSON specification, Postman and xAPI versioning.checked 15 Oct 2001
- Funding disclosure
- Crunchbase shows two seed funding rounds and seven investors, but the funding amounts are obscured on the public page.checked 15 Oct 2001
- Generated statements
- The product can evaluate activity streams and generate internal xAPI statements representing derived outcomes.checked 15 Oct 2001
The company
- Company founders
- Crunchbase names Rose Burt and Shelly Blake-Plock as founders.checked 15 Oct 2001
- Company founding
- LinkedIn lists Yet Analytics, Inc. as founded in 2014.checked 15 Oct 2001
- Company headquarters
- LinkedIn gives the headquarters as Savage, Maryland, United States.checked 15 Oct 2001
- Company size
- LinkedIn lists Yet Analytics, Inc. as having 11-50 employees.checked 15 Oct 2001
- Company status
- Crunchbase lists Yet Analytics, Inc. as an active, privately held, for-profit company.checked 15 Oct 2001
- Founded
- 2014checked 28 Sep 2001
- Headquarters
- Savage, Maryland, USAchecked 28 Sep 2001
The full review of SQL LRS
SQL LRS is a self-hosted Learning Record Store for teams collecting xAPI activity from learning systems, simulations, or immersive experiences. It is strongest when you want records in a SQL database you control and can connect to analytics tools; the cost is that your organization must host it.
Overview
SQL LRS stores xAPI statements, attachments, and documents. Its conditional logic can assess incoming activity and create internal statements for outcomes that meet defined conditions, making it more than a passive repository. It can help organizations bring learning activity into wider business or AI data workflows, but it does not generate learning data or deliver courses.
The software is Apache 2.0 licensed and available through GitHub, DockerHub, and Platform One’s Iron Bank. Customers run it themselves. Implementation and support services can be arranged separately through Yet Analytics, with quotes for deployments of any size.
Key features
SQL storage and analytics
Documentation lists SQLite, Postgres, MariaDB, and MySQL support. That choice can suit teams with an existing SQL environment and makes structured records usable with tools such as Power BI, Tableau, Looker, and compatible AI stacks. Apache Superset is also supported, with a visualization demo. The trade-off is operational: self-hosting gives control over deployment but leaves hosting to the customer.
Rules, access, and standards
Conditional logic evaluates incoming activity and can produce internal xAPI statements for validated outcomes. OpenID authentication and API credentials with keys, secrets, and scopes support controlled access. SQL LRS conforms to IEEE 9274.1.1. Its Iron Bank containers are certified for deployment in Platform One IL2 and IL4 environments, a relevant option for organizations using those environments.
Export and tenancy
Records can be exported as CSV. Multi-tenant support is not included, so organizations needing tenant separation within one service should consider that constraint before choosing SQL LRS.
Pricing
SQL LRS: free. The plan is Apache 2.0 open source and self-hosted; implementation and support services are quoted separately. There is no paid hosted tier described, so the price of the software does not remove the work or potential service cost of operating a deployment. This fits teams able to manage their own infrastructure; teams seeking a managed service or included support should compare alternatives.
Platforms
SQL LRS supports API, Linux, macOS, web, and Windows environments, and is self-hosted. The deployment options make it suitable for organizations choosing their own runtime rather than looking for a turnkey hosted LRS.
Who it's for
SQL LRS fits organizations collecting activity from LMSs, AR/VR/XR experiences, and simulations, especially when learning records need to be queried alongside other SQL data or exchanged with business and AI systems. It is a poor fit as a standalone course platform: it is neither an LMS nor a content store, and it does not create the activity data it stores.
Pros and cons
- Pros: Free, Apache 2.0 software can be self-hosted and used in commercial projects.
- Pros: Four documented SQL database options and connections to common BI and structured-data AI tools support flexible analysis.
- Pros: Conditional logic can turn validated activity into internal xAPI statements.
- Cons: Customers are responsible for hosting; support and implementation are separate quoted services.
- Cons: It does not provide course content or LMS functions, and it has no multi-tenant support.
Alternatives
For a broader comparison, see Learning Record Store Software.
- Veracity Learning is worth comparing if you want a free Lite option capped at five LRSs, based on your infrastructure.
- Cluelabs LRS offers a free plan and lists Android and iOS alongside API and web platforms.
- Mosra has a free launch period with unlimited lessons and listed features and exports; paid plans are planned but not live.
- GrassBlade LRS is a paid option whose Lite plan costs $12 a year and includes 5,000 statements per month, one instance, and a $7 overage fee per 1,000 statements.
- ADL Open Source LRS is a free proof-of-concept option intended for a small number of users.
- Ralph is a free, MIT-licensed open-source alternative distributed as a Python package and Docker image.
- Sereni LRS has a free plan with up to 100,000 xAPI statements or events, 1 GB of storage, and unlimited LRSs, reporting, and analytics.
- Jupiter offers a hosted LRS option with a free allowance of up to one million events per year.
Verdict
Choose SQL LRS if you need a standards-conformant, commercially usable LRS that you can host in your own SQL environment and connect to analytics workflows. Its free license and database flexibility are compelling for capable infrastructure teams. Look elsewhere if you need a hosted service, multi-tenant support, or software that also delivers learning content and courses.
Getting started
- Choose a deployment route through GitHub, DockerHub, or Platform One’s Iron Bank.
- Host the deployment in your own environment.
- Configure a supported database: SQLite, Postgres, MariaDB, or MySQL.
- Set up OpenID authentication or API credentials with keys, secrets, and scopes.
- Contact Yet Analytics for an implementation or support service quote if needed.
Limits worth knowing
The free SQL LRS plan is self-hosted, and the product is an LRS rather than an LMS or content store. Implementation and support services are quoted separately.
Questions
How much does SQL LRS cost?
The SQL LRS plan is free. Implementation and support services are quoted separately.
Is SQL LRS open source?
Yes. It is distributed under the Apache 2.0 license, which permits use in commercial projects.
Where can I deploy SQL LRS?
It is available through GitHub, DockerHub, and Platform One’s Iron Bank. Customers host deployments themselves.
Which databases does it support?
The documentation lists SQLite, Postgres, MariaDB, and MySQL.
Can SQL LRS host courses or learning content?
No. It is a Learning Record Store, not an LMS or content store, and does not produce learning data or host learning content.
What analytics connections are listed?
SQL data can be used with Power BI, Tableau, Looker, Apache Superset, and AI stacks that work with structured databases.
Alternatives to SQL LRS
- 1
xh
Free planOpen sourceAndroidLinuxmacOSWindows7.6Free plan - 2
Cluelabs LRS
Free planAndroidiOSWebAPI7.2From $19.95 a month - 3
Veracity Learning
Free planWebAPILinuxmacOS7.1From $100 a month - 4
Mosra
Free planWebmacOSSelf-hostedWindows7.0Free plan - 5
GrassBlade LRS
AndroidiOSWebAPI6.7From $5.50 a month - 6
Jupiter
Free planWebSelf-hosted6.4From $1 a month