OpenSparrow - Open-Source Schema-Driven Platform

EN<br>PL<br>DE<br>FR<br>IT<br>ES<br>RO<br>EL<br>HU<br>CS<br>SV<br>PT

Build CRUD Applications Without Code

Define your data in JSON, get a production-ready dashboard, calendar, and workflows instantly. Self-hosted. Open-source. No vendor lock-in.

Self-Hosted<br>Open Source (LGPL v3)<br>No Vendor Lock-in<br>193 Automated Tests<br>GDPR / WCAG Compliant<br>AI-Ready (Local RAG)<br>Deploy Anywhere

View Demo<br>GitHub

OpenSparrow is an open-source, self-hosted PHP + PostgreSQL platform with a vanilla JS frontend. Define your tables and relations in JSON — the platform generates grids, forms, dashboards, calendars, and workflows automatically. No vendor lock-in, full data ownership.

Platform Features

Everything you need to build production-grade internal apps — no coding required

Data & Records

Views & Analytics

Admin & Schema

Security & Collaboration

AI & Automation

Integrations

Developer Experience

Data Management<br>Advanced Data Grid

Inline editing, error validation, status coloring, global search, and CSV export.

Data Structure<br>Nested Relations

Support for "Drilldown" views to display nested data and sub-tables inside a record view.

Data Relations<br>Many-to-Many Grid Support

Edit M2M junction tables directly in the grid without writing code. Visual junction table management with automatic relationship tracking.

Calculated Fields<br>Computed/Virtual Columns

Define formula-based calculated fields without database migrations. Display computed values in grids in real-time.

Grid & UX<br>Mass Edit & Bulk Operations

Select rows via checkboxes and bulk edit fields, export CSV, assign owners, duplicate, or delete with confirmation. New grid keyboard shortcuts (arrows, Tab, Ctrl+C, Ctrl+F) across all languages. Quick Data Cleanup toolbar: find & replace with live preview, case sensitivity, accent-ignore options.

Record Detail<br>Tabbed Record Editor

Every record edit view is split into Main fields, Subtables, Files and Comments tabs — related data without leaving the page.

Full Keyboard Navigation<br>Arrow keys, Tab, Home/End, Page Up/Down, Shift-select ranges, Ctrl+C/V clipboard, and a shortcut help overlay (hold Ctrl).

Find & Replace<br>Regex-capable data cleanup with live before/after preview, case-insensitive and accent-insensitive matching.

3-Step CSV Import Wizard<br>Upload, drag-and-drop column mapping, then upsert on a unique column with a per-row error report.

Row Actions & Subtables<br>Edit, duplicate, delete per row; expandable subtables show related child records inline.

Analytics<br>Dashboard Engine

Generate KPI widgets, interactive lists, and bar charts that aggregate live database data.

Scheduling<br>Calendar & Notifications

Date-based records on a visual calendar with color-coded sources and scheduled reminders via cron.

UI & UX<br>Board (Kanban) View

Visualize records as draggable cards organized in status lanes. Instant column updates with audit trail and ownership enforcement. Configure from admin Board tab; CRM demo includes ready-made Deals Board. Full i18n support (12 languages).

Data Organization<br>Custom Views & Presets

Save filtered and sorted grid views as named presets. Share views across your team without duplicating data.

Visualization<br>Schema Visualizer (ERD)

Entity-Relationship Diagram in the admin panel. Visualize table relationships and dependencies at a glance.

Global Date Filter<br>One date-range control drives every widget on a dashboard at once.

Conditional Widgets<br>Show or hide dashboard widgets based on field-value conditions.

Dashboard Period Filter<br>Apply one global period filter across every dashboard widget, see automatic deltas versus the previous period on KPI cards, and export any widget's data to CSV.

Per-Source Calendar Filter<br>Toggle individual record sources on and off from a filter bar above the calendar, so you only see the event types you care about.

Administration<br>Visual Admin Panel

Configure schemas, form layouts, columns, and relations via GUI without writing code.

Administration<br>Admin Panel Redesign

The admin UI has been completely rebuilt with card-based editors for cleaner form layouts, an inline item panel for faster configuration, inner-tabs for better information organization, and a refactored visual hierarchy.

Schema Evolution<br>Database Migrations System

Version-control your schema changes. Create, apply, and rollback migrations through the admin UI without raw SQL.

Admin<br>Release Migration Manager

Automated version upgrade management with audit trail and automatic backups. Detects pending file and config cleanup tasks after upgrading — no manual steps required. Secure CSRF-protected operations, editor-role gating, and full audit logging.

Reporting<br>Print Templates

Build printable reports (quotes, invoices, labels) from heading, text and table blocks bound to a PostgreSQL view. Renders on an A4-style sheet with automatic pagination, repeated table headers, and optional parameter filters.

Health & Performance<br>Index advisor, unused-index detector, slow...