Hermes Agent SQLite is simply the way your Hermes agent remembers every conversation: it writes each chat into one small database file on your own computer.
If your business uses Hermes to answer customers, draft content or run daily jobs, that file is the record of all of it.
This page explains what is inside, how to get old work back, and the four habits that keep it safe.
The facts come from the official Hermes Sessions guide and the v0.23.3 release.
And if your agent helps with your website, a Backlink Gameplan shows which links you need to rank, in 48 hours.
What SQLite is, in one minute
SQLite is a database that lives in a single file instead of on a server.
Nothing extra to install, nothing to pay for, nothing running in the background.
Phones, browsers and lots of desktop apps use it for the same reason Hermes does: it is small, fast and reliable.
For you, it means your agent's history sits in a file you control, not in someone else's cloud account.
What Hermes saves about every chat
Every conversation, whether you typed it in the terminal or a customer sent it on Telegram, Slack, WhatsApp or email, becomes a "session".
For each session the file keeps:
- Which app it came from and who sent it
- A short title, written for you automatically after the first reply
- The AI model that answered
- Every message, including the actions the agent took and what came back
- How many tokens were used
- When it started and ended
The file is called state.db and sits in the hidden .hermes folder in your home directory.
If you run more than one agent with Hermes profiles, each profile gets its own separate file, so a sales bot and a bookkeeping helper never mix their records.
Why this matters for a small business
Three practical reasons.
First, continuity: you can close your laptop on Friday and pick up the same job on Monday with the full context.
Second, proof: when a customer asks what the bot told them, the exact words are stored.
Third, recall: the agent itself can search past chats, so it can answer "what did we agree with that supplier last month?" without you digging.
Rank in AI Search or It's FREE →
The catch is that one file can grow, and it can be damaged if it is copied the wrong way.
Both are easy to avoid once you know how.
Here is how that plays out in a normal week.
A bakery owner asks the agent on Tuesday to draft a catering quote, and on Thursday the customer replies with changes.
Instead of explaining everything again, the owner resumes the Tuesday chat and the agent already has the numbers, the menu and the tone it used.
A consultant who runs a Telegram bot for clients can check exactly what the bot promised before replying to a complaint.
None of this needs a separate CRM or a paid add-on, because the history is already sitting in that one file.
Pick up yesterday's work where you left it
Hermes calls this resuming.
hermes -c # carry on with your last chat
hermes -c "client onboarding" # carry on with a chat by its name
hermes sessions list # see recent chats with titles
Resuming reloads the entire conversation from the database, so the agent sees everything it said and did before.
A tip that saves time: name important chats as you go by typing /title followed by a name, for example /title spring promo emails.
Names are unique, so you never mix two jobs up.
🔥 Want your AI agent set up properly from day one? Inside the AI Profit Boardroom you get step-by-step video trainings, the installable Agent OS, four live coaching calls every week and 3,400+ business owners setting up the same tools. → Join the AI Profit Boardroom
Find an old conversation in seconds
You have two ways.
You can browse with hermes sessions browse, which opens a searchable picker.
Or you can just ask the agent.
Hermes has a built-in search tool, session_search, that looks through every stored chat using SQLite's full-text search.
It does not call the AI model to do this, so it costs nothing and returns the real messages rather than a guess.
The memory guide puts a typical search at around 20 milliseconds.
Try asking: "Find the chat where we planned the January newsletter."
Join the AI Profit Boardroom →
Who can see what: the shared bot rule
This is the one privacy point every owner should know.
The search tool can read every chat in that profile, from every person allowed to talk to the bot.
So if your whole team, or your customers, use the same bot, anyone of them could ask it to pull up another person's conversation.
The fix is simple: give each group its own profile.
A customer-facing bot and your private assistant should never share one.
Stop the file from eating your disk
By default Hermes keeps everything forever.
That is fine for a light user, but the Hermes docs report files growing to several gigabytes within weeks on setups that run a chat gateway and scheduled jobs.
They also mention a case where a file of 384 MB with about 1,000 chats made search and the resume list slower.
Hermes will ask you once if your disk gets low.
To set a clear rule yourself, type /autoprune on in a chat.
That removes finished chats you have not touched for 90 days, the default window; chats still in progress are never removed.
If you would rather hide old chats without deleting them, archiving does exactly that.
And hermes sessions optimize gives free space back to your disk without deleting a single message.
A weekly backup routine that is actually safe
The safe way to back up is one command:
hermes backup --quick --label weekly
It makes a zip with your settings, your chat database and your scheduled jobs.
It works even while the agent is running, because it copies the database the way SQLite intends.
Two things not to do, straight from the recovery guide: never copy the state.db file on its own with Finder or a copy command, and never delete the two small files next to it that end in -wal and -shm.
Those small files can hold recent conversations that have not been written into the main file yet.
Put the backup zip somewhere off the machine, like a cloud drive, once a week.
📈 Using Hermes to grow your website traffic? Get your Backlink Gameplan and my team shows you the backlinks behind the competitors outranking you, how many you need and where to get them, within 48 hours, with a call with an SEO expert. → Get my Backlink Gameplan
Separate agents, separate files
Hermes profiles let you run different agents for different jobs, each with its own settings, personality and history.
Because every profile has its own state.db, deleting chats in one never touches another.
When you copy a profile with the clone option, its settings and memory files come across, but its chat history starts empty, per the profiles guide.
That is useful when you want a fresh helper with the same skills.
Adding longer-term memory on top
Chat history is the full record.
Long-term memory is the short list of facts the agent should always know, such as your brand voice or your top customers.
Hermes has a small built-in memory, and you can add a memory provider for more.
One option on the Memory Providers page is Holographic, which stores facts in its own local SQLite file and can score how much to trust each one.
It is installed from the Hermes plugin catalog and maintained by an outside developer, itpartypattaya.
There is also a community project called hermes-local-memory, labelled alpha by its author, that keeps memory in SQLite too.
For a business, the order is: get backups right first, then try a memory provider on a test profile.
What changed in the latest release
The v0.23.3 release on 20 November 2026 lists a quiet but useful change: Hermes moved its storage code behind a new persistence layer, with SQLite still doing the work underneath.
For you nothing changes, your file stays where it is and the commands stay the same.
Behind the scenes, the gateway is now the one process that writes chat history, which reduces the chance of two apps fighting over the file.
What Hermes does not do yet
Some guides suggest the agent can create its own database tables to track things like leads or stock.
That was proposed in GitHub issue #485, a "per-agent SQLite database" tool, but there is no such built-in tool in the current docs.
If you want the agent to work with your own records, keep them in your own spreadsheet or database and let a script feed them in.
Rank in AI Search or It's FREE →
Do not point anything at state.db for that; the Hermes team says its layout changes between releases.
Your first 15 minutes: a starter checklist
If you have never looked at this side of Hermes, do these five things once, in this order.
- Run
hermes sessions statsto see how many chats you have and how big the file is. - Run
hermes sessions listand give your most important chats proper names. - Make your first backup with
hermes backup --quick --label first. - Decide on a clean-up rule:
/autoprune onto delete old finished chats, or leave it off and archive instead. - Check that customer-facing bots and your own assistant live in different profiles.
After that, the only regular job is the weekly backup.
Everything else Hermes handles for you.
Risks to watch, in order of likelihood
- Disk filling up: turn on auto-prune or archive old chats.
- A bad copy: only back up with
hermes backup. - A shared bot reading private chats: split profiles by audience.
- An update you want to undo: keep a quick backup before every update, because older versions refuse to run on a database the newer one has already written.
- Running clean-up while the agent is busy: the clean-up commands refuse on purpose; stop Hermes first.
🔥 Learn the full Agent OS setup with other owners Inside the AI Profit Boardroom you get step-by-step video trainings, the installable Agent OS, four live coaching calls every week and 3,400+ members comparing what works. → Join the AI Profit Boardroom
Join the AI Profit Boardroom →
FAQ: Hermes Agent SQLite in Plain English
Do I need to install SQLite for Hermes?
No. Hermes creates and manages the database file itself.
Is my chat history stored in the cloud?
No. The state.db file sits on the machine running Hermes, in the hidden .hermes folder.
How do I get back to a chat from last week?
Run hermes sessions list to find it, then hermes -c with its title, or ask the agent to search for it.
Will deleting old chats make the file smaller?
Deleting frees space inside the file; run hermes sessions optimize afterwards to give it back to your disk.
Can two of my bots share one history?
Not by default. Each Hermes profile keeps its own state.db.
📺 Video notes + links to the tools 👉
🎥 Learn how I make these videos 👉
🆓 Get a FREE AI Course + Community + 1,000 AI Agents 👉
About Julian
I'm Julian Goldie, an SEO entrepreneur, author and founder of the AI Profit Boardroom, which has 3,400+ members.
I help business owners scale with AI agents, automation and SEO.
- I've built a 7-figure SEO and link building agency, Goldie Agency, with a team of 70+ SEO experts.
- I've grown a YouTube channel to 400,000+ subscribers.
- I wrote "Link Building Mastery".
- My Udemy courses have taught over 29,000 students.
→ Get my best AI training inside the AI Profit Boardroom
This week, name your three most important chats with /title and run your first hermes backup --quick.
For guided setups join the AI Profit Boardroom, or get your Backlink Gameplan if your agent works on SEO, and keep this page handy as your Hermes Agent SQLite explainer.











