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

# Handler for SQL INSERT statements

> POST /insert/sql
Body: { "sql": "INSERT INTO app::collection (col1, col2) VALUES (val1, val2)" }
Headers: X-App-Key (required for write authorization)

The SQL INSERT must use the "app::collection" format for table references.
This handler translates the SQL to JSON and calls the existing store_data handler.



## OpenAPI

````yaml /openapi.yaml post /insert/sql
openapi: 3.1.0
info:
  title: OnDB API
  description: Monetize anything
  license:
    name: ''
  version: 4.0.0
servers: []
security: []
tags:
  - name: Health
    description: Health check and system status
  - name: Applications
    description: Application management
  - name: Billing
    description: Billing information and usage
  - name: Pricing
    description: Pricing information and quotes
  - name: X402 Payment Protocol
    description: Payment verification and settlement
  - name: Data Storage
    description: Store data to Celestia blockchain
  - name: Data Query
    description: Query and retrieve data
  - name: Collections
    description: Collection management
  - name: Indexes
    description: Index management and relations
  - name: Retention
    description: Data retention policies
  - name: Materialized Views
    description: Materialized view management
  - name: Predefined Queries
    description: Create and execute predefined queries
  - name: View Query
    description: Query materialized view data
  - name: Wallet
    description: App wallet management
  - name: Tasks
    description: Task tracking and status
  - name: Transactions
    description: Transaction status
  - name: Authorization
    description: Authorization grant management
  - name: API Keys
    description: API key management
  - name: Encryption
    description: Encryption settings and configuration
  - name: Payout
    description: Payout settings and history
  - name: API Collections
    description: API collection management
paths:
  /insert/sql:
    post:
      tags:
        - Data Storage
      summary: Handler for SQL INSERT statements
      description: >-
        POST /insert/sql

        Body: { "sql": "INSERT INTO app::collection (col1, col2) VALUES (val1,
        val2)" }

        Headers: X-App-Key (required for write authorization)


        The SQL INSERT must use the "app::collection" format for table
        references.

        This handler translates the SQL to JSON and calls the existing
        store_data handler.
      operationId: handle_sql_insert
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/SqlInsertRequest'
        required: true
      responses:
        '200':
          description: SQL INSERT executed successfully
          content:
            application/json:
              schema: {}
        '400':
          description: Invalid SQL syntax or format
        '401':
          description: Unauthorized - API key required
        '402':
          description: Payment required
        '500':
          description: Internal server error
      security:
        - api_key: []
components:
  schemas:
    SqlInsertRequest:
      type: object
      description: SQL INSERT Request
      required:
        - sql
      properties:
        sql:
          type: string
          description: >-
            SQL INSERT statement

            Format: INSERT INTO app::collection (col1, col2) VALUES (val1,
            val2), (val3, val4)

            Example: "INSERT INTO myapp::users (name, email, age) VALUES
            ('Alice', 'alice@example.com', 25)"

````