# Jet Tables

With **Jet Tables**, you can build apps more efficiently using a PostgreSQL database hosted by Jet, which doesn't require any setup time.

Using Jet Database, you can:

* Interact with the data through a spreadsheet-style interface to easily edit, search, filter, and sort records
* Sync your 30+ data sources (Airtable, GoogleSheets, Firebase, ...) to Jet Tables
* Utilize a PostgreSQL database that is securely hosted
* Import or Export data in the different formats: CSV, XLS, XLSX, JSON
* Making SQL queries
* Multiple environments, including staging and production, can be used to manage the database

<figure><img src="https://3448227606-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LQ08RFAKZvFADEiXKFy%2Fuploads%2FAru0jqLY6ZhRvElKl85B%2Ftable%20view%202.png?alt=media&#x26;token=e10843ef-22f0-444e-92fe-66826e811c90" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
You can also use data from Jet Tables to [merge it](https://docs.jetadmin.io/user-guide/360-data-data-blending) with data from other data sources, write custom SQL on top of it, and access it through [the API](https://docs.jetadmin.io/user-guide/jet-admin-api#resources-api).
{% endhint %}

{% embed url="<https://www.youtube.com/watch?v=2rdWPCUiGd4&list=PLSkzi9eq0vBnUGMnwXrRRVo9TXUjZ7uSj&index=18&ab_channel=JetAdmin>" %}

### Creating a new resource

**To get started** with Jet tables, click "New Data" in the integrations list in the top left corner:

{% @arcade/embed flowId="FhhQdtmDCeG44iq8HxRl" url="<https://app.arcade.software/share/FhhQdtmDCeG44iq8HxRl>" %}

Then, you'll get to the page where you can set the initial configuration of your data source:

You can access the set-up menu by clicking the three dots next to the data source name **(1)**, where you can **change the name** or **delete** it.

You also get to choose how to **bring in your data**: you can either create a table by uploading the existing data in CSV, XLS, XLSX, or JSON **(2)** or create a new blank table to add fields and values manually **(3)**.

To create a new table, follow the steps:

1. Click on the `Add Icon`
2. Rename the Table
3. Click on the `Create` button
4. Click to **Import icon** to import the Data&#x20;

{% @arcade/embed flowId="ul6BhOueqoEHJjBbAXMf" url="<https://app.arcade.software/share/ul6BhOueqoEHJjBbAXMf>" %}

### Setting up the data

Then you'll be taken to the main data section. There are three main areas or parts:

* **(1)** In the left part, you can **manage collections** (tables) and the resource (Jet Tables) itself
* **(2)** In the top part, you scope in onto the individual table that's been selected on the left. You can switch between the tabs to **change the structure**, and the **field types,** and access the **API**
* **(3)** Here you can **manage the table's data**: add new records, change fields, and add new ones

<figure><img src="https://3448227606-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LQ08RFAKZvFADEiXKFy%2Fuploads%2FFLXX1vP6VIKPp78GmTVB%2Ftable%20view.png?alt=media&#x26;token=b4f5c966-b101-42ce-8c58-1eb2dcf39d32" alt=""><figcaption></figcaption></figure>

Now, we'll look at how to manage the data inside of a particular table.

{% hint style="info" %}
To learn about the **common** data section **functionality**, go to the [**data**](https://docs.jetadmin.io/user-guide/integrations/broken-reference) page
{% endhint %}

Now, to go from the dummy data to your own, there are two major paths:

* Import the data
* Edit the table directly

To **edit the data in the table** directly, you can edit the existing fields **(1)** and add new fields **(2)**

<figure><img src="https://3448227606-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LQ08RFAKZvFADEiXKFy%2Fuploads%2FClaNuX9LeHEWbTIECHo8%2Fedit%20or%20add%20field.png?alt=media&#x26;token=01be5b63-311c-4e88-8742-9850ad98fac2" alt=""><figcaption></figcaption></figure>

{% hint style="warning" %}
**Id** field (also referred to as "primary key"), can not be changed or deleted as it's used as a unique identifier of a record
{% endhint %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.jetadmin.io/user-guide/integrations/jet-tables.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.