I Built a Private AI Assistant That Queries My Git History and Project Management Data — Using Only Local LLMs
A web developer created a private AI assistant that queries Git history and project management data using local large language models (LLMs). The assistant operates entirely on the user's machine, ensuring data privacy while providing instant answers to project-related questions. By utilizing a structured data approach with SQLite and Text-to-SQL, the assistant efficiently links Git commits to project tasks.
- ▪The AI assistant does not require API keys or cloud services, keeping all data local.
- ▪It uses a SQLite database to store structured data from Git and project management platforms.
- ▪The assistant translates user questions into SQL queries to retrieve relevant information.
Opening excerpt (first ~120 words) tap to expand
try { if(localStorage) { let currentUser = localStorage.getItem('current_user'); if (currentUser) { currentUser = JSON.parse(currentUser); if (currentUser.id === 3943899) { document.getElementById('article-show-container').classList.add('current-user-is-article-author'); } } } } catch (e) { console.error(e); } Pouria Zandakbari Posted on May 21 I Built a Private AI Assistant That Queries My Git History and Project Management Data — Using Only Local LLMs #llm #rag #privacy #python No API keys. No cloud. All data stays on my machine.
…
Excerpt limited to ~120 words for fair-use compliance. The full article is at DEV.to (Top).
Discussion
0 commentsMore from DEV.to (Top)
