OpenSparrow v3.1 - RAG assistant, Record Image Galleries, and Workflow Stored Procedures

#php #lowcode #rag #opensource

Automation rules can now call out to n8n, the RAG assistant can answer exact aggregate questions via admin-configured views, tables can have their own image galleries, workflow steps can run a PostgreSQL stored procedure, and the grid gets conditional row highlighting.

Automations: n8n webhooks

The Automations admin is now split into two tabs - Record (the existing field-update/notification/create-record rules) and n8n. The n8n tab lets a rule fire an outgoing webhook to an n8n workflow instead of (or alongside) the built-in actions, with webhook credentials encrypted at rest. Useful for handing off to Slack, email marketing, or any of the hundreds of services n8n already integrates with, without writing custom PHP.

RAG assistant: aggregate views

The AI assistant used to be limited to whatever was on the current grid page, so it had to refuse "how many / total" questions about the whole table. In 3.1, an admin can attach a PostgreSQL view (schema.view) to a table under RAG settings - a pre-vetted, read-only aggregate query. When that table's page is open, the assistant runs the view (capped at a configurable row limit) and gets the exact figures fenced into the prompt as authoritative data, separate from page content and record text.

The model still never writes or chooses the query itself - it only ever sees the output of a view an admin explicitly configured, with an extra guard that skips owner-restricted tables since a plain view has no per-user filter. The result: questions like "what's the total invoice value this quarter" get an exact answer instead of "I can only see this page."

Record image galleries

New per-table image galleries - configure an image column and records show a thumbnail strip in the grid plus an upload gallery on the edit form.

Comes with full Cypress E2E coverage and demo data (contact photos in the CRM demo).

Workflow steps: PostgreSQL procedure hook

Workflow steps can now call a PostgreSQL stored procedure as part of a guided flow, in addition to the existing table-form steps. The CRM demo ships a worked example. Combined with the record-image upload option added to workflow steps, workflows can now do a lot more than collect form fields.

Grid: conditional row highlighting

Schema-configured row highlight rules color entire grid rows based on column conditions - e.g. flag overdue invoices or high-value deals at a glance - seeded with an invoice example in the CRM demo.

Grid hover/crosshair styling was also reworked: a vertical column highlight alongside the existing row highlight, solid accent header fills, and a fix for the FK cell tooltip getting stuck over open dropdowns.

Also in this release

Notes reminders now take a date and time, not just a date
Optional CRM demo install directly from the first-run setup wizard
RAG: grid context now built from the actual data model and fenced in the prompt, with a hardened no-answer/partial-answer prompt
Security: all admin write actions are now guarded by require_not_demo(), closing a demo-mode bypass in five admin actions; additional CSRF/demo-mode gaps fixed
License compliance pass: SPDX headers, NOTICE file, canonical FSF license texts, and initials-on-color avatars replacing bundled stock photos
spw_* system tables now carry COMMENT ON descriptions for easier DB introspection