Arpia Codex in Data Objects

The Arpia Codex Assistant in the Data Objects module streamlines the creation and management of database structures. By interpreting user requirements, it automatically generates the necessary SQL code for creating Tables and Views, saving time and reducing manual effort. It is possible to create multiple objects in the same request by providing a detailed prompt specifying the requirements for each object.

Here is an example where the assistant is requested to create two tables, one for Products and one for Customers, using the following prompt:

I need a Table called products to store details about the items we sell. It should include:
    A unique ID for each product.
    The product’s name.
    A short description.
    Its price.
    The available stock.
    The date it was added.

I also need a Table called customers to store information about our clients. It should include:
    A unique ID for each customer.
    Their full name.
    Their email address.
    Their phone number.
    Their registration date.

The assistant will allow us to select the tables we want to be created, after which the creation process will proceed by clicking the button Create Object In Repository.

Documentation Screenshot

The image below shows the final state after the assistant has analyzed the DDL and is ready to create the selected tables in the repository.