> ## Documentation Index
> Fetch the complete documentation index at: https://docs.noxus.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Introduction

> Structured data your flows and agents can read, write and query

**Tables** store structured records in your workspace: typed columns and rows you manage like a spreadsheet, and query with SQL. Use them to keep reference data, collect flow output, or give an agent a source of truth to look things up in.

Choose a table when you need exact, structured records (a customer list, an order log, a price sheet). Choose a [Knowledge Base](/platform/knowledge-bases/introduction) when you need to search the contents of documents.

<Frame>
  <video controls loop preload="metadata" width="3840" height="2160" style={{ width: "100%", height: "auto" }}>
    <source src="https://storage.googleapis.com/noxus-docs-videos/tables/tables-introduction-v10.mp4" type="video/mp4" />
  </video>
</Frame>

## Overview

* [Creating Tables](/platform/tables/creating-tables): Create a table or import one from a CSV or Excel file.
* [Using Tables](/platform/tables/using/table-view): Work with tables in the app, with SQL, and from flows, agents, Genie and the API.
* [Platform Tables](/platform/tables/platform-tables): Query your workspace's own data, such as flows, runs and agents.
* [Best Practices](/platform/tables/best-practices): Design, import, query and secure tables well.

## Key concepts

* **Table**: a named set of rows with a fixed set of columns.
* **Column**: a typed field. Each column has a name (a free-text label) and an identifier (the name used in SQL).
* **Row**: one record. Every row has an `id` primary key, either a UUID or an auto-incrementing number.
* **Identifier**: the table's SQL name, generated from its name when you create it. It never changes, even if you rename the table.
* **Custom**: tables you create and edit yourself.
* **Platform**: read-only views of your workspace's own data, such as users, flows, runs and agents. See [Platform Tables](/platform/tables/platform-tables).

## Properties

* **Workspace-scoped**: tables belong to a workspace and are shared with everyone in it. Any flow, agent or member with the right role can use any of its tables.
* **Queryable with SQL**: every table, including platform tables, can be queried and joined with SQL. Queries are read-only by default; writes are available in flows, agents and Genie. See [SQL Queries](/platform/tables/using/sql).
* **Import-ready**: bring in data from outside the platform by importing a CSV or Excel file, or by writing rows from flows, agents and the API. See [Importing a table](/platform/tables/creating-tables#importing-a-table).
* **Categorizable**: custom tables can be grouped with workspace [tags](/platform/tags/overview).
* **Portable**: tables travel with a flow when you export it with dependencies, and are recreated when it's imported. See [Exporting and importing flows](/platform/tables/using/flows#exporting-and-importing-flows).

## Permissions

Access follows your [workspace role](/platform/concepts/permissions):

| Role permission | Allows |
| :- | :- |
| **View resources** | View tables and rows, and export them |
| **Create & edit resources** | Create tables, change columns and rows, import files and run SQL |
| **Delete resources** | Delete tables |

## Where you can use tables

<CardGroup cols={2}>
  <Card title="In the app" icon="table" href="/platform/tables/using/table-view">
    Create tables, edit rows in a spreadsheet-style grid, search, and import or export files.
  </Card>

  <Card title="In flows" icon="workflow" href="/platform/tables/using/flows">
    Get, insert, update, delete and export rows, or run SQL with the Query Table node.
  </Card>

  <Card title="From agents" icon="bot" href="/platform/tables/using/agents">
    Attach tables to an agent so it can answer questions from them, and optionally edit them.
  </Card>

  <Card title="Genie" icon="sparkles" href="/platform/tables/using/genie">
    Ask Genie to build a table, add columns, or change rows for you.
  </Card>

  <Card title="SDK" icon="terminal" href="/sdk/resources/tables">
    Create tables, manage columns and rows, and run SQL from Python.
  </Card>

  <Card title="REST API" icon="code" href="/api-reference/v1--tables/list-tables">
    The full REST reference for the tables endpoints.
  </Card>
</CardGroup>


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.