LogoLogo
Release notesDocs homeFabricateTonic.ai
  • Tonic Fabricate User Guide
  • Fabricate workflow
  • Tutorial videos
  • Fabricate account
    • Getting started with Fabricate
    • Fabricate license plans
    • Managing your Fabricate account and profile
    • Managing users in your account
  • Databases
    • Supported database types
    • Creating and managing databases
  • Backing up and restoring the database definition
  • Configuring database variables
  • Exporting data from a database
  • Tables and columns
    • Managing database tables
      • Configuring table settings
      • Adding a table to a database
      • Removing a table from a database
      • Attaching static data to a table
      • Regenerating table data
  • Managing table columns
    • Adding and removing columns
    • Configuring a column
    • Generator reference
      • Calculated or related values
      • Data type and specific values
      • Names and other identifying information
      • Telephone numbers and email addresses
      • Geographic locations
      • Air travel
      • Natural science
      • Networks and files
      • Banking and finance
      • Dates and times
      • Vehicles
      • Companies and products
      • Healthcare and health insurance
      • Languages
      • Movies
      • Education
  • Views
    • Creating and managing views
    • Views reference
  • Workspaces
    • About workspaces
  • Creating and managing workspaces
  • Database mock API
    • About mock APIs
    • Defining a mock API
    • Creating and querying database snapshots
  • Mock API reference
  • Fabricate API and CLI
    • About the Fabricate API and CLI
    • Managing Fabricate API keys
    • Daily limits on generated data
    • Using the Fabricate API
      • Authentication for the API
      • Data model
      • Managing databases from the API
      • Generating data from the API
    • Using the Fabricate CLI
      • Setting up CLI access
      • Using the CLI to load data
Powered by GitBook
On this page
  • Starting a new database
  • Selecting a database to manage
  • Cloning an existing database
  • Changing the database name and type
  • Deleting a database
Export as PDF
  1. Databases

Creating and managing databases

Last updated 2 hours ago

If you have multiple workspaces, then before you create or edit a database, make sure that you are in the correct workspace.

To change to a different workspace, in the user menu, click Switch Workspaces, then select the workspace.

Starting a new database

To start a completely new database:

  1. Click the database dropdown at the top right, then click New Database.

  1. On the Create a New Database panel, in the Database Name field, provide a name for the database.

  2. From the Type dropdown list, select the database type.

  3. Optionally, in the Create Tables Script, provide a SQL script to use to set up the initial database tables and columns.

  4. Click Create Database.

Fabricate displays the database details page for the database.

Selecting a database to manage

To select a database to manage:

  1. Click the database dropdown at the top right.

  2. In the dropdown list, select the database.

Cloning an existing database

You can create a new database based on an existing database. The new database inherits all of the configuration from the original database.

To clone a database:

  1. Select the database to clone.

  2. In the database header, click Clone Database.

  3. On the Clone Database panel, in the New Database Name field, provide a name for the new database.

  4. Click Clone Database.

Changing the database name and type

From the database Settings tab, you can change the database name and type.

  1. In the Name field, provide the new database name.

  2. From the Type dropdown list, select the new database type.

  3. Click Save Changes.

Deleting a database

To delete a database, on the database Settings tab:

  1. Click Delete Database.

  2. On the confirmation panel, click Delete Database.

Database dropdown with the New Database option
Name and Type fields on the Database Settings tab