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

# Browse Rows

> Page rows from one verified table or view with server-built filters and sorting. The database transaction is read-only.



## OpenAPI

````yaml /openapi.json post /v1/orgs/{orgId}/projects/{projectId}/databases/{databaseId}/rows
openapi: 3.1.0
info:
  title: Korve API
  version: 0.1.0
  description: >-
    Typed control plane for deploying applications and explicitly provisioning
    their managed infrastructure.
servers:
  - url: https://api.korve.dev
security: []
paths:
  /v1/orgs/{orgId}/projects/{projectId}/databases/{databaseId}/rows:
    post:
      tags:
        - databases
      summary: Browse Rows
      description: >-
        Page rows from one verified table or view with server-built filters and
        sorting. The database transaction is read-only.
      operationId: databases.browseRows
      parameters:
        - name: orgId
          in: path
          required: true
          schema:
            type: string
          description: The organization's id (UUID) or slug — either form is accepted.
        - name: projectId
          in: path
          required: true
          schema:
            type: string
          description: The project's id (UUID) or slug — either form is accepted.
        - name: databaseId
          in: path
          required: true
          schema:
            type: string
          description: The database's id (UUID), from databases.list.
      requestBody:
        required: true
        x-korve-max-bytes: 1048576
        content:
          application/json:
            schema:
              type: object
              properties:
                schema:
                  type: string
                relation:
                  type: string
                limit:
                  type: integer
                  description: Page size from 1 to 100. Defaults to 50.
                cursor:
                  type: string
                  description: Opaque cursor from the previous page.
                sort:
                  type: object
                  properties:
                    column:
                      type: string
                    direction:
                      type: string
                      enum:
                        - asc
                        - desc
                  required:
                    - column
                    - direction
                  additionalProperties: false
                filters:
                  type: array
                  description: >-
                    At most five filters. Columns are verified and values are
                    parameterized.
                  items:
                    type: object
                    properties:
                      column:
                        type: string
                      operator:
                        type: string
                        enum:
                          - eq
                          - neq
                          - lt
                          - lte
                          - gt
                          - gte
                          - contains
                          - is_null
                      value:
                        anyOf:
                          - type: 'null'
                          - type: string
                          - type: number
                          - type: boolean
                          - type: object
                            additionalProperties: true
                          - type: array
                            items: {}
                    required:
                      - column
                      - operator
                    additionalProperties: false
              required:
                - schema
                - relation
              additionalProperties: false
      responses:
        '200':
          description: A bounded row page.
          content:
            application/json:
              schema:
                type: object
                properties:
                  columns:
                    type: array
                    items:
                      type: object
                      properties:
                        name:
                          type: string
                        dataType:
                          type: string
                      required:
                        - name
                        - dataType
                  rows:
                    type: array
                    items:
                      type: object
                      additionalProperties:
                        anyOf:
                          - type: 'null'
                          - type: string
                          - type: number
                          - type: boolean
                          - type: object
                            additionalProperties: true
                          - type: array
                            items: {}
                  nextCursor:
                    type:
                      - string
                      - 'null'
                  durationMs:
                    type: number
                  rowCount:
                    type: integer
                  bytes:
                    type: integer
                  truncated:
                    type: boolean
                    description: >-
                      True when the server row or byte ceiling stopped
                      collection.
                required:
                  - columns
                  - rows
                  - nextCursor
                  - durationMs
                  - rowCount
                  - bytes
                  - truncated
        '404':
          description: No such ready database or relation in this project.
        '422':
          description: Invalid relation, cursor, filter, or sort.
        '429':
          description: Database explorer concurrency or rate limit reached.
        '504':
          description: Read-only row browse exceeded its statement timeout.
      security:
        - apiKey: []
        - session: []
components:
  securitySchemes:
    apiKey:
      type: http
      scheme: bearer
      bearerFormat: korve_api_key
    session:
      type: apiKey
      in: cookie
      name: korve.session_token

````