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 (20 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.

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.

Health & Performance<br>Index advisor, unused-index detector, slow query log, table bloat estimates, and DB connection/cache health — with copy-ready fix SQL.

Backup & Restore<br>One-click SQL dump, backup history list, and confirmed restore from any backup.

Cron & Scheduled Tasks<br>Manual trigger, run history, success-rate stats, and a setup guide for the server's system cron.

One-Click Demo Systems<br>Load a ready CRM, WMS, or Tasks dataset — with dashboards, calendars, workflows, views and automations pre-wired — to explore or reset instantly.

Built-in Documentation<br>Searchable in-app docs covering getting started, schema, grid features, admin panel, and...