How to refresh, edit or remove a data source

In TeleportHQ, every data source is managed from its card in the Data Sources panel. Click the card to rename it or change its connection details, or click the refresh button to pick up tables you added in your database. To delete it, click the card's trash button; every element bound to it is unbound.

Before you start#

• Removing a data source or a table can turn off features that use it, such as Authentication, E-Commerce, the Admin Panel, the AI Assistant Chat, the Blog or the Help Center. Read the confirmation window carefully.
• Removing a table deletes the table and its rows from the database itself. Back up the data first.
• A headless CMS is managed differently. See Connect a headless CMS.

Open a data source in TeleportHQ#

1. In the left sidebar, click Data Sources (the database icon).
2. Click the data source's card, for example Gym members. Its settings open beside the panel, titled Update and the type, for example Update PostgreSQL.

Refresh a data source's tables in TeleportHQ#

Use refresh when you added tables or columns directly in your own database and TeleportHQ doesn't show them yet. It works for the TeleportHQ database, Supabase, Airtable and every database type.

1. Open the data source (see above).
2. In the Database Tables (or Confirmed Data Sources) header, click the refresh button. Its tooltip starts with "Refresh all the tables/collections available in the data source."

A message confirms "Data source schema refreshed successfully". New tables now appear in the list.

Change a data source's connection details#

To change a password, host or other setting of a TeleportHQ data source:

1. Open the data source.
2. Expand the Setup … Connection section, for example Setup PostgreSQL Connection.
3. Change the field, for example type the new Password.
4. Click Fetch Database Schema again. For Redis and Airtable, the buttons are Fetch Redis Schema and Fetch Airtable Schema.

For a REST API, Google Sheet or CSV file, change the field, load the data again (Fetch data from API, Get data from Google Sheet or Extract data from CSV), then click Save Data Source. For a JavaScript list, edit the code and click Save Data Source.

If the field is linked to a Secret, change the Secret instead in Project settings → Data & code → Secrets. See Keep passwords and API keys safe.

Rename a data source#

1. Open the data source.
2. Click into Data Source Name and type the new name, for example Members.
3. Click anywhere outside the field. The name saves.

If another data source already has that name, TeleportHQ adds a number to the end.

Remove one table from a data source#

You can remove a table from the TeleportHQ database, Supabase, PostgreSQL, MySQL, MariaDB, Amazon Redshift, CockroachDB and TiDB.

1. Open the data source.
2. In Database Tables, find the table and click the ⋯ button at the right of its row, next to View Data.
3. Click Delete.

4. A window titled Delete Table asks "Are you sure you want to delete this table?". Click Delete Table.

A message confirms Table "<name>" deleted successfully. If the database refuses, the message starts with "Failed to delete table:" and gives the reason.

If a feature or workflow uses the table, a Table In Use window lists what will be turned off or reset. Type delete table in the box to confirm.

Delete a data source#

1. In the Data Sources panel, find the data source's card.
2. Click its trash button (tooltip Delete data source).
3. The Delete Data Source window says: "You are about to permanently delete this data source from your project. All nodes currently bound to this data source will be unbounded."
4. Click Delete Data Source.

For a TeleportHQ database, the window is titled Delete the "…" database instead, with your database's name, and says: "This is a TeleportHQ database: every table and every row in it is deleted together with the data source, and the data cannot be recovered. All elements bound to it will be unbound." Its button reads Delete database and data.

If features or workflows use the data source, the Data Source In Use window appears instead. It lists them under Important:, for example "Blog will be disabled", and for a TeleportHQ database it adds that every table and every row in it "will be deleted and cannot be recovered". Type Delete data source in the box and click Delete Data Source. Those features are turned off, and workflow steps that used its tables are reset.

Check that it worked#

• After a refresh, new tables show in the data source's table list.
• After editing, the card still appears and its tables load when you click View Data.
• After deleting, the card disappears from the Data Sources panel, and elements that used it are no longer bound to data.

Troubleshooting#

"Failed to fetch database schema. Make sure that the configuration is correct." The connection details are no longer valid, for example the password changed. Update them and click Fetch Database Schema.

"Failed to update data source schema" TeleportHQ read the tables but couldn't save the update. Try again. If it keeps failing, contact support.

The CMS connection card has no trash button Remove a headless CMS with ⋮ → Disconnect CMS. See Connect a headless CMS.

A table has no Delete in its menu MongoDB, Redis, Firestore, ClickHouse, Airtable and Turso tables can't be removed from TeleportHQ. Remove them in the database's own tools, then refresh the data source.

Good to know#

• Deleting your own database's connection keeps the database. For PostgreSQL, MySQL, MongoDB, Supabase, Airtable and the other external services, deleting the data source only removes the connection from the project.
• Deleting the TeleportHQ database deletes its data. When you delete a TeleportHQ database data source, TeleportHQ also deletes the hosted database with all its tables and records, as its delete window warns. Export the records you need first. See Set up the built-in TeleportHQ database.
• Deleting can't be undone. To get the project's settings back, restore a project backup. See Back up and restore your project.