Data Management

Momen provides powerful database management features, supporting everything from basic data operations to advanced custom database creation.

Data CRUD Operations

The platform provides an intuitive and convenient interface for real-time data operations.

System tables and system fields do not support modification.

Query: Select data tables or views in the left sidebar. Click the expand button on the left side of rows to view details, supports field filtering and sorting. Filter conditions are saved locally and cleared when the browser is closed.
Create: Click the “Insert Data” button to insert new rows.
Update: Click directly on cells to enter edit mode.
Delete: Select one or more rows and press the delete key to confirm deletion.

Custom Views

Custom views allow you to integrate related data tables for display, merging related data scattered across multiple tables into one view, simplifying data query and analysis processes.

Custom views are read-only and do not support direct data modification in views. To modify data, please return to the original data tables.
Too many related tables will affect query performance. It is recommended to reasonably control the number of relationships.
Deleting original data tables will cause related custom views to become invalid.

Use Cases

Related Data Display: View order information and customer details simultaneously
Data Export: Integrate multi-table data and batch export

Create View

Click the plus sign in “Custom Views” at the bottom left of the database to create, fill in the view name (recommend using descriptive names like “Order Customer Details”), and select the main base table as the data source.

Select Related Tables: Choose related tables that need to be displayed
Select Fields: Choose fields to display from base tables and related tables
Set Field Aliases:
- Set understandable aliases for fields (such as displaying “customer_name” as “Customer Name”)
- Avoid field name duplication conflicts

Save

Save the custom view after confirming everything is correct

Custom Database

Custom database is an advanced feature that allows project owners or administrators to filter data from the main database and create database subsets.

This feature is only available for Advanced and higher tier projects.

Create Custom Database

Create: Click the create button in the database management interface (only project owners or administrators can operate)
Name: Set a clear and unique name
Select Data: Check data tables and fields to include, set filter conditions

⚠️

You can only select original data tables, not existing custom views.

Use Database

After successful creation or being assigned permissions, you can view it in the database list. Upon entering, you’ll see a clean workspace containing authorized data. You can perform CRUD operations, create custom views, and other operations.

Permission Management

Custom databases inherit project permissions when created
After creation, permissions can be modified separately without affecting project permissions
Can generate exclusive sharing links for other users to access

Data Import and Export

Supports batch import of external data and export of standard format files for data migration and backup. See Data Import and Export for details.