Download Latest Version 3.2 - Per-User Access Control, Materialized Views in RAG, and a Business Design Refresh source code.zip (1.6 MB)
Email in envelope

Get an email when there's a new version of OpenSparrow

Home / 3.1
Name Modified Size InfoDownloads / Week
Parent folder
opensparrow-3.1.zip 2026-08-05 1.3 MB
opensparrow-3.1.zip.sha256 2026-08-05 86 Bytes
3.1 - RAG assistant using views, n8n Automations, Record Image Galleries, and Workflow Stored Procedures source code.tar.gz 2026-08-05 1.2 MB
3.1 - RAG assistant using views, n8n Automations, Record Image Galleries, and Workflow Stored Procedures source code.zip 2026-08-05 1.6 MB
README.md 2026-08-05 2.5 kB
Totals: 5 Items   4.1 MB 7

Added

  • n8n automation webhooks — Automations admin split into Record and n8n tabs; a rule can now fire a webhook to an n8n workflow, with credentials encrypted at rest.
  • Record image galleries — configure an image column per table; records show grid thumbnails and an upload gallery on the edit form. Full Cypress E2E coverage.
  • Workflow PostgreSQL procedure step — workflow steps can call a stored procedure as part of a guided flow, alongside the existing table-form and image-upload step types.
  • Grid conditional row highlighting — schema-configured highlight rules color grid rows by column condition (e.g. overdue/high-value records).
  • Optional CRM demo install from the first-run setup wizard.
  • Notes reminders now support a date and time (previously date-only).
  • Grid: vertical column hover highlight alongside the existing row highlight; solid accent header fills replacing pill labels.
  • COMMENT ON descriptions added to all spw_* system tables via the 3.1_table_comments migration.

Changed

  • RAG assistant now builds grid context directly from the data model and fences page data in the prompt; hardened localized no-answer/partial-answer prompt behavior.
  • Admin docs limited to English and Polish; placeholder/unmaintained locale docs dropped.
  • Admin JS modules are now lazy-loaded and cache-busted via import map versions on every upgrade, fixing stale-JS issues after updates.
  • Record creation now redirects straight to the edit view with the Files/Images tab open.

Fixed

  • FK grid cell tooltip getting stuck open over a datalist; unreliable text selection on cell focus.
  • Truncated child-record labels in grid drill-down rows and truncated action buttons in edit.php subtables.
  • Admin JS init races and stale ETL/Images Cypress test selectors; anonymization config reset on demo seed.

Security

  • All admin write actions guarded by require_not_demo(), closing a DEMO_MODE bypass present in five admin actions.
  • Additional CSRF and demo-mode gaps closed in admin config/cron/migrations actions.
  • License compliance pass: SPDX headers across source files, NOTICE file, canonical FSF license texts, and initials-on-color generated avatars replacing bundled stock demo photos.

Full changelog: https://github.com/wrobeltomasz/OpenSparrow/compare/3.0...3.1

Download OpenSparrow

Source: README.md, updated 2026-08-05