OpenSparrow v2.6 is out. This one's a big step forward — RAG (Retrieval-Augmented Generation) integration, bulk grid operations, and a whole new UX layer.
RAG & AI integration
You can now upload documents and let users ask questions against them. The system retrieves relevant sections and generates answers using an LLM (supports Ollama locally or any OpenAI-compatible API).
What's new:
RAG Statistics tab in admin — tracks query tokens, response times, document matches, and recent queries
Multilingual auto-response — user questions are answered in their own UI language, no schema changes needed
20-language support — "Ask AI" panel fully translated, plus language dropdown in the test interface
Good for things like: knowledge base Q&A, customer support automation, or letting internal teams ask questions about their own data.
Grid & bulk operations
Mass Edit module — select rows via checkboxes, bulk edit fields, change owners, duplicate, or delete with one click
Keyboard shortcuts — arrow keys to navigate, Tab, Ctrl+C to copy, Ctrl+F to search, Ctrl-hold for help modal — works across all 20 languages
Quick Data Cleanup toolbar — find & replace with live preview, case sensitivity, accent-ignore. Editor-gated with audit trail.
Admin improvements
Renamed "RAG Knowledge Base" to "Centrum AI" (heading is translatable)
Migration Manager — tracks pending cleanup tasks after version upgrades, with automatic backups and audit trail
FK columns render as dropdowns in forms by default
Security & Quality
All bulk operations (mass edit, cleanup, delete) are editor-role gated
CSRF protection on every operation
Full audit trail — every change is logged
20 languages fully supported across all new modules
Fixed regressions in RAG API and CSV import
Following this series?
OpenSparrow v2.3 – visual admin panel, zero dependencies, now with ERD and M2M support
OpenSparrow – open-source admin panel builder, zero dependencies, v2.1 just dropped
Websites
opensparrow.org
github.com/wrobeltomasz/open-sparrow
demo.opensparrow.org
What AI features would be useful in your own projects? Drop your thoughts in the comments.