# Tables

Chatlayer enables the integration of built-in databases resembling spreadsheets. These Tables can store diverse data as records, populating columns with respective values. 

<figure><img src="/files/u2kxf5lVVqk3byofLj74" alt=""><figcaption></figcaption></figure>

{% hint style="danger" %}
Please note that Tables cannot be exported at[ bot export](/navigation/settings/import-export.md) yet.
{% endhint %}

## Start with Tables

<table data-view="cards"><thead><tr><th></th><th></th><th></th><th data-hidden data-card-target data-type="content-ref"></th><th data-hidden data-card-cover data-type="files"></th></tr></thead><tbody><tr><td><strong>Create a Table with records</strong></td><td>The basics to make your first table.</td><td></td><td><a href="/pages/bsQL6ignyN6ZvitcczO7">/pages/bsQL6ignyN6ZvitcczO7</a></td><td><a href="/files/05TASSWnat2n98qr7AOt">/files/05TASSWnat2n98qr7AOt</a></td></tr><tr><td><strong>Column types</strong></td><td>The different types of data that your Table can store.</td><td></td><td><a href="/pages/5UP88IHHsXprtXiyGddv">/pages/5UP88IHHsXprtXiyGddv</a></td><td><a href="/files/7XQskKw59HlFUP0sQCkU">/files/7XQskKw59HlFUP0sQCkU</a></td></tr><tr><td><strong>Gym bot template</strong></td><td>A bot template that uses Tables to store class information.</td><td></td><td><a href="/pages/-M_QBb6GHsVH1o36qrWB#gym">/pages/-M_QBb6GHsVH1o36qrWB#gym</a></td><td><a href="/files/8y8p0mxk6hgCFA0nqhnb">/files/8y8p0mxk6hgCFA0nqhnb</a></td></tr><tr><td><strong>Operate on your records</strong></td><td>Insert, update, delete, and retrieve data.</td><td></td><td><a href="/pages/qJSJY0cEow6gb3A8h3Bf">/pages/qJSJY0cEow6gb3A8h3Bf</a></td><td><a href="/files/yY4Ufi9a6Qcjylm6Lnhw">/files/yY4Ufi9a6Qcjylm6Lnhw</a></td></tr></tbody></table>

<details>

<summary>Best practices for Tables</summary>

Here are some best practices when managing your Tables:

* Plan your[ flow logic ](/buildabot/conversation-design/getting-started.md)first.
* Keep your data structure simple.
* Validate your data formats before insertion to avoid errors.
* Use unique IDs per record for an easy data retrieval.
* Optimize data retrieval by using precise queries to avoid fetching extra data.
* Implement error handling strategies.
* Regulary check and cleanse your data.
* Prioritize security and privacy.
* Test thoroughly before deployment.
* Monitor and iterate after deployment.

</details>

## Go further

<table data-view="cards"><thead><tr><th></th><th></th><th></th><th data-hidden data-card-target data-type="content-ref"></th><th data-hidden data-card-cover data-type="files"></th></tr></thead><tbody><tr><td><strong>API</strong> </td><td>Connect your Table to your API.</td><td></td><td><a href="/pages/Ls82mDhuJLYwOqq4OW29">/pages/Ls82mDhuJLYwOqq4OW29</a></td><td><a href="/files/FK5h1OcDZG5sa2AUluRX">/files/FK5h1OcDZG5sa2AUluRX</a></td></tr><tr><td></td><td><strong>Use Tables to store your KBAI questions</strong></td><td>Keep and eye on how your KBAI is performing.</td><td><a href="/pages/xvSJSNsmkrt3pVRg4dXA">/pages/xvSJSNsmkrt3pVRg4dXA</a></td><td><a href="/files/KgnrxU8ngaL5wHeDsb1g">/files/KgnrxU8ngaL5wHeDsb1g</a></td></tr><tr><td></td><td></td><td></td><td></td><td></td></tr></tbody></table>


---

# 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.chatlayer.ai/navigation/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.