The Fabricate Data Agent, which uses an AI chat to create and configure databases, is now available to all users.
As of now, all new Free and Plus accounts must use the Data Agent for all of their databases. The previous database configuration option, now referred to as rule-based databases, is only available to Enterprise users.
Fixed an issue where international addresses were assigned US street names.
Fixed an issue with opening an exported database file.
Added functionality to the beta Data Agent databases feature, including:
- Ability to generate Finish Personal Identity Codes (PICs)
- Ability to generate credit card data
- Ability to generate MongoID object identifiers
- Ability to upload .jpg and .png image files. For example, to provide a template for generating files from database data.
- Ability to generate PowerPoint files
- Ability to export the database to a JSON array
You can now use the Fabricate API to retrieve and download Data Agent databases.
From the Fabricate application, users can now delete their Fabricate account.
Users who try to sign up now receive a notification if the email address is already associated with an account.
The beta Data Agent feature now allows you to upload files as input.
The Admin Console now displays the Fabricate version number.
Fixed an issue where you could not delete a database if it had a variant.
Fixed an issue where new users on a self-hosted instance started a free trial.
Fixed an issue where users could not download exported data.
For the beta Data Agent database feature, added environment variables for self-hosted instances to provide an Anthropic API key and URL. The Data Agent uses Claude from Anthropic.
For the beta Data Agent feature, you can now prompt the Data Agent to use database data to populate PDFs, Word files, and email messages. For example, "Use the order data to produce example order confirmation email messages" or "Create an invoices database and create 5 example invoice PDFs". The Data Agent provides links to download the files.
Data Agent databases (Beta) - The Fabricate Data Agent is an AI chat interface that you use to create and define a set of data. You use the chat to make any adjustments to the data structure and content. The Data Agent asks questions as needed to clarify the request, then generates SQL and JavaScript to implement the changes. You can also run SQL queries to add or edit data, and can also edit values in individual cells. You can export the data from a Data Agent database to CSV, JSONL, SQLLite, SQL Server, or PostgreSQL.
When you create a database, Fabricate prompts you to decide whether to create a Data Agent database or a rules-based database, which is the original type of Fabricate database where you define rules for generating the data.
The Data Agent database feature is currently in beta and can be activated for specific Cloud customers. To request access to the Data Agent database feature, contact Tonic.ai.
The Professional plan is renamed to Plus. We also improved notifications and handling for free trials that are ending.
Fixed an issue with using the burndown option.
Fixed an issue where rows did not render correctly.
Fixed an issue where child fields could not refer to a field in a parent table because the field was not yet created.
The option to clone a database is moved from the database header to the Settings tab.
The Add Table(s) button is now a dropdown menu that contains the table creation options.
The new table creation menu includes a From SQL query option. This replaces the option to create what was once called a view, and is now referred to as a SQL table.
In the table creation menu, the new Generate static data using AI option allows you to create a static data table from an AI prompt. The new option generates a CSV file that you can download.
Self-hosted customers can now enable v2 signatures for Amazon S3. By default, Fabricate uses v4 signatures. To enable v2 signatures, set the environment variable FABRICATE_S3_SIGNATURE_VERSION=2.
Fixed an issue with setting the data type when exporting a column that contains numeric values, but that has a data type of string.
The new Markov Chain generator populates a column based on a configured set of available flows between values.
Fixed an issue with the display the Prevalence value for the Foreign Key generator.
Fixed an issue with the display of unstructured data values for CSV and JSON databases.
New Fabricate interpolation variables for SQL - You can now use the following variables when you use SQL in a column definition:
- {{parent(n)}}gets the nth parent of the column. Both {{parent}} and{{parent(0)}} retrieve the immediate parent.
- {{root_table}} gets the root table of an object or array.
For a Foreign Key generator that uses the Until column <= 0 distribution type, you can now configure whether to generate a foreign key for the first value of 0 or less.
Fixed an issue with importing tables when there were multiple spaces between CREATE and TABLE.