DEV Community: Tomasz

OpenSparrow v2.6 – AI-powered search (RAG), bulk operations, and keyboard shortcuts

Tomasz — Thu, 28 May 2026 15:42:30 +0000

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.

OpenSparrow v2.3 – visual admin panel, zero dependencies, now with ERD and M2M support

Tomasz — Thu, 21 May 2026 20:49:14 +0000

Hey

OpenSparrow v2.3 is out. Quick recap if you missed earlier posts — it's an open-source admin panel framework built on PHP 8.1, PostgreSQL, and Vanilla JS. No npm, no Composer, no external libraries. You configure everything visually through /admin.

Live demo: demo.opensparrow.org

What's new

Schema Map (ERD) — visual diagram of your entire database with PNG export
Many-to-Many support — dedicated Builder tab, chip renderer in grids
Virtual computed columns — formula fields without touching the DB
Custom Views — save filtered/sorted perspectives per table
Record Ownership — track who handles what, full history
Performance tab — index advisor, slow query analyzer, bloat detection
Security hardening — 5 audit fixes, better session and input validation

Contributing

Looking for contributors — code, docs, or a short demo screencast.

opensparrow.org
github.com/wrobeltomasz/open-sparrow

OpenSparrow – open-source admin panel builder, zero dependencies, v2.1 just dropped

Tomasz — Sun, 17 May 2026 18:43:36 +0000

OpenSparrow – open-source admin panel builder, zero dependencies, v2.1 just dropped

Hey everyone!

I want to share a project I've been building — OpenSparrow, an open-source visual admin panel framework.

The idea: connect it to a PostgreSQL database, and you get a fully working admin panel — tables, forms, dashboards, calendar, file uploads — configured entirely through a visual /admin interface. No JSON to write by hand.

The stack is minimalist: PHP 8.1+, PostgreSQL, Vanilla JS. No npm. No Composer. No jQuery. No external libraries on either side. Pure code only.

What you get out of the box:

Visual table builder — create columns, set types, foreign keys, validation rules — all in the UI.
Full CRUD with inline cell editing, searchable FK columns, and subtables.
Dashboard builder — stat cards, KPI cards, bar/pie charts, and data lists with live WHERE filters.
Calendar view + cron-based notifications.
Audit trail + optional record snapshots (full JSONB history of every change).
User roles: Admin, Editor, Viewer.
Security defaults: rate limiting, CSRF, session fingerprinting, HSTS.

LGPL v3 — free for commercial use.

Version 2.1 just released with a major UX overhaul, new modules, and security fixes. More on that in the next post.

Feedback and contributors are very welcome!