AI Income Desk Join AIPB

Hermes Agent SQLite in Plain English: Where Your AI Agent Keeps Every Chat, and How to Look After It

A plain-English walk through the one file that holds your agent's history, with the few commands a business owner actually needs.

Julian Goldie — founder, AI Profit Boardroom
By Julian Goldie /9 min read
Get the AI Profit Stack Join AIPB →
  • 1,000+ done-for-you AI agent workflows
  • 5 live coaching calls / week with Julian
  • 7-day refund
  • 3,400+ AI operators inside

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.

Get the Backlink Gameplan →

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

Get the 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.

  1. Run hermes sessions stats to see how many chats you have and how big the file is.
  2. Run hermes sessions list and give your most important chats proper names.
  3. Make your first backup with hermes backup --quick --label first.
  4. Decide on a clean-up rule: /autoprune on to delete old finished chats, or leave it off and archive instead.
  5. 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.

Member reviews · from Skool

What members say about the AI Profit Boardroom

Read the member reviews on Skool →
Ahmad Bukhari: Julian doesn't gatekeep. That's why I'd recommend this group. He's extremely active here, sharing what's working right now and jumping in to help anyone who's stuck. If he can give it away, he does. He keeps the vibe positive and pushes everyone to help each other. His challenges reward members for getting people unstuck, so the whole room shares knowledge, not just him. Want a generous, positive place to learn AI and actually use it? This is it. Thanks Julian!
Ahmad Bukhari
Julian doesn't gatekeep. That's why I'd recommend this group. He's extremely active here, sharing what's working right now and jumping in to help anyone who's stuck. If he can give it away, he does. He keeps the vibe positive and pushes everyone to help each other. His challenges reward members for getting people unstuck, so the whole room shares knowledge, not just him. Want a generous, positive place to learn AI and actually use it? This is it. Thanks Julian!

Still a paying member after 1 month

Jay Parsons: There are so many helpful members in this amazing community ready to help out with suggestions and solutions whenever someone asks a question. I am amazed at the progress I have made in learning AI. I came here to learn how to use AI better and apply what I learned to my business. I am learning so much more than I even dreamed of. I have built an Agentic OS and use it every day, and I have no background in coding. There are an incredible amount of useful tutorials on everything AI.
Jay Parsons
There are so many helpful members in this amazing community ready to help out with suggestions and solutions whenever someone asks a question. I am amazed at the progress I have made in learning AI. I came here to learn how to use AI better and apply what I learned to my business. I am learning so much more than I even dreamed of. I have built an Agentic OS and use it every day, and I have no background in coding. There are an incredible amount of useful tutorials on everything AI.

Still a paying member after 11 months

Brian O'Connor: At 47, with 30 years in sales and finance, embracing AI was exciting but overwhelming. While building a business to help others adopt AI, I found myself chasing tools and fearing I was falling behind. Julian and the AI Profit Boardroom helped me refocus through practical, personalized advice and a supportive community. I now feel more confident adapting to change while staying focused on my goals. Thank you, Julian, for bringing this community together!
Brian O'Connor
At 47, with 30 years in sales and finance, embracing AI was exciting but overwhelming. While building a business to help others adopt AI, I found myself chasing tools and fearing I was falling behind. Julian and the AI Profit Boardroom helped me refocus through practical, personalized advice and a supportive community. I now feel more confident adapting to change while staying focused on my goals. Thank you, Julian, for bringing this community together!

Still a paying member after 2 months

Neil Martin: This is a truly amazing community, thanks in no small part to Julian's prodigious output and tireless efforts to provide value to his subscribers. Nothing is too much trouble for him. If you ask a question it gets answered in short order usually with a custom video. I have been in quite a few groups and this level of service is unparalleled. If you are serious about getting an AI education, you need to be in this group!
Neil Martin
This is a truly amazing community, thanks in no small part to Julian's prodigious output and tireless efforts to provide value to his subscribers. Nothing is too much trouble for him. If you ask a question it gets answered in short order usually with a custom video. I have been in quite a few groups and this level of service is unparalleled. If you are serious about getting an AI education, you need to be in this group!

Still a paying member after 7 months

Crystal Hill: AIPB has inspired me to go beyond learning AI as individual tools, skills, and prompts, and start thinking in terms of larger systems. What I really appreciate is how responsive Julian is and how quickly the material evolves with the technology. You’re being exposed to the right tools and ideas as they emerge. AIPB has given me the confidence to learn, experiment, build, and think much bigger about what’s really possible with AI.
Crystal Hill
AIPB has inspired me to go beyond learning AI as individual tools, skills, and prompts, and start thinking in terms of larger systems. What I really appreciate is how responsive Julian is and how quickly the material evolves with the technology. You’re being exposed to the right tools and ideas as they emerge. AIPB has given me the confidence to learn, experiment, build, and think much bigger about what’s really possible with AI.

Still a paying member after 5 months

Maurice Morrison: AI Profit Board Room has been a game-changer. The insights are practical, timely, and focused on turning AI into real business results—not just theory or hype. The community is supportive, the guidance is clear, and I leave every session with ideas I can actually apply. If you’re serious about using AI to grow smarter and move faster, this is absolutely worth joining.
Maurice Morrison
AI Profit Board Room has been a game-changer. The insights are practical, timely, and focused on turning AI into real business results—not just theory or hype. The community is supportive, the guidance is clear, and I leave every session with ideas I can actually apply. If you’re serious about using AI to grow smarter and move faster, this is absolutely worth joining.

Still a paying member after 2 months

Jeremy Murdock: I have truly enjoyed my experience here. The group of folks on the calls is quite diverse and I find it comforting to know that I am not the only one going through the changes that are happening at a faster and faster pace. I have chosen to embrace the change and go full force into integrating AI and what I have learned form the group and Julian. I am also impressed and appreciative that he actually takes the time to help with challenges I have along the way and get involved personally!
Jeremy Murdock
I have truly enjoyed my experience here. The group of folks on the calls is quite diverse and I find it comforting to know that I am not the only one going through the changes that are happening at a faster and faster pace. I have chosen to embrace the change and go full force into integrating AI and what I have learned form the group and Julian. I am also impressed and appreciative that he actually takes the time to help with challenges I have along the way and get involved personally!

Still a paying member after 10 months

Michael Lovitch: I have been a part of a million ai groups in Skool for years now. They are all okay and have helped, but usually they get out of date and don't offer real service to help you through especially at the beginning. This group is different, Julian actually answers questions which is crazy! And although ai marketing moves at the speed of light, they stay current and actually help you keep up… Highly recommended!
Michael Lovitch
I have been a part of a million ai groups in Skool for years now. They are all okay and have helped, but usually they get out of date and don't offer real service to help you through especially at the beginning. This group is different, Julian actually answers questions which is crazy! And although ai marketing moves at the speed of light, they stay current and actually help you keep up… Highly recommended!

Still a paying member after 3 months

Hoebing Lo: I don't know of any other community that is as active and sharing. Julian is a star and he answers so many questions in lightning speed. If you want a great place to start with AI here it is. No question too simple. No workflow too complicated. The community is about action and results not education so if you are looking to win at AI then come for the ride of a lifetime!
Hoebing Lo
I don't know of any other community that is as active and sharing. Julian is a star and he answers so many questions in lightning speed. If you want a great place to start with AI here it is. No question too simple. No workflow too complicated. The community is about action and results not education so if you are looking to win at AI then come for the ride of a lifetime!

Still a paying member after 5 months

Darren Wagstaff: Very responsive... great personal support (not an ai chat bot). Very clear straight forward trainings in easy to understand actionable language. I'm in numerous Skool groups but this one has the most human and real community by far. No question gets ignored. You never fell like just another number. It's great to see so many members getting great results with Ai.
Darren Wagstaff
Very responsive... great personal support (not an ai chat bot). Very clear straight forward trainings in easy to understand actionable language. I'm in numerous Skool groups but this one has the most human and real community by far. No question gets ignored. You never fell like just another number. It's great to see so many members getting great results with Ai.

Still a paying member after 2 months

Rod Martin: Julian is brilliant, and more prolific than I can keep up with (which is a great thing). His AgentOS is remarkable, and he is THE go-to guy for what you can really do (and not do) with the ever-increasing deluge of new AI upgrades and tools. HIGHLY recommend.
Rod Martin
Julian is brilliant, and more prolific than I can keep up with (which is a great thing). His AgentOS is remarkable, and he is THE go-to guy for what you can really do (and not do) with the ever-increasing deluge of new AI upgrades and tools. HIGHLY recommend.

Still a paying member after 5 months

Yosuke Sato: The best Skool course you get for AI! I have attended a few Skool courses before, but AI Profit Boardroom is the most active community and has great support from the management team, including Julian! You can get the most up-to-date information and practical implementations in this community. I highly recommend this!
Yosuke Sato
The best Skool course you get for AI! I have attended a few Skool courses before, but AI Profit Boardroom is the most active community and has great support from the management team, including Julian! You can get the most up-to-date information and practical implementations in this community. I highly recommend this!

Still a paying member after 19 months

Your next move

Ready to build AI agents that actually make money?

Join 3,400+ entrepreneurs inside the AI Profit Boardroom. Get 1,000+ plug-and-play AI agent workflows, 5 live coaching calls a week, and a community that holds you accountable.

Join the AI Profit Boardroom →

7-day no-questions refund · Cancel anytime

Found this useful? Get more of this site in your Google.

One tap adds us as a preferred source — Google then shows you our posts more often in Search, Top Stories, and AI Overviews.

Or add us in your Google settings →

← Back to all posts