Amigo

Amigo Insights API

The Insights API from Amigo — 7 operation(s) for insights.

Documentation GitHub OpenAPI

Business capability

Analytics & BI Management BC-610.50

Operations 7

POST /v1/{workspace_id}/insights/sql Execute Sql #

GET /v1/{workspace_id}/insights/schema Describe Schema #

GET /v1/{workspace_id}/insights/suggestions Get Suggestions #

GET /v1/{workspace_id}/insights/digest Get Digest #

POST /v1/{workspace_id}/insights/sessions Create Session #

POST /v1/{workspace_id}/insights/sessions/{session_id}/chat Chat #

GET /v1/{workspace_id}/insights/sessions/{session_id} Get Session #

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/amigo:amigo-insights-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.

GitHub Google LinkedIn

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

OpenAPI Specification

openapi: 3.2.0
info:
  title: Platform Insights API
  description: Management API for the Amigo platform. Provides CRUD operations for workspaces, API keys, and resources.
  version: 1.0.0
servers:
- url: https://api.platform.amigo.ai
  description: Production
security:
- BearerAuth: []
tags:
- name: Insights
paths:
  /v1/{workspace_id}/insights/sql:
    post:
      tags:
      - Insights
      summary: Execute Sql
      description: Execute a read-only SQL query against Databricks.
      operationId: execute_sql_v1__workspace_id__insights_sql_post
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/SqlQueryRequest'
        required: true
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/SqlQueryResponse'
        '422':
          description: Validation Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
      parameters:
      - name: workspace_id
        in: path
        required: true
        schema:
          type: string
          format: uuid
          title: Workspace Id
  /v1/{workspace_id}/insights/schema:
    get:
      tags:
      - Insights
      summary: Describe Schema
      description: List available tables, columns, and functions.
      operationId: describe_schema_v1__workspace_id__insights_schema_get
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/SchemaResponse'
      parameters:
      - name: workspace_id
        in: path
        required: true
        schema:
          type: string
          format: uuid
          title: Workspace Id
  /v1/{workspace_id}/insights/suggestions:
    get:
      tags:
      - Insights
      summary: Get Suggestions
      description: Get contextual starter questions for the insights agent.
      operationId: get_suggestions_v1__workspace_id__insights_suggestions_get
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/SuggestionsResponse'
      parameters:
      - name: workspace_id
        in: path
        required: true
        schema:
          type: string
          format: uuid
          title: Workspace Id
  /v1/{workspace_id}/insights/digest:
    get:
      tags:
      - Insights
      summary: Get Digest
      description: Proactive workspace health digest. Cached 5 minutes.
      operationId: get_digest_v1__workspace_id__insights_digest_get
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                additionalProperties: true
                type: object
                title: Response Get Digest V1  Workspace Id  Insights Digest Get
      parameters:
      - name: workspace_id
        in: path
        required: true
        schema:
          type: string
          format: uuid
          title: Workspace Id
  /v1/{workspace_id}/insights/sessions:
    post:
      tags:
      - Insights
      summary: Create Session
      description: Create a new insights chat session.
      operationId: create_session_v1__workspace_id__insights_sessions_post
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/SessionResponse'
      parameters:
      - name: workspace_id
        in: path
        required: true
        schema:
          type: string
          format: uuid
          title: Workspace Id
  /v1/{workspace_id}/insights/sessions/{session_id}/chat:
    post:
      tags:
      - Insights
      summary: Chat
      description: Chat with the insights agent. Returns SSE stream of visual blocks.
      operationId: chat_v1__workspace_id__insights_sessions__session_id__chat_post
      parameters:
      - name: workspace_id
        in: path
        required: true
        schema:
          type: string
          format: uuid
          title: Workspace Id
      - name: session_id
        in: path
        required: true
        schema:
          type: string
          maxLength: 64
          description: Session ID
          title: Session Id
        description: Session ID
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/ChatRequest'
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema: {}
        '422':
          description: Validation Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
  /v1/{workspace_id}/insights/sessions/{session_id}:
    get:
      tags:
      - Insights
      summary: Get Session
      description: Get insights session history.
      operationId: get_session_v1__workspace_id__insights_sessions__session_id__get
      parameters:
      - name: workspace_id
        in: path
        required: true
        schema:
          type: string
          format: uuid
          title: Workspace Id
      - name: session_id
        in: path
        required: true
        schema:
          type: string
          maxLength: 64
          description: Session ID
          title: Session Id
        description: Session ID
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                type: object
                additionalProperties: true
                title: Response Get Session V1  Workspace Id  Insights Sessions  Session Id  Get
        '422':
          description: Validation Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
components:
  schemas:
    SessionResponse:
      properties:
        id:
          type: string
          title: Id
        created_at:
          anyOf:
          - type: string
          - type: 'null'
          title: Created At
      type: object
      required:
      - id
      title: SessionResponse
    SchemaResponse:
      properties:
        lakebase_tables:
          additionalProperties:
            additionalProperties:
              type: string
            type: object
          type: object
          title: Lakebase Tables
        databricks_catalogs:
          items:
            type: string
          type: array
          title: Databricks Catalogs
        uc_functions:
          items:
            additionalProperties:
              type: string
            type: object
          type: array
          title: Uc Functions
        ai_functions:
          items:
            type: string
          type: array
          title: Ai Functions
      type: object
      required:
      - lakebase_tables
      - databricks_catalogs
      - uc_functions
      - ai_functions
      title: SchemaResponse
    SqlQueryRequest:
      properties:
        sql:
          type: string
          maxLength: 50000
          minLength: 1
          title: Sql
          description: Read-only SQL query against Databricks.
      type: object
      required:
      - sql
      title: SqlQueryRequest
    SuggestionsResponse:
      properties:
        suggestions:
          items:
            type: string
          type: array
          title: Suggestions
      type: object
      required:
      - suggestions
      title: SuggestionsResponse
    SqlQueryResponse:
      properties:
        results:
          anyOf:
          - items:
              additionalProperties: true
              type: object
            type: array
          - type: 'null'
          title: Results
        count:
          anyOf:
          - type: integer
          - type: 'null'
          title: Count
        error:
          anyOf:
          - type: string
          - type: 'null'
          title: Error
      type: object
      title: SqlQueryResponse
    HTTPValidationError:
      properties:
        detail:
          items:
            $ref: '#/components/schemas/ValidationError'
          type: array
          title: Detail
      type: object
      title: HTTPValidationError
    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
    ChatRequest:
      properties:
        message:
          type: string
          maxLength: 16000
          minLength: 1
          title: Message
          description: Insights chat user message.
      type: object
      required:
      - message
      title: ChatRequest
  securitySchemes:
    BearerAuth:
      type: http
      scheme: bearer
      description: API key issued via `POST /v1/{workspace_id}/api-keys`. Pass the returned `api_key` value as a Bearer token.