Creating Data Tables
Create data table models for JitAI applications. Define structure, data types, and constraint rules from scratch or existing tables.
Creating Data Table Elements from Existing Database Tables
Generate data models from existing database tables. Quickly create JitAI models for legacy database architectures with field mapping.
Built-in Data Management Tools
Visual data management tools for CRUD operations. Filter, add, edit, delete, batch modify, import, and export data without coding.
Creating Data Model Functions
Create custom data model functions for business logic. Encapsulate functions within models with parameters, return values, and visual editor.
Aggregated Table Model
Build aggregated table models for complex data analysis. Associate, merge, and calculate multiple tables for statistical scenarios.
Extension Table Model
Extend data tables with business fields through flexible associations. Multi-table data integration without modifying base table structure.
Data Object Models
Design data object models for full-code development. DTOs for structured data expression without direct database table mapping.
Using Data Models in Pages and Functions
Use data models in pages and functions. Built-in CRUD functions, custom model functions, and dynamic data operations for business logic.
Calling Data Models with AI Agents
Invoke data models with AI Agents. Add model functions as Agent tools for intelligent CRUD operations and automated data processing.
Managing Database Connections
Manage database connections across multiple instances. Configure MySQL, PostgreSQL, Oracle, SQL Server, and more for different scenarios.
Supported Database Vendors
Supported database vendors in JitAI. Connect to SQLite, MySQL, PostgreSQL, Oracle, SQL Server, and DM8 with unified interface.
Transaction Management
Database transaction management with JitORM. Default transaction handling, manual commit/rollback, and transaction decorator for atomicity.