wysiwyg database schema and ui builder with real-time synchronization
Provides a drag-and-drop interface for designing database tables, fields, and relationships without writing SQL, with bidirectional synchronization between schema definition and UI rendering. Uses a declarative schema model that maps to underlying relational databases (PostgreSQL, MySQL, SQLite) and automatically generates CRUD forms, tables, and views from field definitions. Changes to schema immediately reflect in the UI layer through event-driven updates.
Unique: Combines declarative schema definition with real-time bidirectional UI synchronization, allowing non-technical users to design databases and immediately see rendered forms/tables without intermediate code generation steps. Uses a plugin architecture for extensibility rather than hard-coded field types.
vs alternatives: Faster schema iteration than Airtable because changes propagate to UI instantly without page reloads, and more flexible than Salesforce because you own the infrastructure and can extend with custom plugins.
ai-assisted data model and workflow generation from natural language
Accepts natural language descriptions of business processes or data requirements and generates database schemas, field configurations, and workflow automation rules through LLM integration. The system parses user intent, maps entities and relationships, and scaffolds initial table structures, field types, and automation rules that users can then refine in the WYSIWYG builder. Supports multiple LLM providers (OpenAI, Anthropic, local models) via a pluggable provider interface.
Unique: Integrates LLM-based schema generation directly into the no-code builder workflow, allowing users to iterate between natural language prompts and visual schema editing. Uses a multi-step generation pipeline: intent parsing → entity extraction → relationship inference → field type assignment → validation rule suggestion.
vs alternatives: More integrated than ChatGPT + manual schema design because generation results are immediately editable in the WYSIWYG builder, and more reliable than pure code generation because it works within NocoBase's constrained schema model rather than generating arbitrary code.
webhook and external integration framework with event-driven triggers
Allows users to define webhooks that are triggered by database events (record creation, update, deletion) and send HTTP POST requests to external systems with record data as payload. Supports webhook filtering (only trigger on certain field changes), retry logic with exponential backoff, and webhook signature verification for security. Webhook delivery status and logs are stored for debugging.
Unique: Provides a declarative webhook system where users can define webhooks through UI without code, with automatic retry logic and delivery logging. Supports webhook filtering to trigger only on specific field changes.
vs alternatives: More flexible than Airtable's webhooks because it supports custom filtering and retry logic, and more reliable than manual API calls because it includes delivery tracking and automatic retries.
template and preset system for rapid application scaffolding
Provides pre-built application templates (CRM, project management, inventory, HR) that users can instantiate with a single click. Templates include schema definitions, views, workflows, and sample data. Users can customize templates after instantiation or create their own templates from existing applications. Templates are stored as JSON and can be shared across NocoBase instances.
Unique: Provides pre-built application templates that include schema, views, workflows, and sample data, allowing users to instantiate complete working applications in seconds. Templates are stored as JSON and can be customized or shared.
vs alternatives: Faster than building from scratch and more flexible than Airtable templates because you can customize all aspects (schema, views, workflows) and share templates across instances.
data import and export with format conversion and mapping
Supports importing data from CSV, Excel, JSON, and other formats with automatic schema detection and field mapping. Users can preview data before import, define field mappings, and handle data type conversions. Supports bulk export to CSV, Excel, and JSON formats with field selection and filtering. Import/export operations are logged and can be scheduled.
Unique: Provides bidirectional data import/export with automatic schema detection and field mapping UI. Supports multiple formats (CSV, Excel, JSON) and includes preview and validation before import.
vs alternatives: More flexible than Airtable's import because it supports custom field mapping and data type conversion, and more user-friendly than command-line tools because it includes a visual mapping interface.
formula and computed field evaluation with expression language
Allows users to define computed fields using a formula language that supports arithmetic, string operations, date functions, and conditional logic. Formulas are evaluated on-demand or cached depending on configuration. Supports referencing other fields in the same record and related records through relationships. Formula syntax is similar to Excel with functions like SUM, CONCAT, IF, etc.
Unique: Provides an Excel-like formula language for computed fields that users can define through UI without writing code. Formulas are evaluated on-demand and can reference other fields and related records.
vs alternatives: More user-friendly than database views because formulas are defined through UI, and more flexible than Airtable formulas because it supports custom functions and cross-table references.
workflow automation engine with trigger-action rules and conditional logic
Provides a visual workflow builder for defining automation rules triggered by database events (record creation, field updates, deletion) or external webhooks. Rules support conditional branching (if-then-else), loops, and actions including field updates, API calls, email notifications, and plugin-based custom actions. Workflows are stored as JSON configuration and executed by a server-side engine that maintains execution state and logs.
Unique: Combines visual workflow builder with server-side execution engine that maintains state and supports complex conditional branching. Uses a JSON-based workflow definition format that is both human-readable and machine-executable, allowing workflows to be version-controlled and migrated across instances.
vs alternatives: More flexible than Airtable automations because it supports arbitrary webhook calls and custom plugin actions, and more transparent than Zapier because workflows are self-hosted and fully auditable without vendor lock-in.
multi-view data presentation with grid, form, kanban, calendar, and gallery layouts
Automatically generates multiple presentation views of the same underlying data without duplicating data or creating separate tables. Supports grid (spreadsheet-like), form (record detail), kanban (column-based grouping), calendar (date-based), and gallery (card-based) views. Each view is configurable with filters, sorting, grouping, and field visibility settings. Views are stored as metadata and rendered on-demand from the same data source.
Unique: Generates multiple views from a single data source using a metadata-driven approach, where each view is a configuration overlay on the same underlying table rather than a separate data copy. Supports real-time synchronization across views so updates in one view immediately reflect in others.
vs alternatives: More efficient than Airtable because views share the same data source and don't require denormalization, and more flexible than traditional BI tools because views are designed for operational use (editable, real-time) rather than read-only reporting.
+6 more capabilities