AI Archives - ITNotes

Build an AI Data Analyst with PandasAI and Python: Query CSV/Excel Data Using Natural Language

July 21, 2026

PandasAI wraps an LLM around any pandas DataFrame, letting you query CSV and Excel files in plain English and generate charts without writing a single line of pandas. This guide walks through the full setup — from installation to production-ready configuration — with practical code examples.

Build a Personal AI Knowledge Base with Obsidian, Ollama and ChromaDB: Offline Semantic Search for Your Notes

July 20, 2026

Keyword search fails when you need it most — 2 AM, 600 notes, and the answer is in there somewhere with a title you don't remember. This guide builds a fully offline personal AI knowledge base using Obsidian, Ollama, and ChromaDB so you can search your notes by meaning, not by exact wording, with no cloud dependency.

Deploying Flowise on Docker: Stop Coding Your AI Agents and Start Drawing Them

July 20, 2026

Ditch the 2 AM debugging sessions. Learn how to deploy Flowise on Docker to build complex AI agents and RAG workflows visually, cutting development time by up to 80%.

Build a Local Git Commit Assistant with LLM and Git Hooks

July 18, 2026

Learn how to build a local Git Commit Assistant using Ollama and Git Hooks. Automatically generate professional commit messages and perform code quality checks entirely offline.

Stop Settling for Mediocre RAG: A Practical Guide to Reranking with BGE and Cohere

July 18, 2026

Reranking is the secret to high-accuracy RAG. Learn how to implement a two-stage retrieval pipeline using BGE-Reranker and Cohere's API to eliminate irrelevant AI context.

Build a Local AI OCR System with GOT-OCR2: No Cloud, No Subscriptions, Just Python

July 18, 2026

Tired of expensive cloud OCR bills? Learn how to build a high-performance, local AI OCR system using Python and GOT-OCR2 to handle complex tables, formulas, and messy documents.

Stop Overpaying for GPT-4o: Smart Query Routing with RouteLLM

July 18, 2026

Is GPT-4o draining your budget? Learn how to use RouteLLM to automatically route simple queries to cheaper models, cutting your API costs by up to 50% without sacrificing response quality.

Running Mixtral and Qwen-MoE Locally: High-Performance AI on Consumer Gear

July 17, 2026

Run GPT-4 class models on your own desk. This guide shows you how to use Ollama to deploy Mixtral and Qwen-MoE models locally, with specific tips for VRAM optimization.

Building AI Applications with Microsoft Semantic Kernel and Python: Plugins, Memory, and Planning for Enterprise AI Agents

July 16, 2026

If LangChain version bumps have burned you before, Microsoft Semantic Kernel is worth a serious look. This guide builds a working Python AI agent from scratch — native plugins, semantic plugins, vector memory, and auto-invocation planning — with real code you can run today.

AI-Driven SQL Optimization: Using LLMs to Decode Execution Plans

July 14, 2026

Learn how to automate SQL tuning by feeding PostgreSQL Execution Plans into LLMs. This guide shows you how to reduce query costs by 85% and prevent production bottlenecks.