Lucia PostgreSQL
PostgreSQL database for Lucia, an open-source, privacy-focused AI assistant that manages Home Assistant home automations.
Platform availability
Available on 1 of 10 platforms
- Unraid
- TrueNAS (not listed)
- Umbrel (not listed)
- ZimaOS (not listed)
- Proxmox (not listed)
- Helm (not listed)
- Mac (not listed)
- Windows (not listed)
- Linux (not listed)
- Any server (not listed)
Health score?A 0-100 score computed nightly from four factors: maintained (40%: recent commits and steady activity), popular (25%: GitHub stars, log scale), easy to install (20%: platforms, install notes, setup guides, Docker image) and light to run (15%: minimum RAM, ARM support). When the source code has been checked, a fifth factor, security check (20%: automated scan for committed secrets, unsafe desktop-app settings, known-vulnerable dependencies and project hygiene; any serious finding caps it at 20), is added. Factors without data are left out and the rest are rescaled.
62/100 Good
- Maintained
- 100last commit 22 days ago
- Popular
- 3770 GitHub stars
- Easy to install
- 251 install platform, install notes
- Light to run
- 502 GB minimum RAM
Availability: platform listings confirmed today, links checked 2 days ago
- GitHub stars
- 70
- Open issues
- 39
- Last commit
- 2026-10-30
- Latest release
- v1.6.3
- License
- MIT
- Activity
- rising
Checked 17 days ago - source: GitHub (seiggy/lucia-dotnet)
Resources & Compatibility
Minimum requirements: 2 GB RAM.
Checked 46 days ago - source: Docker Hub image tags and published docs
First-install notes
- Save the session row before logging in After creating a login session, insert its auth_session row into PostgreSQL before sending the token to the browser. If the database save is skipped or fails, the app may act as if the user is signed in while the server cannot find the session, causing random sign-out errors. source
- Use safe session cookie flags When sending the session token, set it as an HttpOnly, Same-Site=Lax, Secure cookie with a path and expiry. Without these settings, the login token can be exposed to scripts or forged in ways that let attackers take over accounts. source
- Store the secret hash as a BLOB Keep auth_session.secret_hash as a binary BLOB column and store timestamps as unix seconds, not text. If you use the wrong column type or time unit, session checks can fail with cryptic errors or tokens may expire at the wrong time. source
- Create the lucia Docker network first In the Unraid terminal, run `docker network create lucia` before installing. Install this PostgreSQL template before the Lucia app so the network and database exist when Lucia starts. source
Fetched 46 days ago - each note links to its source
Variants
Alternatives
No alternatives collected yet.
Common questions
What should I do before installing Lucia-PostgreSQL on Unraid?
Run docker network create lucia in the Unraid terminal, then install the Lucia-PostgreSQL template before Lucia.
Can Lucia run without relying on a cloud LLM?
Lucia is described as fully local operation with optional cloud LLM support. Your data stays yours unless you use the optional cloud LLM.
Where do I manage Lucia configuration and inspect agent traces?
Lucia includes a React dashboard for managing agents, inspecting traces, tuning configuration, and exporting training data.
How can I limit which Home Assistant entities Lucia can see?
You can control entity visibility through the dashboard UI or by pulling Home Assistant’s exposed-entity list over WebSocket.
What responsibilities come with self-hosting PostgreSQL for Lucia?
You become accountable for backups, downtime, and patching. You should verify that you can restore from backups.
Answers sourced from github.com, www.reddit.com
Community
- Who can explain me how to setup prisma, lucia, postgresql and ... - Reddit (reddit)
- I have used Lucia instead of Next Auth, here is my thoughts: (reddit)
Collected 48 days ago - public community threads