Adding a local database to a project

A local database stores the data in Tonic Fabricate.

Size limits based on license plan

For a local database, the maximum size is determined by your license plan:

• Free plan - 256 MB

• Plus plan - 1 GB

• Enterprise plan - 5 GB

Fabricate displays a warning when the size of a database reaches 80% of the maximum.

Adding the database

To add a local database to a project:

1. In the navigation panel, click the project options menu.

Project options menu with the option to add a local database

1. Under Databases, click New database.

2. On the new database panel, in the Database name field, provide a name for the new database.

3. Click Create database.

You can also use the Data Agent chat to add a database to the project. For example:

Add a new database called Health records to the project.

Defining the structure of the database

For a local database, you define the structure of the data to create.

Depending on the number of tables in the schema, the Data Agent can automatically switches to Plan mode. It creates a plan to create the database, which you can then review and execute.

To add data to a local database, you can prompt the Data Agent or import a set of static data.

Data Agent instruction

One option is to provide a prompt with a simple instruction. For example: Create a database of consumer transactions. The database includes transactions, customers, and products.

Pasted schema

You might paste in a specific schema for the Data Agent to use. For example: Create a database of consumer transactions that uses the following schema.

Uploaded files

You can also upload files to provide information for the Data Agent to use.

For example, instead of pasting in the schema, you can upload a file, drag and drop the file to the Data Agent, or click the attachment icon.

Examples of schema files include:

• QL DDL scripts

• prisma.schema scripts

• Swagger YAML API definitions

Based on an exported profile

If you exported a profile from another database, you can attach the profile and use that as the basis for the database. For example: Create a database from the attached profile.