Unisson appdb API

The appdb API from Unisson — 7 operation(s) for appdb.

Operations 7

POST /api/v1/appdb/query Run Query #
POST /api/v1/appdb/execute Run Execute #
GET /api/v1/appdb/tables List Tables #
POST /api/v1/appdb/apps/{app_id}/query App Query #
POST /api/v1/appdb/apps/{app_id}/execute App Execute #
POST /api/v1/appdb/sandbox/query Sandbox Query #
POST /api/v1/appdb/sandbox/execute Sandbox Execute #

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/unisson-appdb-api"
All apis
curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

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.

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

OpenAPI Specification

unisson-appdb-api-openapi.yml Raw ↑
openapi: 3.2.0
info:
  title: Unisson agent-evals Appdb API
  version: 1.0.0
servers:
- url: https://api.unisson.ai
  description: Base URL declared by the provider in apis.yml (roadmap#122).
tags:
- name: appdb
paths:
  /api/v1/appdb/query:
    post:
      tags:
      - appdb
      summary: Run Query
      operationId: run_query_api_v1_appdb_query_post
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/AppDbStatementRequest'
        required: true
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/AppDbQueryResponse'
        '422':
          description: Validation Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
      security:
      - HTTPBearer: []
  /api/v1/appdb/execute:
    post:
      tags:
      - appdb
      summary: Run Execute
      operationId: run_execute_api_v1_appdb_execute_post
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/AppDbStatementRequest'
        required: true
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/AppDbExecuteResponse'
        '422':
          description: Validation Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
      security:
      - HTTPBearer: []
  /api/v1/appdb/tables:
    get:
      tags:
      - appdb
      summary: List Tables
      operationId: list_tables_api_v1_appdb_tables_get
      security:
      - HTTPBearer: []
      parameters:
      - name: scope
        in: query
        required: false
        schema:
          anyOf:
          - type: string
          - type: 'null'
          title: Scope
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/AppDbTablesResponse'
        '422':
          description: Validation Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
  /api/v1/appdb/apps/{app_id}/query:
    post:
      tags:
      - appdb
      summary: App Query
      operationId: app_query_api_v1_appdb_apps__app_id__query_post
      security:
      - HTTPBearer: []
      parameters:
      - name: app_id
        in: path
        required: true
        schema:
          type: string
          format: uuid
          title: App Id
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/AppDbStatementRequest'
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/AppDbQueryResponse'
        '422':
          description: Validation Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
  /api/v1/appdb/apps/{app_id}/execute:
    post:
      tags:
      - appdb
      summary: App Execute
      operationId: app_execute_api_v1_appdb_apps__app_id__execute_post
      security:
      - HTTPBearer: []
      parameters:
      - name: app_id
        in: path
        required: true
        schema:
          type: string
          format: uuid
          title: App Id
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/AppDbStatementRequest'
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/AppDbExecuteResponse'
        '422':
          description: Validation Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
  /api/v1/appdb/sandbox/query:
    post:
      tags:
      - appdb
      summary: Sandbox Query
      operationId: sandbox_query_api_v1_appdb_sandbox_query_post
      parameters:
      - name: authorization
        in: header
        required: false
        schema:
          type: string
          default: ''
          title: Authorization
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/AppDbStatementRequest'
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/AppDbQueryResponse'
        '422':
          description: Validation Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
  /api/v1/appdb/sandbox/execute:
    post:
      tags:
      - appdb
      summary: Sandbox Execute
      operationId: sandbox_execute_api_v1_appdb_sandbox_execute_post
      parameters:
      - name: authorization
        in: header
        required: false
        schema:
          type: string
          default: ''
          title: Authorization
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/AppDbStatementRequest'
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/AppDbExecuteResponse'
        '422':
          description: Validation Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
components:
  schemas:
    AppDbColumn:
      properties:
        name:
          type: string
          title: Name
        type:
          type: string
          title: Type
        nullable:
          type: boolean
          title: Nullable
        default:
          anyOf:
          - type: string
          - type: 'null'
          title: Default
      type: object
      required:
      - name
      - type
      - nullable
      title: AppDbColumn
    AppDbQueryResponse:
      properties:
        columns:
          items:
            type: string
          type: array
          title: Columns
        rows:
          items:
            additionalProperties: true
            type: object
          type: array
          title: Rows
        row_count:
          type: integer
          title: Row Count
        truncated:
          type: boolean
          title: Truncated
      type: object
      required:
      - columns
      - rows
      - row_count
      - truncated
      title: AppDbQueryResponse
    ValidationError:
      properties:
        loc:
          items:
            anyOf:
            - type: string
            - type: integer
          type: array
          title: Location
        msg:
          type: string
          title: Message
        type:
          type: string
          title: Error Type
        input:
          title: Input
        ctx:
          type: object
          title: Context
      type: object
      required:
      - loc
      - msg
      - type
      title: ValidationError
    AppDbTablesResponse:
      properties:
        scope:
          type: string
          title: Scope
        tables:
          items:
            $ref: '#/components/schemas/AppDbTable'
          type: array
          title: Tables
      type: object
      required:
      - scope
      - tables
      title: AppDbTablesResponse
    AppDbTable:
      properties:
        name:
          type: string
          title: Name
        columns:
          items:
            $ref: '#/components/schemas/AppDbColumn'
          type: array
          title: Columns
        primary_key:
          items:
            type: string
          type: array
          title: Primary Key
        approx_rows:
          type: integer
          title: Approx Rows
      type: object
      required:
      - name
      - columns
      - primary_key
      - approx_rows
      title: AppDbTable
    AppDbStatementRequest:
      properties:
        sql:
          type: string
          maxLength: 100000
          minLength: 1
          title: Sql
        params:
          anyOf:
          - items: {}
            type: array
          - type: 'null'
          title: Params
        scope:
          anyOf:
          - type: string
          - type: 'null'
          title: Scope
      type: object
      required:
      - sql
      title: AppDbStatementRequest
    HTTPValidationError:
      properties:
        detail:
          items:
            $ref: '#/components/schemas/ValidationError'
          type: array
          title: Detail
      type: object
      title: HTTPValidationError
    AppDbExecuteResponse:
      properties:
        status:
          type: string
          title: Status
        statements:
          type: integer
          title: Statements
        rows:
          anyOf:
          - items:
              additionalProperties: true
              type: object
            type: array
          - type: 'null'
          title: Rows
      type: object
      required:
      - status
      - statements
      title: AppDbExecuteResponse
  securitySchemes:
    HTTPBearer:
      type: http
      scheme: bearer