> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kosmoy.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Databases

> Learn how to register and manage your databases within Kosmoy Studio's Data Catalog.

# 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](/data-management/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.**

4. **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**.