​
Working with Connections

The Connections subsection within Data Management allows you to securely store and manage credentials for accessing various databases. These connections serve as a foundation for registering data sources in the Data Catalog and building data-driven applications.

​
Supported Database Types

Kosmoy Studio currently supports the following database types:
  • SQL Databases:
    • PostgreSQL
  • Vector Databases:
    • PGVector
    • Weaviate
    • Pinecone

​
Creating a Connection

  1. Navigate to Connections:
    • Click on the “Data Management” menu in the left-hand navigation bar.
    • Select “Connections” from the expanded menu.
  2. Add a New Connection: Click the ”+ ADD” button located in the upper right corner of the Connections section.
  3. Select Database Type: Choose the type of database you want to connect to (SQL or Vector).
  4. Select Provider: Choose the specific database provider from the dropdown menu (e.g., PostgreSQL for SQL, PGVector for Vector).
  5. Configure Connection Parameters: Enter the required connection details for the selected database type and provider. These parameters will vary depending on the provider but typically include:
    • Host: The hostname or IP address of your database server.
    • Port: The port number used to connect to the database.
    • Database Name: The name of the database you want to connect to.
    • Username: Your database username.
    • Password: Your database password.
    • (Other provider-specific parameters)
  6. Click “Next”: Proceed to the next step.
  7. Name and Describe the Connection: Give your connection a unique name and an optional description.
  8. Click “Review”: Review the connection details.
  9. Click “Create”: Create the connection.

​
Connection Cards

The Connections section displays each created connection as a card. Each card shows:
  • Database Type Icon: An icon representing the type of database (e.g., SQL, Vector).
  • Connection Name: The name you assigned to the connection.
  • Description: The description you provided for the connection.
  • Edit Icon (Pencil): Click this icon to update the connection’s parameters, name, or description (only if the connection is not in use).
  • Delete Icon (Trash Bin): Click this icon to remove the connection (only if the connection is not in use).

​
Connection Usage Restrictions

You cannot edit or delete a connection if it is currently referenced by other entities within Kosmoy Studio. This includes being used in:
  • Data Catalog (Databases)
  • Any other Kosmoy Studio component that references connections.
Before attempting to edit or delete a connection, ensure it is not actively used in any of these areas. You may need to modify or remove the connection from those components first.

​
Updating a Connection

You can update the parameters, name, and description of a registered connection, provided it is not currently referenced by any other component.
  1. Navigate to Connections:
    • Click on the “Data Management” icon in the left-hand navigation bar.
    • Select “Connections” from the expanded menu.
  2. Locate the Connection Card: Find the card for the connection you want to update.
  3. Click the Edit (Pencil) Icon: This will open the update dialog.
  4. Modify Connection Parameters: Update the connection’s parameters (host, port, database name, username, password, etc.) as needed. You can also modify the name and description.
  5. Click “Save”: Save the changes.
If you attempt to edit a connection that is currently in use, a warning banner will be displayed at the top of the screen, preventing the modification.

​
Removing a Connection

You can remove a registered connection if it’s no longer needed. However, you cannot delete a connection that is currently referenced by any other component.
  1. Navigate to Connections:
    • Click on the “Data Management” icon in the left-hand navigation bar.
    • Select “Connections” from the expanded menu.
  2. Locate the Connection Card: Find the card for the connection you want to remove.
  3. Click the Delete (Trash Bin) Icon: This will trigger a confirmation prompt.
If you attempt to delete a connection that is currently in use, a modal will appear, preventing the deletion and explaining that the connection is in use.
  1. Confirm Deletion: Confirm that you want to delete the connection.
Warning: Deleting a connection is a permanent action and cannot be undone. Ensure that the connection is not being referenced by any other component before proceeding.