How I Built a RAG System to Mine My AI Chat History for Gold @MikeMurphy-AI
How I Built a RAG System to Mine My AI Chat History for Gold  @MikeMurphy-AI
Uploaded August 2025 | Updated September 2026, 1 week ago
Description:
In this tutorial, you will learn about RAG (Retrieval Augmented Generation) and how to build a RAG system from scratch that mines your AI Chat Conversations for ‘gold nuggets’ of information.

Get 20% off Hostinger VPS (referral link):
https://hostinger.com?REFERRALCODE=BYS0JAIWCIJP



In this tutorial, you'll learn:
* What is RAG (Retrieval Augmented Generation)?
* How Does RAG Work?
* How To Build A RAG System Using ChatGPT Conversations?
* What Are The Prerequisites?
* How To Use VS Code & Terminal To Run Python Scripts


Download Project Files:
https://dub.sh/aigoldmine

Prerequisites:
Python 3.8 or Later ( (https://python.org)
Confirm Ollama is running locally (https://ollama.com)
Embedding Model: nomic-embed-text (ollama.com/library/nomic-embed-text)
LLM Model: gpt-oss:20b (ollama.com/library/gpt-oss)
VS Code (or any IDE): code.visualstudio.com

Check If Python is installed:
python3 —version

Check if Ollama is running locally:
localhost:11434

Install Embedding Model:
ollama pull nomic-embed-text

——————

✅ Chapters:
00:00 Intro: About The Tutorial
00:44 Do You Have To Be A Developer?
01:04 What Is RAG?
01:42 Overview: How To Build A RAG
01:55 Chunking
02:09 Embeddings
02:25 Storage: Vector Database
02:37 Query
02:55 Connect To LLM Model (AI)
03:19 Retrieval Augmented Generation
04:07 How I Built AI Gold Mine
04:35 Gather AI Chat History Text
04:54 Prerequisites (Requirements)
05:11 Is Python Installed?
05:56 Ollama Models
06:21 Is Ollama Running Locally?
06:53 VS Code: Open Project Directory
07:50 Overview of Project Build
08:58 Open Terminal + Create Virtual Environment
09:25 Python Virtual Environment
10:01 Chunking Script (Copy & Paste)
10:44 Run Chunking Script
11:09 Embeddings (Copy & Paste)
11:30 Run Embeddings Script
11:45 Search (Copy & Paste)
12:10 Run Search Script
12:24 Install ChromaDB (Vector Database)
12:41 ChromaDB Script (Copy & Paste)
13:03 Run ChromaDB Script
13:26 Close RAG Loop Script
14:03 Run Complete Rag Script
14:40 Proof of Concept & Next Steps!

——————
🪜How To Build A Rag System From Scratch:
1. Copy AI Chat Conversation (ex. from ChatGPT)
2. Create New Text File using TextEdit or Similar
3. Paste text and Save As conversation.txt
4. Create New Project Directory/Folder (ex. ai-gold-mine)
5. Install Python 3.8 or later (https://python.org)
6. Confirm Ollama is running locally (https://ollama.com)
7. Install Embed & LLM Models for Ollama
8. Open Folder in VS Code
9. Open Terminal & Navigate to Project Folder
10. Create Python Virtual Environment
11. Install Python Requests
12. Copy chunk_test.py Script
13. Paste in chunk_test.py in VS Code
14. Save
15. Open Terminal and run Chunking Script
16. Copy embedding_test.py Script
17. Paste in embedding_test.py in VS Code
18. Save
19. Open Terminal and run Embedding Script
20. Copy search_test.py Script
21. Paste in search_test.py in VS Code
22. Save
23. Open Terminal and run Search Script
24. Install ChromaDB (Vector Database)
25. Copy chromadb_test.py Script
26. Paste in chromadb_test.py in VS Code
27. Save
28. Open Terminal and run Chroma DBScript
29. Copy complete_rag_.py Script
30. Paste in complete_rag_.py in VS Code
31. Save
32. Open Terminal and run Complete Rag Script

——————Resources———————

➜Gear I Use: mikemurphy.co/resources➜Adobe After Effects: mikemurphy.co/adobe 
➜Terrapin Textures: terrapintextures.com
➜ Adobe Audition Course (Domestika): mikemurphy.co/domestika

➜Amazon Influencer Store: amazon.com/shop/mikemurphyco
➜See All My Gear: mikemurphy.co/podgear
➜ Get Adobe Creative Cloud: mikemurphy.co/adobe
➜ Screenflow: mikemurphy.co/screenflow

➜ Website: mikemurphy.co
➜ Podcast: mikemurphy.co/mmu
➜ Instagram: instagram.com/mikeunplugged
➜ X:  http://x.com/mikeunplugged
➜ YouTube: mikemurphy.co/youtube

Amazon Associates Disclosure:Mike Murphy is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com
How I Built a RAG System to Mine My AI Chat History for GoldAdobe Podcast: AI-Powered Enhanced Speech V2ElevenMusic Tutorial: How To Create Songs from Text PromptsUnit 1 Review & Practice LessonHow To Make a Custom GPT to Speed Up Writing Weekly NewslettersAI Foundations #2: Machine Learning (ML) 📚How to Create a Telegram Bot with BotFather + Connect to n8n for Instant NotificationsAfter Effects Wiggle Panel: Add 12 Effect Buttons Using Cursor AIRemotion: How To Get Started Making Videos With Code (Beginners Guide)U4L4 How To Use Expressions in After EffectsBaby Mike Podcast Video Featuring Jerry Garcia (Full Tutorial on Channel)Unit 2 Review & Practice Lesson
Mike Murphy | AI Handyman |

How I Built a RAG System to Mine My AI Chat History for Gold

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER