The latest articles on DEV Community by Srikanth Rao M (@melagiri). https://dev.to/melagiri https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F175555%2Fb680cce3-7c91-4dc0-b491-1c352b434e9f.jpeg https://dev.to/melagiri en Srikanth Rao M Wed, 04 Mar 2026 08:24:50 +0000 https://dev.to/melagiri/code-insights-turn-ai-coding-sessions-into-lasting-knowledge-28oc https://dev.to/melagiri/code-insights-turn-ai-coding-sessions-into-lasting-knowledge-28oc <p>I built a CLI tool that parses AI coding sessions from Claude Code, Cursor, Codex CLI, and Copilot CLI into a local SQLite database with terminal analytics and a browser dashboard.</p> <p>The core problem: developers using AI coding tools generate thousands of session files containing real knowledge — debugging approaches, architectural decisions, patterns — but never revisit them.</p> <p>How it works: Each source tool has a provider that discovers and parses session files into a common format. Everything goes into SQLite (WAL mode, better-sqlite3). The CLI provides cost/usage analytics. The dashboard (Vite + React SPA at localhost) gives you session browsing and LLM-powered insight extraction.</p> <p><a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fh76u3z5eomb7kp0451w9.png" class="article-body-image-wrapper"><img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fh76u3z5eomb7kp0451w9.png" alt=" " width="800" height="502"></a></p> <p>Fully local, MIT licensed, no accounts needed.</p> <p>Docs: <a href="https://code-insights.app/docs/getting-started/introduction" rel="noopener noreferrer">https://code-insights.app/docs/getting-started/introduction</a> </p> <p>Install: npm install -g @code-insights/cli</p> <p>GitHub: <a href="https://github.com/melagiri/code-insights" rel="noopener noreferrer">https://github.com/melagiri/code-insights</a></p> ai cli productivity showdev