Write standard SQL queries and watch Shaper turn them into interactive dashboards, scheduled reports, and customer-facing analytics widgets without maintaining a heavy business intelligence stack. Every query maps directly to a visual component through simple type casts like BARCHART, LINECHART, GAUGE, BOXPLOT, or DROPDOWN. Analysts can attach external PostgreSQL and MySQL databases, read Parquet, CSV, JSON, and Excel files straight from S3 object storage, or stream live events into the HTTP ingest API. Interactive filter controls let viewers slice metrics by date ranges, multi-select dropdowns, and dynamic parameter variables that automatically re-evaluate downstream charts. Teams version-control their entire reporting layer as plain SQL files in Git, making dashboard updates auditable in pull requests and simple for AI coding assistants to generate. Product engineers embed white-labeled analytics directly into customer web apps without iframes, issuing per-tenant JWT tokens to enforce row-level data isolation. Need scheduled deliverables for stakeholders? Configure SQL-driven background tasks that transform datasets on a cron schedule, send threshold alerts to Slack or Microsoft Teams, and generate downloadable PDF, PNG, Excel, or CSV reports. External collaborators can also view live metrics through password-protected sharing links. Running on a dedicated VPS on RepoCloud with guaranteed CPU, RAM, and SSD, full root SSH access, and a browser serial console. MPL-2.0 licensed.

Every DJI and Litchi flight you have ever logged becomes a searchable dashboard on your own server with Open DroneLog, a free, open-source alternative to DroneLogbook, Airdata UAV, and Flight Reader. Drop in DJI .txt logs, Litchi CSV files, or Airdata CSV exports and units are detected automatically, while deduplication on drone serial, battery serial, and start time lets you re-import a folder without duplicate flights. Each flight opens as a 3D terrain map with satellite, topographic, and OpenStreetMap layers, then replays from 0.5x to 16x speed with live telemetry and an RC joystick overlay. Synchronized charts plot height, speed, battery cell voltages, attitude, RC signal, GPS, and distance to home, with drag-to-zoom. Filters narrow flights by date, drone, battery, controller, duration, altitude, distance, tag, or map area, and automatic tags such as Night Flight and Low Battery arrive with offline reverse-geocoded locations. The overview dashboard adds an activity heatmap, per-drone and per-battery charts, and a cluster map. Battery health bars track cycle counts and capacity history, and maintenance thresholds show as color-coded progress bars. Export flights as CSV, JSON, GPX, or KML, build printable HTML flight reports that save as PDF, or generate a FlyCard image for social media. A sync folder imports new logs automatically, pilot profiles can sit behind passwords, and full-database backup and restore moves data between desktop and Docker. Running on a dedicated VPS on RepoCloud with guaranteed CPU, RAM, and SSD, full root SSH access, and a browser serial console. AGPL-3.0 licensed.