SQL LRS
sqllrs.com
- Free plan
- Open source
- Windows
- macOS
- Linux
- Web
- API
- Self-hosted
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. Built-in conditional logic can assess incoming activity and create internal xAPI statements for validated outcomes. Data stored in SQL databases can be used with tools such as Power BI, Tableau, Looker, Apache Superset, and AI systems that work with structured databases. Authentication options include OpenID and API credentials with keys, secrets, and scopes. Customers host the software themselves; it is available through GitHub, DockerHub, and Platform One’s Iron Bank. The maker says its Iron Bank containers are certified for deployment in Platform One IL2 and IL4 environments, and that SQL LRS conforms to IEEE 9274.1.1. It is distributed under the Apache 2.0 license and can be used in commercial projects. SQL LRS is free, while implementation and support services are quoted separately. It stores learning data but does not create that data or host learning content.
Who it suits
It suits teams collecting activity data from LMS, AR/VR/XR, or simulation systems and exchanging learning data with business or AI systems. It is for organizations prepared to host an LRS themselves, rather than seeking an LMS or content store.
Good to know, and what to watch
- Supports SQLite, Postgres, MariaDB, and MySQL
- Conditional logic can generate validated xAPI statements
- Connects SQL data with BI and AI tools
- Apache 2.0 license permits commercial use
- Conforms to IEEE 9274.1.1
- Customers must host deployments themselves
- It is not an LMS or content store
- It does not produce learning data
- Support and implementation services are quoted separately
Plans
Every plan and priceOpen source
SQL LRS
Free plan
Getting started
- Open the SQL LRS website
- Choose a deployment source such as GitHub, DockerHub, or Iron Bank
- Host the deployment in your own environment
- Connect a supported SQLite, Postgres, MariaDB, or MySQL database
- Configure OpenID or API credentials with keys, secrets, and scopes
- Connect SQL data to your chosen BI or AI tools
Limits to check
SQL LRS does not provide LMS functions or host learning content, and customers must host deployments themselves. Implementation and support are separate quoted services.
The Club's review
SQL LRS is a self-hosted Learning Record Store for teams that need to collect and work with xAPI activity in a SQL database. It is a strong fit when database choice and deployment control matter; it is not a course platform or a way to create learning content.
Overview
SQL LRS stores xAPI statements, attachments, and documents. It can collect activity from LMSs, AR/VR/XR experiences, and simulations, and support exchanges of learning data with business and AI systems. Its built-in conditional logic can evaluate incoming activity and generate internal statements for validated outcomes, so it can do more than simply retain records.
The self-hosted approach gives organizations control over where the service runs and which supported SQL database it uses. The trade-off is operational responsibility: customers host it themselves, and implementation and support services are quoted separately through Yet Analytics.
Key features
SQL storage and analytics
Documentation lists SQLite, Postgres, MariaDB, and MySQL support. Keeping learning records in structured databases can make them useful to analytics tools such as Power BI, Tableau, Looker, and AI stacks that work with structured data. Apache Superset is also supported, with a visualization demo. This is a practical advantage for teams that want learning activity alongside other SQL data, though it presumes they can manage the database and deployment.
Rules, access, and standards
Conditional logic can assess incoming activity and create internal xAPI statements for validated outcomes. OpenID authentication and API credentials with keys, secrets, and scopes are listed in the documentation, giving teams options for managing access. The maker says the software conforms to IEEE 9274.1.1.
Deployment and security
SQL LRS is distributed through GitHub, DockerHub, and Platform One’s Iron Bank. The maker says its Iron Bank containers have Certification to Field for deployment in Platform One IL2 and IL4 environments, which may matter to organizations working in those settings. It is Apache 2.0 open source and may be used in commercial projects.
Pricing
The SQL LRS plan costs nothing and is self-hosted under the Apache 2.0 license. That makes it a sensible option for organizations able to operate their own service and database without a software subscription. The cost does not include implementation or support services; those require separate, quoted contracts. There is no multi-tenant support, and record export is CSV.
Platforms
SQL LRS supports API, Linux, macOS, web, and Windows environments, with self-hosted deployment. Its availability through GitHub, DockerHub, and Iron Bank gives technical teams multiple deployment routes, but the product is not a hosted service that removes infrastructure work.
Who it's for
SQL LRS suits organizations collecting xAPI records from multiple learning environments and wanting to connect them to business or AI systems through SQL. It is particularly appropriate when a team values control over database and deployment choices and has the capacity to host and maintain the software. It is the wrong fit for buyers who need an LMS, hosted course content, or a product that generates learning activity on its own.
Pros and cons
- Pros: Support for four SQL databases gives teams flexibility to use a familiar data stack.
- Pros: Conditional logic can turn validated incoming activity into internal xAPI statements rather than limiting the LRS to storage.
- Pros: Apache 2.0 licensing permits commercial use, and SQL data can connect to named BI tools and structured-data AI stacks.
- Cons: Self-hosting puts deployment and operations on the customer.
- Cons: It does not create learning data or host learning content, so it cannot replace an LMS or content platform.
- Cons: Multi-tenant support is absent, and implementation and support services cost extra under separately quoted contracts.
Alternatives
For a wider range of Learning Record Store options, browse Learning Record Store Software.
Choose Veracity Learning if a free option that allows up to five LRSs and is based on your infrastructure better matches your deployment needs.
Cluelabs LRS is another free-plan alternative.
xh is a free, open-source command-line HTTP client.
Consider Sereni LRS if you want a free plan with up to 100,000 xAPI statements or events, 1 GB of storage, unlimited LRSs, and reporting and analytics.
TRAX LRS offers a free, open-source Starter Edition with one admin user, one xAPI endpoint, MySQL or PostgreSQL support, and statement exploration.
Jupiter has a free hosted plan for up to one million events per year.
Mosra offers a free launch-period plan with unlimited lessons and its listed features and exports.
Choose SCORM Cloud LRS if you need a paid option with a free trial that is not time-based.
Verdict
SQL LRS is a good choice for technically equipped organizations that want an open-source, self-hosted LRS with flexible SQL storage and a path to analytics integrations. Its main reason to choose it is control over the data and deployment stack; its main reason to look elsewhere is that hosting remains your responsibility and it provides neither an LMS nor learning content.
The verdict
SQL LRS is a free, self-hosted option for storing and working with xAPI records in supported SQL databases. It is not a learning platform for creating data or hosting content, and service contracts are separate from the software.
Questions people ask
Is SQL LRS free?
Yes. The SQL LRS plan is free, and the software uses the Apache 2.0 license.
Which databases does it support?
Documentation lists SQLite, Postgres, MariaDB, and MySQL support.
Can it connect to analytics tools?
SQL data can be used with Power BI, Tableau, Looker, Apache Superset, and AI stacks for structured databases.
How is SQL LRS deployed?
It is available through GitHub, DockerHub, and Platform One’s Iron Bank, and customers host it themselves.
Does it include learning content or LMS features?
No. SQL LRS is an LRS, not an LMS or content store, and it does not produce learning data or host content.
What the maker publishes
- AI data preparation
- The maker positions SQL LRS as preprocessing learning data into structured signals for analytics and AI systems. source
- 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. source
- 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. source
- 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. source
- Authentication
- The documentation lists OpenID authentication and API credentials with keys, secrets, and scopes. source
- Authentication
- SQL LRS supports OpenID Connect over OAuth 2.0 for xAPI endpoints and administrative functions. source
- AWS deployment
- The documentation index links an example AWS deployment and CloudFormation material. source
- BI integrations
- Yet Analytics names Power BI, Tableau, Looker, Apache Superset and Grafana as tools that can connect through SQL. source
- Company founders
- Crunchbase names Rose Burt and Shelly Blake-Plock as founders. source
- Company founding
- LinkedIn lists Yet Analytics, Inc. as founded in 2014. source
- Company headquarters
- LinkedIn gives the headquarters as Savage, Maryland, United States. source
- Company size
- LinkedIn lists Yet Analytics, Inc. as having 11-50 employees. source
- Company status
- Crunchbase lists Yet Analytics, Inc. as an active, privately held, for-profit company. source
- Conditional logic
- Its built-in conditional logic evaluates incoming activity and can generate internal xAPI statements for validated outcomes. source
- Conditional logic
- Yet Analytics says SQL LRS includes an onboard conditional-logic engine that preprocesses incoming activity data. source
- CORS caveat
- The documentation says allowAllOrigins is permissive for testing and should be replaced with stricter CORS settings in deployed systems. source
- Database persistence
- The Docker instructions persist the SQLite database through a named Docker volume and allow mounted configuration, authority templates and TLS certificates. source
- Database support
- The documentation lists SQLite, Postgres, MariaDB, and MySQL support. source
- Deployment
- SQL LRS is available through GitHub, DockerHub, and Platform One’s Iron Bank, and customers host it themselves. source
- Deployment model
- The maker says customers host SQL LRS themselves and that Yet Analytics does not provide a hosted service. source
- Docker distribution
- Yet Analytics publishes Docker images named yetanalytics/lrsql with versioned and latest tags. source
- 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. source
- Founded
- 2014 source
- Funding disclosure
- Crunchbase shows two seed funding rounds and seven investors, but the funding amounts are obscured on the public page. source
Checked against the maker's pages on 15 Oct 2026.