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.

20+Field Types
0Lines of Code
Combinations
🔢
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.

  • Numeric types cover Integer, Big Integer, and Decimal for floating-point precision
  • Text types include Short Text, Long Text, and Rich Text for HTML-formatted content
  • Date & Time gives you Date, DateTime, and Time separately
  • Boolean & JSON for true/false flags and structured data objects
  • Media fields with support for image, audio, video, and generic files
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.

  • Display Name vs Column Name — decouple what users see from database storage
  • Default Values — set sensible fallbacks
  • Required & Unique constraints — enforced at both UI and database level
  • Min / Max rules — character limits for text, value ranges for numerics
  • Description / Hint — in-form help text for end users
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.

  • Computed Fields — dynamically calculate values using providers
  • Static Selection — dropdown with predefined key-value pairs
  • Dynamic Selection — dropdown populated from external APIs
  • GUID / UUID — globally unique identifiers
  • Relational Fields — visual builder for 1:1, 1:N, M:N relationships
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.

  • Pattern validation — regex-based rules for formatted inputs
  • Range constraints — min and max values for numeric fields
  • Email format validation — built-in with pre-population support
  • Pre-population options — auto-fill using $CURRENT_USER or $NOW
  • All validation runs at both UI and database level
All Field Types

20+ types for every use case

From simple text inputs to computed relational values — every type you need 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 or let the AI Agent build them from plain English — 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.

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 — all in real time.

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.

npx @solidxai/solidctl@latest create-app