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

# List tables

> List readable tables and their column metadata

Returns permission-scoped tables with their real Less asset IDs, row counts,
statuses, sources, and column names/types. Use a table's `id` as the Input
tool's `tableId` when generating a canvas model.

The endpoint deliberately excludes row values, profiled min/max samples,
credentials, and connection details. Use `limit` and `offset` to retrieve the
full catalog, and `query` to filter by table name.


## OpenAPI

````yaml api-reference/openapi.json GET /api/public/v1/tables
openapi: 3.0.0
info:
  title: Less Public API
  version: 1.0.0
  description: >-
    Integrator-facing JSON API. All paths are under `/api/public/v1` and match
    the route handlers in the Less webapp (`apps/webapp/src/app/api/public/v1`).
    Authenticate with `Authorization: Bearer <api-token>`.
servers:
  - url: https://{BaseURL}
    variables:
      BaseURL:
        default: app.less.tech
        description: >-
          Your workspace host (hostname only, no scheme or path). Defaults to
          app.less.tech; replace with your workspace host if different.
security:
  - bearerAuth: []
paths:
  /api/public/v1/tables:
    get:
      tags:
        - Tables
      summary: List tables with column metadata
      description: >-
        Returns every table the authenticated user can read, including its real
        Less asset id and column metadata. Values, min/max samples, credentials,
        and connection details are not returned.
      parameters:
        - name: limit
          in: query
          required: false
          schema:
            type: integer
            minimum: 1
            maximum: 100
            default: 50
        - name: offset
          in: query
          required: false
          schema:
            type: integer
            minimum: 0
            default: 0
        - name: query
          in: query
          required: false
          schema:
            type: string
            maxLength: 200
          description: Case-insensitive table-name filter.
      responses:
        '200':
          description: Readable tables and their columns.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/PublicListTablesSuccess'
        '400':
          description: Invalid pagination or query parameters.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/PublicApiErrorBody'
        '401':
          description: Missing or invalid bearer token.
        '500':
          description: Unexpected error.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/PublicApiErrorBody'
components:
  schemas:
    PublicListTablesSuccess:
      type: object
      properties:
        data:
          type: array
          items:
            $ref: '#/components/schemas/PublicTable'
        meta:
          $ref: '#/components/schemas/PublicListAssetsMeta'
      required:
        - data
        - meta
    PublicApiErrorBody:
      type: object
      properties:
        error:
          type: object
          properties:
            code:
              type: string
            message:
              type: string
          required:
            - code
            - message
      required:
        - error
    PublicTable:
      type: object
      properties:
        id:
          type: string
          format: uuid
          description: Real Less table asset id. Use this as an Input tool tableId.
        name:
          type: string
        description:
          type: string
          nullable: true
        rowCount:
          type: integer
        columnCount:
          type: integer
        status:
          type: string
        updatedAt:
          type: string
          format: date-time
        source:
          $ref: '#/components/schemas/PublicTableSource'
          description: Asset that produced this table, when it is still accessible.
          nullable: true
        columns:
          type: array
          items:
            $ref: '#/components/schemas/PublicTableColumn'
      required:
        - id
        - name
        - description
        - rowCount
        - columnCount
        - status
        - updatedAt
        - source
        - columns
    PublicListAssetsMeta:
      type: object
      properties:
        limit:
          type: integer
          minimum: 1
          maximum: 100
          description: Page size for this response.
        offset:
          type: integer
          minimum: 0
          description: Number of assets skipped from the start of the sorted list.
        hasMore:
          type: boolean
          description: True when the full page was returned; there may be more assets.
      required:
        - limit
        - offset
        - hasMore
    PublicTableSource:
      type: object
      properties:
        id:
          type: string
          format: uuid
        name:
          type: string
        type:
          type: string
          nullable: true
      required:
        - id
        - name
        - type
    PublicTableColumn:
      type: object
      properties:
        name:
          type: string
        dataType:
          type: string
          description: Stored column type reported by the Less table metadata.
        nullCount:
          type: integer
          nullable: true
          description: Number of null rows when profiling data is available.
      required:
        - name
        - dataType
        - nullCount
  securitySchemes:
    bearerAuth:
      type: http
      scheme: bearer

````

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