​
Working with Databases

The Databases section of the Data Catalog allows you to register databases, creating metadata representations that point to your actual database instances. This provides a structured view of your database contents and enables you to use them in other parts of Kosmoy Studio, such as Data Channels and Vector Pipelines.

Prerequisites:

Before registering a database, you must have a corresponding Connection configured. Refer to the Connections section for details.

​
Supported Database Types

Kosmoy Studio currently supports the following database types:

  • SQL Databases:
    • PostgreSQL
  • Vector Databases:
    • PGVector
    • Weaviate
    • Pinecone

​
Registering a Database

  1. Navigate to Databases: From the Kosmoy Studio home page, click on the “Data Management” menu in the left-hand navigation bar, then select “Data Catalog” and then click on “Databases”.

  2. Add a New Database: Click the ”+ ADD” button located in the upper right corner of the Databases section.

  3. Select Database Type: Choose either “SQL” or “Vector”.

  4. Select Connection: From the dropdown menu, select the appropriate pre-configured Connection for your database.

  5. Configure Database-Specific Settings:

    • For SQL Databases (e.g., PostgreSQL): Define the Access Control Rules:
      • Read Access: Grant read access to the database.
      • Write Access: Grant write access to the database.
      • Both: Grant both read and write access.
    • For Vector Databases: No additional configuration is needed at this step.

  6. Click “Next”: Proceed to the next step.

  7. Name and Describe the Database: Give your database a unique name and an optional description.

  8. Click “Review”: Review the database details.

  9. Click “Create”: Register the database in the Data Catalog.

​
Database Cards

The Databases section displays each registered database as a card. Each card shows:

  • Database Type Icon: An icon representing the type of database (e.g., SQL, Vector).
  • Database Name: The name you assigned to the database.
  • Description: The description you provided for the database.
  • Edit Icon (Pencil): Click this icon to update the database’s configuration, name, or description (only if the database is not in use).
  • Delete Icon (Trash Bin): Click this icon to remove the database (only if the database is not in use).

​
Database Usage Restrictions

You cannot edit or delete a database if it is currently referenced by other entities within Kosmoy Studio. This includes being used in:

  • Collections (for Vector Databases)
  • Data Channels
  • Assistants
  • Any other Kosmoy Studio component that references databases.

Before attempting to edit or delete a database, ensure it is not actively used in any of these areas.

​
Updating a Database

You can update the configuration of a registered database, including its connection parameters, name and description, provided it is not currently referenced by any other component.

  1. Navigate to Databases: Go to “Data Management” > “Data Catalog” > “Databases”.
  2. Locate the Database Card: Find the card for the database you want to update.
  3. Click the Edit (Pencil) Icon: This will open the update dialog.
  4. Modify Database parameters: Update the database’s parameters as needed.
  5. Click “Save”: Save the changes.

If you attempt to edit a database that is currently in use, a warning banner will be displayed at the top of the screen, preventing the modification.

​
Removing a Database

You can remove a registered database if it’s no longer needed. However, you cannot delete a database that is currently referenced by any other component.

  1. Navigate to Databases: Go to “Data Management” > “Data Catalog” > “Databases”.
  2. Locate the Database Card: Find the card for the database you want to remove.
  3. Click the Delete (Trash Bin) Icon: This will trigger a confirmation prompt.

If you attempt to delete a database that is currently in use, a modal will appear, preventing the deletion and explaining that the database is in use.

  1. Confirm Deletion: Confirm that you want to delete the database.

Warning: Deleting a database is a permanent action and cannot be undone. Ensure that the database is not being referenced by any other component before proceeding.

​
Using Databases

Registered databases can be used to create Data Channels. Vector databases can also be used to create Collections.