> Portal Navigation:
> 
> - Append `.md` to any URL under `https://dev.wix.com/docs/` to get its markdown version.
> - Pages are either content pages (article or reference text) or menu pages (a list of links to child pages).
> - To get a menu page, truncate any URL to a parent path and append `.md` (e.g. `https://dev.wix.com/docs/sdk.md`, `https://dev.wix.com/docs/sdk/core-modules.md`).
> - Top-level index of all portals: https://dev.wix.com/docs/llms.txt
> - Full concatenated docs: https://dev.wix.com/docs/llms-full.txt

## Resource: Add and Delete External Database Collections

## Article: Add and Delete External Database Collections

## Article Link: https://dev.wix.com/docs/develop-websites-sdk/code-your-site/work-with-data/external-databases/overview/add-and-delete-external-database-collections.md

## Article Content:

# Add and Delete External Database Collections

> **Note:** This feature is only available for sites with certain premium plans. If you need to use this feature, you can [upgrade your site](https://www.wix.com/upgrade/website). Learn more about [premium plans](https://dev.wix.com/docs/develop-websites-sdk/maintain-your-site/scale-your-site/about-premium-plans.md).

Wix lets you [connect your site to an external database](https://dev.wix.com/docs/develop-websites-sdk/code-your-site/work-with-data/external-databases/overview/about-integrating-external-databases-with-your-wix-site.md) and then work with that database's collections in your site just as you would with our built-in collections.

This article explains how to add and delete external database collections for your site.

## Before you begin

Before adding an external database to your Wix site you need to set up or create an [external database adaptor](https://dev.wix.com/docs/develop-websites-sdk/code-your-site/work-with-data/external-databases/overview/about-integrating-external-databases-with-your-wix-site.md#external-database-adaptors).

> **Note:** You can also add external database collections to your site by calling [`createExternalDatabaseCollection()`](https://dev.wix.com/docs/api-reference/business-solutions/cms/external-databases/external-database-connection/create-external-database-connection.md). For detailed instructions, see the [sample flows](https://dev.wix.com/docs/api-reference/business-solutions/cms/external-databases/external-database-connection/sample-flows.md) of the External Database Connections API.

## Add external database collections

1. Select **Databases** from the Code sidebar (Wix Editor) or the Code sidebar (Wix Studio). 

2. Click the  ![](https://d2x3xhvgiqkx42.cloudfront.net/12345678-1234-1234-1234-1234567890ab/99f9f305-0415-4713-856e-b7aa93cbd4d3/2021/09/29/c0043bd2-1c97-4c1b-80b0-704e57d1e60f/e996cdd7-afcb-481f-be55-4414dd4895b1.png) icon next to **External Databases** and select **Add external database**.

    ![Add external database option in Wix Studio](https://wixmp-833713b177cebf373f611808.wixmp.com/images/7529ef4e207ccfa2e9b533d6a4bf14c6.png)

3. Choose the provider of the external database you wish to add and click **Next**.

    <div>
    
    <img src="https://d2x3xhvgiqkx42.cloudfront.net/12345678-1234-1234-1234-1234567890ab/a551efd3-24d0-48fe-8aec-00f810ffc5fc/2023/05/29/0405bd60-e0b1-40a3-983b-17ef1ccb93df/2d0c1971-8109-4a09-8a47-1a1692a3a532.png" style="max-width:40vw" />
    
    </div>

4. In the Connect External Database screen:

    1.  Choose a namepace to group the external database's collections under.
    2.  Enter your endpoint URL for the external database adaptor.
    3.  Enter the database adaptor's secret key.

        <div>
        
        <img src="https://d2x3xhvgiqkx42.cloudfront.net/12345678-1234-1234-1234-1234567890ab/a551efd3-24d0-48fe-8aec-00f810ffc5fc/2023/05/29/78151580-59d2-4668-a010-61def1c9a4d3/773ba8b8-d146-4847-b799-9efd29e5deff.png" style="max-width:40vw" />
        
        </div>

Your external database collections are now listed under the namespace you chose, and you can work with them as you would your other collections.

## Delete an external database collection

Delete an external database collection from your site in the same way that you would delete a built-in data collection, using the Show More icon ![](https://d2x3xhvgiqkx42.cloudfront.net/12345678-1234-1234-1234-1234567890ab/76096845-8b12-44f1-91f6-3dc2e838fdd9/2022/09/04/45269098-373f-4d2c-8168-2fc5242c6024/c890c6a3-6762-4501-bdb4-e44c678108df.png).

> **Note:** This only deletes the collection from your site. It does not delete it from the external database.