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

# Get Schema

> Return the database schema (tables, columns, types) for the app's database.



## OpenAPI

````yaml https://api.getfloo.com/openapi.json get /v1/apps/{app_id}/db/schema
openapi: 3.1.0
info:
  title: floo API
  version: 0.1.0
servers:
  - url: https://api.getfloo.com
security: []
paths:
  /v1/apps/{app_id}/db/schema:
    get:
      tags:
        - db
      summary: Get Schema
      description: >-
        Return the database schema (tables, columns, types) for the app's
        database.
      operationId: db_get_schema
      parameters:
        - name: app_id
          in: path
          required: true
          schema:
            type: string
            format: uuid
            title: App Id
        - name: env
          in: query
          required: false
          schema:
            type: string
            title: Env
            default: dev
        - $ref: '#/components/parameters/X-Floo-Org-Id'
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DbSchemaResponse'
        default:
          description: Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorResponse'
      security:
        - bearerAuth: []
components:
  parameters:
    X-Floo-Org-Id:
      name: X-Floo-Org-Id
      in: header
      required: false
      schema:
        type: string
        format: uuid
      description: Organization to act in; defaults to the one joined most recently.
  schemas:
    DbSchemaResponse:
      properties:
        schema_name:
          type: string
          title: Schema Name
        tables:
          items:
            $ref: '#/components/schemas/TableInfo'
          type: array
          title: Tables
        schema_size_bytes:
          anyOf:
            - type: integer
            - type: 'null'
          title: Schema Size Bytes
        schema_size_human:
          anyOf:
            - type: string
            - type: 'null'
          title: Schema Size Human
      type: object
      required:
        - schema_name
        - tables
      title: DbSchemaResponse
      description: >-
        Expose the app-owned Postgres schema, tables, and optional size
        measurements.
    ErrorResponse:
      properties:
        detail:
          $ref: '#/components/schemas/ErrorDetail'
      type: object
      required:
        - detail
      title: ErrorResponse
      description: Body of every error response except request validation (422).
    TableInfo:
      properties:
        name:
          type: string
          title: Name
        columns:
          items:
            $ref: '#/components/schemas/ColumnInfo'
          type: array
          title: Columns
        row_count:
          anyOf:
            - type: integer
            - type: 'null'
          title: Row Count
      type: object
      required:
        - name
        - columns
      title: TableInfo
      description: Describe table columns with an optional observed row count.
    ErrorDetail:
      properties:
        code:
          type: string
          title: Code
        message:
          type: string
          title: Message
      additionalProperties: true
      type: object
      required:
        - code
        - message
      title: ErrorDetail
      description: Standard error envelope with operation-specific JSON context.
    ColumnInfo:
      properties:
        name:
          type: string
          title: Name
        type:
          type: string
          title: Type
        nullable:
          type: boolean
          title: Nullable
      type: object
      required:
        - name
        - type
        - nullable
      title: ColumnInfo
      description: Describe a database column's name, type, and nullability.
  securitySchemes:
    bearerAuth:
      type: http
      scheme: bearer
      description: A `floo_` API key.

````

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