Connecting data

Connect databases, spreadsheets, APIs and headless CMSs.

Articles

What are data sources, and which ones can I connect?

What are data sources, and which ones can I connect?

A data source is a connection that brings content from a database, spreadsheet, API or headless CMS into your TeleportHQ project, so your pages show real data instead of typed text; you manage them in the editor's Data Sources panel, and connecting one keeps a website a website.

How to connect a database (PostgreSQL, MySQL, MongoDB, Firestore and more)

How to connect a database (PostgreSQL, MySQL, MongoDB, Firestore and more)

In TeleportHQ, you connect your own database from Data Sources → Add Data Source, by entering its connection details and clicking Fetch Database Schema, which adds all its tables to your project.

How to connect Supabase

How to connect Supabase

To connect Supabase to TeleportHQ, copy the Session or Transaction pooler connection string from your Supabase dashboard, paste it in Data Sources → Add Data Source → Supabase, and click Fetch Database Schema.

How to connect Airtable

How to connect Airtable

To connect Airtable to TeleportHQ, create an Airtable personal access token with the data.records:read and schema.bases:read scopes, then enter it with your Base ID in Data Sources → Add Data Source → Airtable.

How to use a Google Sheet as data

How to use a Google Sheet as data

To use a Google Sheet in TeleportHQ, share the sheet so anyone with the link can view it, paste its URL in Data Sources → Add Data Source → Google Sheets, load the preview and click Save Data Source.

How to use a CSV file or static JSON data

How to use a CSV file or static JSON data

In TeleportHQ you can use a fixed list as data without any external service, either by uploading a CSV file (Add Data Source → CSV File) or by typing a JSON-style list in the JavaScript data source.

How to connect a REST API

How to connect a REST API

In TeleportHQ, you connect a REST API from Data Sources → Add Data Source → REST API by entering the API URL, choosing the method, adding any headers or authorization, clicking Fetch data from API and then Save Data Source; you can also cache the API's answers, or ask the AI Assistant to connect a public API.

How to connect a headless CMS (Strapi, Contentful, WordPress and more)

How to connect a headless CMS (Strapi, Contentful, WordPress and more)

In TeleportHQ, you connect Strapi, Contentful, WordPress, caisy.io or Flotiq from Data Sources → Add Data Source → CMS Connection, enter the CMS credentials, and choose which content types get automatic list and details pages.

How to keep passwords and API keys safe (Secrets)

How to keep passwords and API keys safe (Secrets)

TeleportHQ stores passwords, tokens and API keys as project Secrets, which the project owner manages in Project settings → Data & code → Secrets and links to credential fields with the plug button, instead of typing the value into each data source.

How to refresh, edit or remove a data source

How to refresh, edit or remove a data source

In TeleportHQ, click a data source card in the Data Sources panel to rename it, change its connection details or refresh its tables, and use the card's trash button to delete it, which unbinds every element that uses it.