# Actions on Data Sources

> Part of the NocoDB documentation (Product docs > Integrations > Data Sources). Index of all pages: https://nocodb.com/llms.txt. Any docs page is available as Markdown by adding `.md` to its URL.

URL: https://nocodb.com/docs/product/integrations/data-sources/actions-on-data-sources
Last updated: 2026-10-03

Do actions on data sources in NocoDB: edit, remove, hide, set view visibility and see relations.

## Edit Data Source parameters

* Open [External Database](/docs/product/integrations/data-sources#accessing-data-sources) in **Base Settings** → **Manage**.
* Click the data source that you want to edit.
* Change the data source parameters as necessary. You can edit these parameters:
  1. Data source name
  2. Database & Schema
  3. Data source access permissions
* To save the changes, click the `Submit` button.

<Callout type="info">
  To change database connection parameters (such as host and port), use the 

  [Edit connection](/docs/product/integrations/actions-on-connection#edit)

   option. Only users with Workspace Creator+ permissions can use the Edit connection option.
</Callout>

<img alt="Source Connection Details for an external data source" src={__img0} placeholder="blur" />

## Remove data source

Open [External Database](/docs/product/integrations/data-sources#accessing-data-sources) in **Base Settings** → **Manage**. Then do these steps:

1. Click the Actions button (three dots) next to the data source that you want to remove.
2. In the dropdown, select the `Remove` option.

<img alt="The row menu, with Edit and Remove" src={__img1} placeholder="blur" />

<img alt="The Remove Data Source confirmation" src={__img2} placeholder="blur" />

<Callout type="info">
  When you remove a data source, NocoDB does not delete the external data source. It only removes the data source from the current base.
</Callout>

You cannot remove the default source of a base. A base must always have at least one source.

## Data source visibility

* Open [External Database](/docs/product/integrations/data-sources#accessing-data-sources) in **Base Settings** → **Manage**.
* To hide or show a data source, use its toggle in the **Visibility** column.

<img alt="The Visibility toggle beside each data source" src={__img3} placeholder="blur" />

## View visibility

Open [External Database](/docs/product/integrations/data-sources#accessing-data-sources) in **Base Settings** → **Manage**. Select the data source for which you want to set view visibility. Then do these steps:

1. Select the `View visibility` tab. The rows show the views and tables in the data source. The columns show the roles.
2. To enable or disable access to tables for a role, select or clear the checkboxes.
3. To save the changes, click the `Save` button.

<img alt="The View visibility tab, with a checkbox per role" src={__img4} placeholder="blur" />

## Relations

* Open [External Database](/docs/product/integrations/data-sources#accessing-data-sources) in **Base Settings** → **Manage**.
* Select the data source for which you want to see the ERD (Relations view).
* Click the `ERD View` tab.

<img alt="The ERD View tab showing the source's tables and relations" src={__img5} placeholder="blur" />

---

## Related pages

- [Connect to a Data Source](https://nocodb.com/docs/product/integrations/data-sources/connect-to-data-source.md): Connect an external PostgreSQL or MySQL database to NocoDB as a data source.
- [Sync with Data Source](https://nocodb.com/docs/product/integrations/data-sources/sync-with-data-source.md): Sync changes made in an external data source with NocoDB through Meta Sync.
- [Updating Secrets](https://nocodb.com/docs/product/integrations/data-sources/updating-secret.md): Update secrets in NocoDB with the nc-secret-mgr package, from the CLI or an executable.