openapi: 3.1.0
info:
  title: TinyCommand TinyTables 40 articles Spreadsheet-database hybrid, with 37 column types, six vi API
  version: '2026-10-19'
  description: 'GENERATED FROM DOCUMENTATION by API Evangelist on 2026-10-19: 8 operation(s) read from 1 public documentation page(s) (each operation
    names its page in x-source). This is not the provider''s published contract; TinyCommand has published no machine-readable contract that the
    pipeline could find. Engine: local.'
  x-evidence-tiers:
    code-example: 5
    documentation: 16
    pages-with-code: 6
    pages-read: 8
  x-generated-from: documentation
  x-provenance: generated
  x-authored-by: API Evangelist
  x-generated: '2026-10-19'
  x-generator: generate-contract-from-docs.py
  x-engine: local
  x-sources:
  - https://tinycommand.com/docs/tables/api
  x-docs-section: tables
servers:
- url: https://mcp.tinycommand.com
paths:
  /tables:
    get:
      operationId: get_tables
      tags:
      - Tables
      summary: List tables
      x-source: https://tinycommand.com/docs/tables/api
      responses:
        '200':
          description: Success (status as documented)
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/GetTablesResponse'
      x-evidence:
        kind: documentation
  /tables/{tableid}:
    get:
      operationId: get_tables_tableid
      tags:
      - Tables
      summary: Get table schema
      x-source: https://tinycommand.com/docs/tables/api
      parameters:
      - name: tableid
        in: path
        required: true
        schema:
          type: string
      responses:
        '200':
          description: Success (status as documented)
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/GetTablesTableidResponse'
      x-evidence:
        kind: documentation
  /tables/{tableid}/rows:
    get:
      operationId: get_tables_tableid_rows
      tags:
      - Tables
      summary: List rows
      x-source: https://tinycommand.com/docs/tables/api
      parameters:
      - name: tableid
        in: path
        required: true
        schema:
          type: string
      - name: limit
        in: query
        required: false
        schema:
          type: number
        description: 'Max rows to return (default: 100, max: 1000)'
      - name: offset
        in: query
        required: false
        schema:
          type: number
        description: Skip N rows for pagination
      - name: sort
        in: query
        required: false
        schema:
          type: string
        description: Column to sort by (e.g., created_at)
      - name: order
        in: query
        required: false
        schema:
          type: string
        description: asc or desc
      - name: filter
        in: query
        required: false
        schema:
          type: string
        description: JSON filter conditions (URL-encoded)
      responses:
        '200':
          description: Success (status as documented)
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/GetTablesTableidRowsResponse'
      x-evidence:
        kind: documentation
    post:
      operationId: post_tables_tableid_rows
      tags:
      - Tables
      summary: Create a row
      x-source: https://tinycommand.com/docs/tables/api
      parameters:
      - name: tableid
        in: path
        required: true
        schema:
          type: string
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/PostTablesTableidRowsRequest'
      responses:
        '201':
          description: Success (status as documented)
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/PostTablesTableidRowsResponse'
      x-evidence:
        kind: documentation
  /tables/{tableid}/rows/{rowid}:
    delete:
      operationId: delete_tables_tableid_rows_rowid
      tags:
      - Tables
      summary: Delete a row
      x-source: https://tinycommand.com/docs/tables/api
      parameters:
      - name: tableid
        in: path
        required: true
        schema:
          type: string
      - name: rowid
        in: path
        required: true
        schema:
          type: string
      responses:
        '200':
          description: Success (status as documented)
      x-evidence:
        kind: documentation
    patch:
      operationId: patch_tables_tableid_rows_rowid
      tags:
      - Tables
      summary: Update a row
      x-source: https://tinycommand.com/docs/tables/api
      parameters:
      - name: tableid
        in: path
        required: true
        schema:
          type: string
      - name: rowid
        in: path
        required: true
        schema:
          type: string
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/PatchTablesTableidRowsRowidRequest'
      responses:
        '200':
          description: Success (status as documented)
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/PatchTablesTableidRowsRowidResponse'
      x-evidence:
        kind: documentation
  /tables/{tableid}/rows/bulk:
    post:
      operationId: post_tables_tableid_rows_bulk
      tags:
      - Tables
      summary: Create multiple rows
      x-source: https://tinycommand.com/docs/tables/api
      parameters:
      - name: tableid
        in: path
        required: true
        schema:
          type: string
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/PostTablesTableidRowsBulkRequest'
      responses:
        '201':
          description: Success (status as documented)
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/PostTablesTableidRowsBulkResponse'
      x-evidence:
        kind: documentation
  /v1/tables:
    get:
      operationId: get_v1_tables
      tags:
      - Tables
      summary: GET /v1/tables
      x-source: https://tinycommand.com/docs/tables/api
      responses:
        '200':
          description: Success (shape read from the example response on the page)
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/GetV1TablesResponse'
      x-evidence:
        kind: code-example
        language: curl
        snippet: "curl -H \"Authorization: Bearer YOUR_API_KEY\"  https://api.tinycommand.com/v1/tables\n Copy \n Generate API keys in Settings\
          \ → API Keys (see API Keys ). \n Base URL \n https://api.tinycommand.com/v1\n Copy \n Endpoints \n List tables \n GET /tables\n Copy\
          \ \n Returns all tables in your workspace. \n Response: \n {\n \"tables\": [\n {\n \"id\": \"tbl_abc123\",\n \"name\": \"Leads\",\n\
          \ \"columns\": 12,\n \"rows\": 1547,\n \"created_at"
security:
- bearer: []
components:
  schemas:
    GetTablesResponse:
      type: object
      properties:
        tables:
          type: array
          description: Array of table objects
    GetTablesTableidResponse:
      type: object
      properties:
        id:
          type: string
        name:
          type: string
        columns:
          type: array
          description: Column definitions
    GetTablesTableidRowsResponse:
      type: object
      properties:
        rows:
          type: array
          description: Array of row objects
        total:
          type: number
        limit:
          type: number
        offset:
          type: number
    PostTablesTableidRowsRequest:
      type: object
      properties:
        fields:
          type: object
          description: Key‑value pairs for the row fields
      required:
      - fields
    PostTablesTableidRowsResponse:
      type: object
      properties:
        id:
          type: string
          description: Generated row ID
        fields:
          type: object
        created_at:
          type: string
        updated_at:
          type: string
    PatchTablesTableidRowsRowidRequest:
      type: object
      properties:
        fields:
          type: object
          description: Fields to update
      required:
      - fields
    PatchTablesTableidRowsRowidResponse:
      type: object
      properties:
        id:
          type: string
        fields:
          type: object
        created_at:
          type: string
        updated_at:
          type: string
    PostTablesTableidRowsBulkRequest:
      type: object
      properties:
        rows:
          type: array
          description: Array of row objects with fields
      required:
      - rows
    PostTablesTableidRowsBulkResponse:
      type: object
      properties:
        rows:
          type: array
          description: Created rows with generated IDs
    GetV1TablesResponse:
      type: object
      properties:
        tables:
          type: array
          items:
            type: object
            properties:
              id:
                type: string
              name:
                type: string
              columns:
                type: integer
              rows:
                type: integer
              created_at:
                type: string
                format: date-time
  securitySchemes:
    bearer:
      type: http
      scheme: bearer
tags:
- name: Tables