Lightdash vs NocoDB
Side-by-side trajectory, velocity, and editorial themes.
Lightdash chips away at the SQL barrier with NL-to-formula table calcs and metric-tree visualization.
The release cadence is high and the work spans three areas: lowering the technical barrier (spreadsheet-style formulas in table calculations, plain references to grand totals), enriching what a chart and dashboard can express (color palettes at every scope, row/column limits, rich-text table cells), and self-serve operability (default user spaces, expiring preview projects, dashboard-version rollbacks that include chart configs). The Canvas now hosts persistent metric trees, hinting at a heavier semantic-layer story.
Lightdash is positioning between a dbt-native semantic layer (where SQL-fluent analysts live) and a self-serve BI tool (where business users live). The intent-driven formula editor and reference-total functions chip away at the SQL prerequisite for table calculations, while Saved Trees push the metric model into something visually editable. Underneath, the platform is doing the unglamorous self-serve work — personal spaces, palette hierarchies, preview hygiene — that BI products need to survive in larger orgs.
Expect the formula editor to grow into broader AI-assisted authoring (filters, joins, custom dimensions) and Saved Trees to evolve into a more general semantic-layer view that consumes from dbt and produces governance artifacts. Color and palette work suggests embedded/customer-facing BI ambitions next.
NocoDB shifts from spreadsheet-database into a multi-surface workspace with a clearer paid tier.
NocoDB is on a tight release cadence with substantial feature drops layered on top of the database. April introduced Map View, three new field types (UUID, GeoData and others), and NocoDocs — a real document editor that sits next to the data. May has continued with multi-column form layouts, Postgres ENUM mirroring, Bookmarks for cross-workspace context, Smart Text fields, and Mermaid diagrams inside NocoDocs. The release notes now consistently split features across CE/Free vs Paid/Enterprise.
NocoDB is repositioning from 'Airtable alternative with a database' to a multi-surface workspace — table + form + map + timeline + docs — with an explicit open-core monetization split. The Self-Serve Self-Hosted Licensing flow shipping in 2026.05.1 closes the buying loop for enterprise self-hosters. AI-flavored features (Smart Text) are starting to appear but are not yet the headline pitch.
Expect the open-core split to deepen and more AI-aware field types to spread across surfaces. Given how integration-shaped the Postgres ENUM and webhook work has been, a richer agent-addressable API or an explicit MCP integration is a plausible next move.
See more alternatives to Lightdash →
See more alternatives to NocoDB →