AI for Database

AI for Database Query Approval API

Submit queries for human approval before execution

GitHub OpenAPI

Operations 10

GET /approval-rules List rules #
POST /approval-rules Create rule #
GET /approval-rules/{id} Get rule #
PATCH /approval-rules/{id} Update rule #
DELETE /approval-rules/{id} Delete rule #
POST /queries/submit Submit query for approval #
GET /queries/{id}/status Get query status #
GET /queries/pending List pending queries #
POST /queries/{id}/approve Approve query #
POST /queries/{id}/reject Reject query #

Documentation

📖
Documentation
https://aifordatabase.com/docs/api-overview/
📖
Documentation
https://app.aifordatabase.com/api/v1/docs
📖
Documentation
https://aifordatabase.com/for-agents/
📖
Documentation
https://aifordatabase.com/api/agents
📖
APIReference
https://app.aifordatabase.com/api/v1/docs
📖
Authentication
https://artifacts.apis.io/aifordatabase/authentication/aifordatabase-authentication.yml
📖
RateLimits
https://artifacts.apis.io/aifordatabase/rate-limits/aifordatabase-rate-limits.yml

Specifications

⚙
OpenAPI
https://artifacts.apis.io/aifordatabase/openapi/aifordatabase-query-approval-api-openapi.yml

Other Resources

🔗
LLMsTxt
https://www.aifordatabase.com/llms.txt
🔗
LLMsTxt
https://aifordatabase.com/llms-full.txt
🔗
DataModel
https://artifacts.apis.io/aifordatabase/data-model/aifordatabase-data-model.yml
🔗
ErrorCatalog
https://artifacts.apis.io/aifordatabase/errors/aifordatabase-problem-types.yml
🔗
Conventions
https://artifacts.apis.io/aifordatabase/conventions/aifordatabase-conventions.yml
🔗
Lifecycle
https://artifacts.apis.io/aifordatabase/lifecycle/aifordatabase-lifecycle.yml
🔗
Conformance
https://artifacts.apis.io/aifordatabase/conformance/aifordatabase-conformance.yml
🔗
Webhooks
https://artifacts.apis.io/aifordatabase/asyncapi/aifordatabase-webhooks.yml
🔗
ToolCrosswalk
https://artifacts.apis.io/aifordatabase/mcp/aifordatabase-tool-crosswalk.yml
🔗
LLMsTxt
https://artifacts.apis.io/aifordatabase/llms/aifordatabase-llms.txt

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This API 
curl "https://apis.io/api/v1/apis/aifordatabase:aifordatabase-query-approval-api"
All apis 
curl "https://apis.io/api/v1/apis?limit=25"

Calls without X-API-Key need no key. Calls with it need a paid plan — get a key.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

aifordatabase-query-approval-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  title: AI for Database Query Approval API
  version: 1.0.0
  description: API for AI agents to interact with databases through natural language, dashboards, workflows, and more.
servers:
- url: https://app.aifordatabase.com/api/v1
security:
- bearerAuth: []
tags:
- name: Query Approval
  description: Submit queries for human approval before execution
paths:
  /approval-rules:
    get:
      tags:
      - Query Approval
      summary: List rules
      operationId: listApprovalRules
      description: List query approval rules for the organization. Admin only.
      parameters:
      - $ref: '#/components/parameters/PageParam'
      - $ref: '#/components/parameters/PageSizeParam'
      responses:
        '200':
          description: Paginated approval rules
          content:
            application/json:
              schema:
                allOf:
                - $ref: '#/components/schemas/SuccessEnvelope'
                - type: object
                  properties:
                    data:
                      type: array
                      items:
                        $ref: '#/components/schemas/ApprovalRule'
        '403':
          $ref: '#/components/responses/Forbidden'
    post:
      tags:
      - Query Approval
      summary: Create rule
      operationId: createApprovalRule
      description: Create a new query approval rule. Admin only.
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/ApprovalRuleCreate'
      responses:
        '201':
          description: Approval rule created
          content:
            application/json:
              schema:
                allOf:
                - $ref: '#/components/schemas/SuccessEnvelope'
                - type: object
                  properties:
                    data:
                      $ref: '#/components/schemas/ApprovalRule'
        '400':
          $ref: '#/components/responses/BadRequest'
        '403':
          $ref: '#/components/responses/Forbidden'
  /approval-rules/{id}:
    get:
      tags:
      - Query Approval
      summary: Get rule
      operationId: getApprovalRule
      description: Get a single approval rule by ID. Admin only.
      parameters:
      - $ref: '#/components/parameters/IdParam'
      responses:
        '200':
          description: Approval rule details
          content:
            application/json:
              schema:
                allOf:
                - $ref: '#/components/schemas/SuccessEnvelope'
                - type: object
                  properties:
                    data:
                      $ref: '#/components/schemas/ApprovalRule'
        '404':
          $ref: '#/components/responses/NotFound'
    patch:
      tags:
      - Query Approval
      summary: Update rule
      operationId: updateApprovalRule
      description: Update an approval rule. Admin only.
      parameters:
      - $ref: '#/components/parameters/IdParam'
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/ApprovalRuleUpdate'
      responses:
        '200':
          description: Approval rule updated
          content:
            application/json:
              schema:
                allOf:
                - $ref: '#/components/schemas/SuccessEnvelope'
                - type: object
                  properties:
                    data:
                      $ref: '#/components/schemas/ApprovalRule'
        '400':
          $ref: '#/components/responses/BadRequest'
        '404':
          $ref: '#/components/responses/NotFound'
    delete:
      tags:
      - Query Approval
      summary: Delete rule
      operationId: deleteApprovalRule
      description: Delete an approval rule. Admin only.
      parameters:
      - $ref: '#/components/parameters/IdParam'
      responses:
        '200':
          description: Approval rule deleted
          content:
            application/json:
              schema:
                allOf:
                - $ref: '#/components/schemas/SuccessEnvelope'
                - type: object
                  properties:
                    data:
                      $ref: '#/components/schemas/DeletedResponse'
        '404':
          $ref: '#/components/responses/NotFound'
  /queries/submit:
    post:
      tags:
      - Query Approval
      summary: Submit query for approval
      operationId: submitQueryForApproval
      description: Submit a SQL query for human approval before execution. Returns a pending query ID for status polling.
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/QuerySubmitRequest'
      responses:
        '202':
          description: Query submitted for approval
          content:
            application/json:
              schema:
                allOf:
                - $ref: '#/components/schemas/SuccessEnvelope'
                - type: object
                  properties:
                    data:
                      type: object
                      properties:
                        pendingQueryId:
                          type: string
                        status:
                          type: string
                          enum:
                          - PENDING
                        expiresAt:
                          type: string
                          format: date-time
        '400':
          $ref: '#/components/responses/BadRequest'
        '404':
          $ref: '#/components/responses/NotFound'
  /queries/{id}/status:
    get:
      tags:
      - Query Approval
      summary: Get query status
      operationId: getQueryApprovalStatus
      description: Get the current status of a pending query. Automatically marks expired queries.
      parameters:
      - $ref: '#/components/parameters/IdParam'
      responses:
        '200':
          description: Pending query status
          content:
            application/json:
              schema:
                allOf:
                - $ref: '#/components/schemas/SuccessEnvelope'
                - type: object
                  properties:
                    data:
                      $ref: '#/components/schemas/PendingQuery'
        '404':
          $ref: '#/components/responses/NotFound'
  /queries/pending:
    get:
      tags:
      - Query Approval
      summary: List pending queries
      operationId: listPendingQueries
      description: List all queries awaiting approval. Admin only.
      parameters:
      - $ref: '#/components/parameters/PageParam'
      - $ref: '#/components/parameters/PageSizeParam'
      responses:
        '200':
          description: Paginated pending queries
          content:
            application/json:
              schema:
                allOf:
                - $ref: '#/components/schemas/SuccessEnvelope'
                - type: object
                  properties:
                    data:
                      type: array
                      items:
                        $ref: '#/components/schemas/PendingQuery'
        '403':
          $ref: '#/components/responses/Forbidden'
  /queries/{id}/approve:
    post:
      tags:
      - Query Approval
      summary: Approve query
      operationId: approveQuery
      description: Approve a pending query and execute it. The query result is returned in the response. Only authorized approvers can approve.
      parameters:
      - $ref: '#/components/parameters/IdParam'
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/ApproveRejectRequest'
      responses:
        '200':
          description: Query approved and executed
          content:
            application/json:
              schema:
                allOf:
                - $ref: '#/components/schemas/SuccessEnvelope'
                - type: object
                  properties:
                    data:
                      $ref: '#/components/schemas/ApprovalResult'
        '400':
          $ref: '#/components/responses/BadRequest'
        '403':
          $ref: '#/components/responses/Forbidden'
        '404':
          $ref: '#/components/responses/NotFound'
        '422':
          description: Query execution failed after approval
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorEnvelope'
  /queries/{id}/reject:
    post:
      tags:
      - Query Approval
      summary: Reject query
      operationId: rejectQuery
      description: Reject a pending query with an optional note.
      parameters:
      - $ref: '#/components/parameters/IdParam'
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/ApproveRejectRequest'
      responses:
        '200':
          description: Query rejected
          content:
            application/json:
              schema:
                allOf:
                - $ref: '#/components/schemas/SuccessEnvelope'
                - type: object
                  properties:
                    data:
                      type: object
                      properties:
                        id:
                          type: string
                        status:
                          type: string
                          enum:
                          - REJECTED
                        reviewedBy:
                          type: string
                        reviewNote:
                          type: string
                          nullable: true
        '400':
          $ref: '#/components/responses/BadRequest'
        '404':
          $ref: '#/components/responses/NotFound'
components:
  schemas:
    ApiError:
      type: object
      properties:
        code:
          type: string
        message:
          type: string
        details: {}
      required:
      - code
      - message
    ApprovalResult:
      type: object
      properties:
        id:
          type: string
        status:
          type: string
          enum:
          - APPROVED
          - REJECTED
        reviewedBy:
          type: string
        reviewNote:
          type: string
          nullable: true
        result:
          $ref: '#/components/schemas/QueryResult'
    ApprovalRule:
      type: object
      properties:
        id:
          type: string
        orgId:
          type: string
        connectionId:
          type: string
          nullable: true
        scope:
          type: string
        approvers:
          type: array
          items:
            type: string
        isActive:
          type: boolean
        createdAt:
          type: string
          format: date-time
        updatedAt:
          type: string
          format: date-time
    ApprovalRuleCreate:
      type: object
      required:
      - approvers
      properties:
        connectionId:
          type: string
        scope:
          type: string
          default: all
        approvers:
          type: array
          items:
            type: string
          description: User IDs of authorized approvers
    ApiMeta:
      type: object
      properties:
        requestId:
          type: string
          format: uuid
        timestamp:
          type: string
          format: date-time
        pagination:
          $ref: '#/components/schemas/Pagination'
      required:
      - requestId
      - timestamp
    QuerySubmitRequest:
      type: object
      required:
      - connectionId
      - query
      properties:
        connectionId:
          type: string
        query:
          type: string
        context:
          type: string
          description: Optional description of why this query needs to run
    ApproveRejectRequest:
      type: object
      properties:
        note:
          type: string
          description: Optional reviewer note
    ApprovalRuleUpdate:
      type: object
      properties:
        connectionId:
          type: string
          nullable: true
        scope:
          type: string
        approvers:
          type: array
          items:
            type: string
        isActive:
          type: boolean
    QueryResult:
      type: object
      description: Raw database result returned directly to the authenticated caller.
      properties:
        columns:
          type: array
          items:
            type: string
        rows:
          type: array
          items:
            type: object
        rowCount:
          type: integer
        executionTime:
          type: number
          description: Execution time in milliseconds
    PendingQuery:
      type: object
      properties:
        id:
          type: string
        connectionId:
          type: string
        connectionName:
          type: string
          nullable: true
        connectionType:
          type: string
          nullable: true
        apiKeyId:
          type: string
          nullable: true
        query:
          type: string
        context:
          type: string
          nullable: true
        status:
          type: string
          enum:
          - PENDING
          - APPROVED
          - REJECTED
          - EXPIRED
        reviewNote:
          type: string
          nullable: true
        result:
          nullable: true
          description: Query result (only present after approval)
        expiresAt:
          type: string
          format: date-time
        createdAt:
          type: string
          format: date-time
    Pagination:
      type: object
      properties:
        total:
          type: integer
        page:
          type: integer
        pageSize:
          type: integer
        totalPages:
          type: integer
      required:
      - total
      - page
      - pageSize
      - totalPages
    ErrorEnvelope:
      type: object
      properties:
        data:
          type: 'null'
        error:
          $ref: '#/components/schemas/ApiError'
        meta:
          $ref: '#/components/schemas/ApiMeta'
      required:
      - data
      - error
      - meta
    SuccessEnvelope:
      type: object
      properties:
        data: {}
        error:
          type: 'null'
        meta:
          $ref: '#/components/schemas/ApiMeta'
      required:
      - data
      - error
      - meta
    DeletedResponse:
      type: object
      properties:
        deleted:
          type: boolean
          example: true
  parameters:
    IdParam:
      name: id
      in: path
      required: true
      schema:
        type: string
      description: Resource ID
    PageParam:
      name: page
      in: query
      schema:
        type: integer
        default: 1
      description: Page number (1-based)
    PageSizeParam:
      name: pageSize
      in: query
      schema:
        type: integer
        default: 20
        maximum: 100
      description: Items per page (max 100)
  responses:
    BadRequest:
      description: Validation error or bad request
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/ErrorEnvelope'
    Forbidden:
      description: Insufficient permissions
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/ErrorEnvelope'
    NotFound:
      description: Resource not found
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/ErrorEnvelope'
  securitySchemes:
    bearerAuth:
      type: http
      scheme: bearer
      bearerFormat: API Key
      description: Platform API key starting with afd_
x-provenance:
  method: harvested
  publisher: AI for Database
  source: https://www.aifordatabase.com/openapi.json
  note: split by refine-openapis from the provider's own published document, verified by fetch (openapi/_original/*.fetch.json);
    stamped by stamp-openapi-provenance.py (roadmap#793)