SQL LRS
sqllrs.com
What it is
SQL LRS is a self-hosted Learning Record Store for xAPI statements, attachments, and documents. It supports SQLite, Postgres, MariaDB, and MySQL. Built-in conditional logic can evaluate incoming activity and create internal xAPI statements for validated outcomes. Its SQL data can connect to tools such as Power BI, Tableau, Looker, Apache Superset, and AI stacks that work with structured databases. Authentication options include OpenID and API credentials with keys, secrets, and scopes. The software is available through GitHub, DockerHub, and Platform One’s Iron Bank, but customers host it themselves. It 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 and that Iron Bank containers have Certification to Field for Platform One IL2 and IL4 environments. SQL LRS is an LRS, not an LMS or content store: it does not produce learning data or host learning content. Described uses include collecting activity from LMS, AR/VR/XR, and simulation systems and exchanging learning data with business and AI systems.
Spec sheet
- What it does
- SQL LRS is a Learning Record Store that receives, validates, stores and exposes xAPI statements, attachments and documents.Read 15 Oct 2026 · github.com
- Purpose
- SQL LRS stores xAPI statements, attachments, and documents as a Learning Record Store.Read 30 Sep 2026 · yetanalytics.github.io
- Intended users
- The maker describes use cases including collecting LMS, AR/VR/XR, and simulation activity data and exchanging learning data with business and AI systems.Read 30 Sep 2026 · yetanalytics.com
- Deployment
- SQL LRS is available through GitHub, DockerHub, and Platform One’s Iron Bank, and customers host it themselves.Read 30 Sep 2026 · yetanalytics.com
- Security
- The maker says its Iron Bank containers have Certification to Field for deployment in Platform One IL2 and IL4 environments.Read 30 Sep 2026 · yetanalytics.com
- Support
- Implementation and support service contracts are available for deployments of any size, with quotes available by contacting Yet Analytics.Read 30 Sep 2026 · yetanalytics.com
- License
- SQL LRS is distributed under the Apache 2.0 license and may be used in commercial projects.Read 30 Sep 2026 · yetanalytics.com
- Headquarters
- Savage, Maryland, USARead 28 Sep 2026 · sqllrs.com
- Founded
- 2014Read 28 Sep 2026 · sqllrs.com
- AI data preparation
- The maker positions SQL LRS as preprocessing learning data into structured signals for analytics and AI systems.Read 15 Oct 2026 · yetanalytics.com
- 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.Read 30 Sep 2026 · yetanalytics.com
- 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.Read 15 Oct 2026 · yetanalytics.github.io
- 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.Read 15 Oct 2026 · github.com
- Authentication
- SQL LRS supports OpenID Connect over OAuth 2.0 for xAPI endpoints and administrative functions.Read 15 Oct 2026 · yetanalytics.github.io
- AWS deployment
- The documentation index links an example AWS deployment and CloudFormation material.Read 15 Oct 2026 · yetanalytics.github.io
- BI integrations
- Yet Analytics names Power BI, Tableau, Looker, Apache Superset and Grafana as tools that can connect through SQL.Read 15 Oct 2026 · yetanalytics.com
- Company founders
- Crunchbase names Rose Burt and Shelly Blake-Plock as founders.Read 15 Oct 2026 · crunchbase.com
- Company founding
- LinkedIn lists Yet Analytics, Inc. as founded in 2014.Read 15 Oct 2026 · linkedin.com
- Company headquarters
- LinkedIn gives the headquarters as Savage, Maryland, United States.Read 15 Oct 2026 · linkedin.com
- Company size
- LinkedIn lists Yet Analytics, Inc. as having 11-50 employees.Read 15 Oct 2026 · linkedin.com
- Company status
- Crunchbase lists Yet Analytics, Inc. as an active, privately held, for-profit company.Read 15 Oct 2026 · crunchbase.com
- Conditional logic
- Yet Analytics says SQL LRS includes an onboard conditional-logic engine that preprocesses incoming activity data.Read 15 Oct 2026 · yetanalytics.com
- CORS caveat
- The documentation says allowAllOrigins is permissive for testing and should be replaced with stricter CORS settings in deployed systems.Read 15 Oct 2026 · yetanalytics.github.io
- Database persistence
- The Docker instructions persist the SQLite database through a named Docker volume and allow mounted configuration, authority templates and TLS certificates.Read 15 Oct 2026 · yetanalytics.github.io
- Database support
- The documentation lists SQLite, Postgres, MariaDB, and MySQL support.Read 30 Sep 2026 · yetanalytics.github.io
- Deployment model
- The maker says customers host SQL LRS themselves and that Yet Analytics does not provide a hosted service.Read 15 Oct 2026 · yetanalytics.com
- Docker distribution
- Yet Analytics publishes Docker images named yetanalytics/lrsql with versioned and latest tags.Read 15 Oct 2026 · yetanalytics.github.io
- 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.Read 15 Oct 2026 · yetanalytics.github.io
- Funding disclosure
- Crunchbase shows two seed funding rounds and seven investors, but the funding amounts are obscured on the public page.Read 15 Oct 2026 · crunchbase.com
- Generated statements
- The product can evaluate activity streams and generate internal xAPI statements representing derived outcomes.Read 15 Oct 2026 · yetanalytics.com
- Independent pricing information
- GetApp shows no pricing information for Yet SQL LRS and directs visitors to get a price.Read 15 Oct 2026 · getapp.com
- Independent support listing
- GetApp lists email/help-desk, FAQs/forum, knowledge base and phone support, plus in-person, live-online, webinar and documentation training options.Read 15 Oct 2026 · getapp.com
- Independent typical customer listing
- GetApp lists freelancers, small businesses, mid-size businesses and large enterprises as supported customer types, while its FAQ highlights large enterprises.Read 15 Oct 2026 · getapp.com
- Legal name
- Crunchbase identifies the maker as Yet Analytics, Inc.Read 15 Oct 2026 · crunchbase.com
- Limitations
- SQL LRS is an LRS rather than an LMS or content store, and does not itself produce learning data or host learning content.Read 30 Sep 2026 · yetanalytics.github.io
- OIDC use cases
- OIDC documentation covers authenticated xAPI clients, programmatic credential provisioning and single sign-on to the admin interface.Read 15 Oct 2026 · yetanalytics.github.io
- Open-source license
- The project is distributed under the Apache License 2.0 and the GitHub repository exposes its source and license files.Read 15 Oct 2026 · github.com
- Other BI support
- The documentation lists Apache Superset support and provides a Superset visualization demo.Read 30 Sep 2026 · yetanalytics.github.io
- Product boundary
- SQL LRS is not an LMS, learning-content repository, authoring system or learning-record provider; it depends on external systems to produce learning data.Read 15 Oct 2026 · yetanalytics.github.io
- Rating on GetApp
- 0 out of 5 from 0 reviewsRead 15 Oct 2026 · getapp.com
- Security caveat
- Startup creates a temporary self-signed certificate suitable for testing and development but unsuitable for production.Read 15 Oct 2026 · yetanalytics.github.io
- SQL database design
- The product stores learning records in SQL databases rather than a proprietary document store.Read 15 Oct 2026 · github.com
- Standards
- The maker says SQL LRS conforms to IEEE 9274.1.1.Read 30 Sep 2026 · yetanalytics.com
- Supported databases
- Documented database engines are SQLite 3.42, PostgreSQL 14-18, MariaDB 10.6-11.8 and MySQL 8.0.44, 8.4 and 9.5.0.Read 15 Oct 2026 · github.com
- System configuration
- Initial setup requires default admin credentials and allows host, HTTP port, HTTPS port and authority URL configuration through JSON or environment variables.Read 15 Oct 2026 · yetanalytics.github.io
- Tenancy limitation
- The FAQ states that SQL LRS does not support tenancy and treats the database as one default tenant.Read 15 Oct 2026 · yetanalytics.github.io
- xAPI attachments
- The repository describes support for xAPI statements together with associated attachments and documents.Read 15 Oct 2026 · github.com
Plans and prices
Open source Free Always free Apache 2.0 license · self-hosted · SQL-backed xAPI storage Read 15 Oct 2026 · yetanalytics.com
SQL LRS Free Apache 2.0 open source · self-hosted · implementation and support services quoted separately Read 30 Sep 2026 · yetanalytics.com
Strong points and limits
Strong points
- Supports four listed database systems.
- Conditional logic can create internal xAPI statements.
- Offers OpenID and scoped API credentials.
- Apache 2.0 license permits commercial use.
- CSV record export is listed.
Limits
- Customers must host the software themselves.
- It does not host learning content.
- It does not produce learning data.
- Implementation and support services are quoted separately.
Who it suits
SQL LRS suits organizations that need to collect or exchange xAPI learning activity data and can host the software themselves. It may also suit teams connecting structured learning data to analytics or AI tools.
SQL LRS in depth
Read the full write-up
SQL LRS is a self-hosted Learning Record Store for organizations that need to collect and work with xAPI data in a SQL database. It is a strong fit for teams connecting learning activity to analytics or business systems, but not for anyone seeking an LMS or a hosted service.
Overview
SQL LRS stores xAPI statements, attachments, and documents. It can collect activity from LMSs, AR/VR/XR experiences, and simulations, then support exchange of that learning data with business and AI systems. Its built-in conditional logic can assess incoming activity and create internal xAPI statements for validated outcomes, making it more than a passive record repository.
The trade-off is operational responsibility: customers host the software themselves. The Apache 2.0 license permits commercial use, while implementation and support contracts are quoted separately through Yet Analytics.
Key features
SQL storage and analytics
Supported databases are SQLite, Postgres, MariaDB, and MySQL. Storing records in these structured databases can make SQL a practical bridge between learning activity and tools such as Power BI, Tableau, Looker, and AI stacks that work with structured data. Apache Superset is also supported, with a visualization demo. Record export is available in CSV.
Access, standards, and deployment
Authentication options include OpenID and API credentials with keys, secrets, and scopes. SQL LRS conforms to IEEE 9274.1.1. It is distributed through GitHub, DockerHub, and Platform One’s Iron Bank, giving organizations several self-hosted deployment routes. The maker says its Iron Bank containers are certified for deployment in Platform One IL2 and IL4 environments, a relevant consideration for teams operating in those environments.
Pricing
The SQL LRS plan costs nothing and is open source under Apache 2.0. There is no subscription charge for the software, but this is not a hosted free service: customers supply and operate the hosting. Implementation and support services are quoted separately, so teams that need vendor assistance should account for those costs. Multi-tenant support is not available, which may rule it out for organizations needing one shared deployment to serve multiple tenants.
Platforms
SQL LRS supports API, Linux, macOS, self-hosted, web, and Windows environments. The self-hosted model gives infrastructure teams control over deployment, but puts installation and ongoing operation on the customer.
Who it's for
SQL LRS suits organizations that already produce xAPI activity and want to retain it in databases they control, especially when they need to connect learning records to business intelligence or AI systems. It can serve data collection across LMS, extended-reality, and simulation experiences. It is not the right choice for teams that need course authoring, content hosting, or an LMS: it neither generates learning data nor delivers learning content.
Pros and cons
SQL database choice: Support for four named databases gives teams options for fitting records into existing structured-data environments.
Analytics connections: BI integrations and Superset support make learning activity useful beyond the LRS itself.
Open-source commercial use: Apache 2.0 allows commercial projects without a software license charge.
Customer-operated hosting: Control over deployment comes with responsibility for infrastructure and maintenance.
No multi-tenant support: Organizations needing tenant separation in a shared instance will need another arrangement.
Narrow scope: It stores and processes records, but cannot replace the LMS or content platform that produces and delivers learning.
Alternatives
Learning Record Store Software is the broader category to explore when comparing LRS products.
Veracity Learning is worth considering for a free Lite plan that supports five LRSs and is based on your infrastructure; its Lite download is also free. Its Starter plan is $100 a month.
GrassBlade LRS may suit buyers who prefer a paid annual plan with a stated statement allowance: Essential costs $66 a year, billed yearly, for 25,000 statements per month and one instance, with a $4 fee per 1,000-statement overage.
Cluelabs LRS is another freemium option for readers comparing LRS products.
xh is a free open-source command-line HTTP client, rather than a direct LRS substitute.
Mosra offers a free launch-period plan with unlimited lessons and listed features and exports; it may suit readers seeking a lesson-oriented product during that period.
Instancy Learning Record Store is a paid alternative with a free trial and custom pricing based on user count, modules, and implementation needs.
itslearning is a paid LMS alternative for organizations evaluating a broader learning platform; its yearly license is based on user count and requirements.
SCORM Cloud LRS is a paid alternative with a free, non-time-based trial capped at three courses, 5GB of storage, and 10 resettable registrations, useful for readers who want to evaluate a hosted API and web option before paying.
Verdict
Choose SQL LRS if your priority is an open-source, standards-conforming store for xAPI data that you can host in a SQL environment and connect to analytics. Its database flexibility and conditional logic are compelling for technically equipped teams. Look elsewhere if you need a hosted LRS, multi-tenant support, learning content, or an LMS—or if you do not want to own deployment and operations.
Verdict
SQL LRS provides storage and processing for xAPI data with database and analytics connections. It is not a learning management system or content host, and deployments require customer hosting; implementation and support costs are quoted separately.
Where Specifiction places it
- Learning Record Store Software#3 of 238.4
Alternatives to SQL LRSAll alternatives →
itslearning 7.9 Visit