Lucia PostgreSQL

PostgreSQL database for Lucia, an open-source, privacy-focused AI assistant that manages Home Assistant home automations.

  • Databases
  • Home Automation
  • Tools & Utilities
PostgreSQL database for Lucia, an open-source, privacy-focused AI assistant that manages Home Assistant home automations. It stores Lucia's configuration, agent traces, and task data, giving the app a dedicated persistent backend. Intended for homelab users deploying Lucia on Unraid.

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

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

Collected 48 days ago - public community threads