đī¸ 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.