Visual App Design
Visual App Design
Visual Application and Data Model Definition
Field Definition Tool
Field Definition Tool
Advanced Field Definition and Configuration
Entity Configuration
Entity Configuration
Granular Model Configuration
DB Connectivity
DB Connectivity
Database Abstraction and Connectivity
Schema Generator
Schema Generator
Automated Schema Generation & Management
Model Data Tools
Model Data Tools
Rich Data Operations (CRUD & Import/Export)
Admin Docs
Admin Docs
Platform configuration, roles, permissions and administration guides.
Developer Docs
Developer Docs
Technical documentation for extending and integrating the platform.
API Reference
API Reference
Complete API endpoint documentation with request/response examples.
Tutorials
Tutorials
Step-by-step tutorials to help you build and deploy applications.
Recipes
Recipes
Ready-to-use implementation examples and practical use cases.
REST API
REST API
Detailed REST API documentation for integration and automation.
AboutRequest a Demo →
ProductVisual App BuilderField Definition
Core Capability — Data Modeling

Every data type.
Zero compromises.

Define fields with precision using 20+ distinct types, granular configuration options, built-in validation, and intelligent defaults — all without touching a line of code.

20+Field Types
0Lines of Code
Combinations
SolidX — Add Field to Student Master
Short Text — Pick a Variant
T
Standard
🔤
Slug
@
Email
🔢
Phone
Field Preview
Student Full Name *
e.g. Priya Sharma
RequiredUnique
🔢
20+ Field TypesNumeric, text, media, relational, computed & more
Built-in ValidationRequired, unique, min/max, pattern rules — no code
AI Field AssistDescribe your field in plain English, AI configures it
🔗
Relational Fields1:1, 1:N, M:N — visual relationship builder
Field Type Library

The right type for every kind of data

SolidX maps to real database column types while abstracting away the complexity. Choose from purpose-built types that include not just storage format, but interface, validation, and display logic — all in one selection.

  • Numeric types cover Integer, Big Integer for monetary values, and Decimal for floating-point precision
  • Text types include Short Text (up to 1000 chars), Long Text for addresses, and Rich Text for HTML-formatted content
  • Date & Time gives you Date, DateTime, and Time separately so you store exactly what you need
  • Boolean & JSON for true/false flags and complex structured data objects
  • Media fields with support for image, audio, video, and generic files — single or multiple
Select Field Type
🔢
Integer
INT
Big Integer
BIGINT
π
Decimal
DECIMAL
T
Short Text
VARCHAR(1000)
Long Text
TEXT
H
Rich Text
LONGTEXT
📅
Date
DATE
DateTime
DATETIME
🖼
Single Media
FK → media
Field Configuration — admission_number
📋 Basic Info
Display NameAdmission Number
DB Columnadmission_no
DescriptionUnique school-issued ID
Default Value(auto-generate)
🔒 Constraints2 active
RequiredYes
UniqueYes
Max Length20 chars
Pattern[A-Z]{2}[0-9]{6}
👁 Display Config
Visible in ListYes
SortableYes
SearchableYes
Granular Configuration

Configure every attribute, without code

Each field comes with a deep configuration panel that lets you set default values, constraints, display labels, database column names, and business rules — all through a clean, structured UI. No SQL, no migrations to write manually.

  • Display Name vs Column Name — decouple what users see from how it's stored in the database
  • Default Values — set sensible fallbacks so records are never empty by accident
  • Required & Unique constraints — enforced at both UI and database level
  • Min / Max rules — character limits for text, value ranges for numerics, size limits for media
  • Description / Hint — in-form help text that guides end users when filling records
Specialized & Relational

Advanced types for complex real-world data

Beyond the basics, SolidX provides specialized field types for common enterprise patterns — computed values, dynamic dropdowns, GUID generation, and relational links between models — all configurable without writing a single migration or query.

  • Computed Fields — dynamically calculate values using providers (e.g., auto-compute age from date of birth)
  • Static Selection — dropdown with predefined key-value pairs you define visually
  • Dynamic Selection — dropdown populated from external APIs or data providers at runtime
  • GUID / UUID — globally unique identifiers, auto-generated or manually assigned
  • Relational Fields — visual builder for 1:1, 1:N, and M:N relationships between any two models
Model Relationships — School Fees Portal
🎓 Student Master
admission_nofull_namedate_of_birth→ fee_records
1
1:N
N
💳 Fee Record
fee_amountdue_datepayment_status← student
⚙ Computed FieldProvider
FormulaNOW() - dob
Output TypeInteger (years)
StoredNo (virtual)
Validation Rules — Student Master
T
full_name · Max 1000 chars
🔢
admission_no · Pattern match
📅
date_of_birth · Date · Required
@
parent_email · Email format
💰
fee_amount · Decimal · Min: 0
⚠ Error
parent_email: invalid format
✓ 4 of 5 rules passed
All constraints enforced at API level
Built-in Validation

Business rules enforced at zero cost

Validation logic that would typically require custom backend code is configurable directly in the field setup — no middleware, no extra validation layer, no duplicated logic between front-end and back-end.

  • Pattern validation — regex-based rules for formatted inputs like IDs, codes, and phone numbers
  • Range constraints — min and max values for numeric fields enforced at save time
  • Email format validation — built into the Email field type with pre-population support
  • Pre-population options — auto-fill fields using $CURRENT_USER, $NOW, or custom providers
  • All validation runs at both UI and database level — no silent data corruption
All Field Types

20+ types for every use case

From simple text inputs to computed relational values — every type you need to model any enterprise data structure, without custom code.

🔢
Integer
Whole numbers for counts, ages, quantities
INT
Big Integer
Large values like monetary amounts and timestamps
BIGINT
π
Decimal
Precise floating-point values for financial calculations
DECIMAL(10,2)
T
Short Text
Names, titles, codes, and labels up to 1000 characters
VARCHAR(1000)
Long Text
Addresses, notes, descriptions, and multi-line plain text
TEXT
H
Rich Text
HTML-formatted content with WYSIWYG editor
LONGTEXT (HTML)
📅
Date
Calendar dates without time — for birthdays and deadlines
DATE
DateTime
Full timestamps for events, logs, and time-aware records
DATETIME
🕐
Time
Time of day only — for schedules and operating hours
TIME
Boolean
True/false flags for toggles and binary attributes
TINYINT(1)
{ }
JSON
Store arbitrary structured data objects and arrays
JSON
🖼
Single Media
One file or image — supports all file types
FK → media_files
⋮⋮
Multiple Media
Attach multiple files per record — galleries and documents
M2M → media_files
Static Selection
Dropdown with predefined label/value pairs
VARCHAR / ENUM
Dynamic Selection
Dropdown populated from external APIs at runtime
VARCHAR (ref)
@
Email
Email addresses with format validation and pre-population
VARCHAR(320)
ƒ
Computed Field
Auto-calculated values from other fields
Virtual (no column)
GUID / UUID
Globally unique identifiers — auto-generated or manual
CHAR(36)
1→N
One-to-Many
Link one record to multiple related records
FK relationship
N→1
Many-to-One
Link multiple records back to a single parent
FK column
M:N
Many-to-Many
Connect two models through a junction table
Junction table
How It Works

From field concept to database column in seconds

Whether you define fields manually through the visual panel, or let the AI Agent build them from a plain English description — SolidX keeps the process fast and error-free.

01

Describe your field or pick a type

Click "Add Field" in any Model, then either select from the type library visually — or describe what you need to the AI Agent in plain English.

02

Configure display, database, and constraints

Set the Display Name, database column name, default value, required/unique toggles, min/max rules, and any pattern validation.

03

Set up relationships visually

For relational fields, use the visual relationship builder to define the linked model and cardinality (1:1, 1:N, M:N).

04

Save — schema updates instantly

Click Save. SolidX runs the migration, updates the JSON schema, regenerates the API endpoints, and rebuilds the form in the Layout Builder.

Ready to model your data?

Define your first field in under 60 seconds

No setup required. Open SolidX, create a Model, click Add Field, and start building your data layer — the right way.

npx @solidxai/solidctl@latest create-app