> For the complete documentation index, see [llms.txt](https://docs.chatlayer.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.chatlayer.ai/navigation/tables.md).

# Tables

Chatlayer's new Tables feature offers you a convenient way to manage your data in the form of 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="https://2786867680-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LLTwFwbOqJj4dDhg8Ju%2Fuploads%2Flh2aRyIEsxJfx1DgmKVp%2FFrame%201.png?alt=media&amp;token=9538fcff-1d71-4a83-b97f-05daa85e0c1f" 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="/navigation/tables/create-a-table-with-records.md">Create a table with records</a></td><td><a href="https://2786867680-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LLTwFwbOqJj4dDhg8Ju%2Fuploads%2FytLMZZN8gLWIRfm1TaB9%2FScreenshot%202024-10-02%20at%2010.39.34.png?alt=media&amp;token=05d12b03-bf02-46b8-9205-b42792c0d6b9">Screenshot 2024-10-02 at 10.39.34.png</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="/navigation/tables/column-types.md">Column types</a></td><td><a href="https://2786867680-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LLTwFwbOqJj4dDhg8Ju%2Fuploads%2FYoCkZzwJ9wsZttnta6ux%2FScreenshot%202024-10-02%20at%2010.40.08.png?alt=media&amp;token=d1dd2dfc-d15e-4fdd-ba21-f0aeb9f2e56e">Screenshot 2024-10-02 at 10.40.08.png</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="/start-quickly/bot-templates.md#gym">Templates</a></td><td><a href="https://2786867680-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LLTwFwbOqJj4dDhg8Ju%2Fuploads%2Fqslbk83DOZE9ZH4op9TY%2FScreenshot%202024-10-02%20at%2010.52.20.png?alt=media&amp;token=012a3827-ab8e-4b49-9832-42ea203c3f43">Screenshot 2024-10-02 at 10.52.20.png</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="/navigation/tables/operate-on-your-records.md">Operate on your records</a></td><td><a href="https://2786867680-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LLTwFwbOqJj4dDhg8Ju%2Fuploads%2FGPywZrxgwSp3MrbGQrl7%2FScreenshot%202024-10-02%20at%2010.41.00.png?alt=media&amp;token=e3c3b9cf-ca82-438d-8e52-5191a0be8868">Screenshot 2024-10-02 at 10.41.00.png</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="/navigation/tables/api.md">API</a></td><td><a href="https://2786867680-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LLTwFwbOqJj4dDhg8Ju%2Fuploads%2FMmStkwM1R1bMrECzJHfu%2FScreenshot%202024-10-02%20at%2010.41.54.png?alt=media&amp;token=3c8ef69d-2d6f-4722-bc53-da4ec46213b3">Screenshot 2024-10-02 at 10.41.54.png</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="/navigation/knowledge-base-ai/use-tables-to-store-your-kbai-questions.md">Use Tables to store your KBAI questions</a></td><td><a href="https://2786867680-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LLTwFwbOqJj4dDhg8Ju%2Fuploads%2FYYuYneLSgrKzXSp6viq9%2FScreenshot%202024-10-01%20at%2016.33.43.png?alt=media&amp;token=009359a7-50f3-4d8c-9b38-741e2e8ec70c">Screenshot 2024-10-01 at 16.33.43.png</a></td></tr><tr><td></td><td></td><td></td><td></td><td></td></tr></tbody></table>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

```
GET https://docs.chatlayer.ai/navigation/tables.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.
