> AI agents: this is one page from Mammoth Analytics documentation. The index of all pages as Markdown is https://mammoth.io/docs/llms.txt. Append `.md` to any docs URL, or send `Accept: text/markdown`, to get Markdown.

# Edit, repair or delete a saved connection in Mammoth

> Change a Mammoth connection's key or sign-in, repair one that needs attention, delete it safely, or copy a Mammoth-managed database's credentials.
>
> Applies to: Roles: Project Admins. Where: Data › Connections › a connection

Project Admins change saved connections on the Connections page: go to **Data**, click the **Connections** tab and click a connection to open its details. From there you can edit its sign-in, repair it, delete it, or copy a managed database's credentials. For the list itself, see [Manage saved connections](https://mammoth.io/docs/learn/get-data-in/connections/).

## Actions on a connection

| Button | What it does |
| --- | --- |
| **Edit connection** | Opens the connection form to change its details, such as a new password, key or sign-in. Built-in connectors only. When you save, Mammoth shows, for example, "Connection Sales Postgres updated". |
| Delete (bin icon) | Deletes the connection. See [Delete a connection](#delete-a-connection). |
| **Show credentials** | Mammoth-managed PostgreSQL and Google BigQuery only. See [Get a Mammoth-managed database's credentials](#get-a-mammoth-managed-databases-credentials). |

## Fix a connection that needs attention

The Connectors launcher lists failing connections under **Needs attention**, with a reason: **key expired** or **unreachable**. Click one: the Connections page opens with that connection selected, and:

| Connection | What opens |
| --- | --- |
| A built-in connector | The **Edit connection** form, to enter a new key or sign in again |
| A connection the agent built (a REST API) | A new draft, whose chat asks for the key again |
| A Mammoth-managed connection | "Mammoth manages this connection's credentials, so there is nothing to repair here." |
| Any, if you are not a Project Admin | "Only a project admin can repair this connection." |

## Delete a connection

1. Open the connection and click the delete (bin) icon.
2. Read the dialog, titled with the connection's name, such as **Delete connection “Sales Postgres”?**. It lists what stops working.
3. Click **Delete connection**.

| Listed item | What happens |
| --- | --- |
| **Imports** | Each dataset "Stops refreshing. Rows already imported are kept." |
| **Exports** | Each task "Stops delivering. Rows already delivered stay in the destination." |
| **Stored credentials** | "You’d re-enter these to reconnect" |

Deleting a connection never deletes data, datasets or pipelines. Its credentials are removed, and everything that used it becomes **unconfigured** until you point it at another connection. Mammoth confirms, for example, "Connection Sales Postgres deleted. 3 usages are now unconfigured." If nothing uses it, the dialog says "Nothing is using this connection."

A deleted connection does not go to Trash, so you can't restore it: create it again instead. Mammoth-managed connections have no delete button; Mammoth removes one by itself when the last published View that uses it is deleted.

## Get a Mammoth-managed database's credentials

Mammoth creates a managed connection when you export a View to a Mammoth-managed PostgreSQL or Google BigQuery database. To connect an outside tool (for example, a BI tool) to that database:

1. Open the managed connection and click **Show credentials** (Project Admins only).
2. The **Database credentials** dialog lists the values. For PostgreSQL: the host, port, username, password and database. For Google BigQuery: the dataset, the service account's email and a link to the service account key.
3. Click **Copy all** to copy them.

## Troubleshooting connections

| Symptom | Cause | Fix |
| --- | --- | --- |
| Buttons are disabled, with a permission banner | You are not a Project Admin | Ask a Project Admin to add or change the connection, or to give you Admin access |
| "This workspace is in view-only mode, so connections can't be created or changed. Choose a plan to continue working." | The workspace has no active plan | Choose a plan (see [Billing and plans](https://mammoth.io/docs/learn/workspace/billing-and-plans/)) |
| Health shows **Error** | The key expired, the source refused it, or Mammoth couldn't reach it | Click **Edit connection** and enter a new key, or check your firewall (see [Allow Mammoth through your firewall](https://mammoth.io/docs/learn/get-data-in/network-requirements/)) |
| Datasets stopped refreshing after a delete | Deleting a connection leaves its datasets **unconfigured** | Point them at another connection |
| A link dataset shows **Last fetch failed** | "The link answered 404" or "The link could not be reached" | Check the URL still returns the file (see [Import from a URL](https://mammoth.io/docs/learn/get-data-in/import-from-a-url/#troubleshooting-url-imports)) |

For more connection problems, see [Troubleshooting](https://mammoth.io/docs/learn/help/).

## Related

- [Manage saved connections](https://mammoth.io/docs/learn/get-data-in/connections/): the list, filters, health and drafts.
- [Allow Mammoth through your firewall](https://mammoth.io/docs/learn/get-data-in/network-requirements/): fix unreachable connections.
- [Send data to a database or BI tool](https://mammoth.io/docs/learn/share-and-export/send-to-destinations/): exports that create managed connections.
- [Projects](https://mammoth.io/docs/learn/workspace/projects/): who is a Project Admin.

---
Source: https://mammoth.io/docs/learn/get-data-in/edit-a-connection.md · Updated: 2026-11-08