Snowflake · Capability

Snowflake Alert API — alert

Snowflake Alert API — alert. 6 operations. Lead operation: List Alerts. Self-contained Naftiko capability covering one Snowflake business surface.

Run with Naftiko Snowflakealert

What You Can Do

GET
Listalerts — List Alerts
/v1/api/v2/databases/{database}/schemas/{schema}/alerts
POST
Createalert — Create an Alert
/v1/api/v2/databases/{database}/schemas/{schema}/alerts
GET
Fetchalert — Fetch an Alert
/v1/api/v2/databases/{database}/schemas/{schema}/alerts/{name}
DELETE
Deletealert — Delete an Alert
/v1/api/v2/databases/{database}/schemas/{schema}/alerts/{name}
POST
Clonealert — Create a New Alert by Cloning From the Specified Resource
/v1/api/v2/databases/{database}/schemas/{schema}/alerts/name-clone
POST
Executealert — Execute an Alert
/v1/api/v2/databases/{database}/schemas/{schema}/alerts/name-execute

MCP Tools

list-alerts

List Alerts

read-only idempotent
create-alert

Create an Alert

fetch-alert

Fetch an Alert

read-only idempotent
delete-alert

Delete an Alert

idempotent
create-new-alert-cloning-specified

Create a New Alert by Cloning From the Specified Resource

execute-alert

Execute an Alert

Capability Spec

alert-alert.yaml Raw ↑
naftiko: 1.0.0-alpha2
info:
  label: Snowflake Alert API — alert
  description: 'Snowflake Alert API — alert. 6 operations. Lead operation: List Alerts. Self-contained Naftiko capability
    covering one Snowflake business surface.'
  tags:
  - Snowflake
  - alert
  created: '2026-05-19'
  modified: '2026-05-19'
binds:
- namespace: env
  keys:
    SNOWFLAKE_API_KEY: SNOWFLAKE_API_KEY
capability:
  consumes:
  - type: http
    namespace: alert-alert
    baseUri: https://org-account.snowflakecomputing.com
    description: Snowflake Alert API — alert business capability. Self-contained, no shared references.
    resources:
    - name: api-v2-databases-database-schemas-schema-alerts
      path: /api/v2/databases/{database}/schemas/{schema}/alerts
      operations:
      - name: listalerts
        method: GET
        description: List Alerts
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
      - name: createalert
        method: POST
        description: Create an Alert
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: body
          in: body
          type: object
          description: Request body (JSON).
          required: true
    - name: api-v2-databases-database-schemas-schema-alerts-name
      path: /api/v2/databases/{database}/schemas/{schema}/alerts/{name}
      operations:
      - name: fetchalert
        method: GET
        description: Fetch an Alert
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
      - name: deletealert
        method: DELETE
        description: Delete an Alert
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: api-v2-databases-database-schemas-schema-alerts-name}:clone
      path: /api/v2/databases/{database}/schemas/{schema}/alerts/{name}:clone
      operations:
      - name: clonealert
        method: POST
        description: Create a New Alert by Cloning From the Specified Resource
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: targetDatabase
          in: query
          type: string
          description: Database of the newly created resource. Defaults to the source's database
          required: true
        - name: targetSchema
          in: query
          type: string
          description: Schema of the newly created resource. Defaults to the source's schema
          required: true
        - name: body
          in: body
          type: object
          description: Request body (JSON).
          required: true
    - name: api-v2-databases-database-schemas-schema-alerts-name}:execute
      path: /api/v2/databases/{database}/schemas/{schema}/alerts/{name}:execute
      operations:
      - name: executealert
        method: POST
        description: Execute an Alert
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
  exposes:
  - type: rest
    namespace: alert-alert-rest
    port: 8080
    description: REST adapter for Snowflake Alert API — alert. One Spectral-compliant resource per consumed operation, prefixed
      with /v1.
    resources:
    - path: /v1/api/v2/databases/{database}/schemas/{schema}/alerts
      name: api-v2-databases-database-schemas-schema-alerts
      description: REST surface for api-v2-databases-database-schemas-schema-alerts.
      operations:
      - method: GET
        name: listalerts
        description: List Alerts
        call: alert-alert.listalerts
        outputParameters:
        - type: object
          mapping: $.
      - method: POST
        name: createalert
        description: Create an Alert
        call: alert-alert.createalert
        with:
          body: rest.body
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/api/v2/databases/{database}/schemas/{schema}/alerts/{name}
      name: api-v2-databases-database-schemas-schema-alerts-name
      description: REST surface for api-v2-databases-database-schemas-schema-alerts-name.
      operations:
      - method: GET
        name: fetchalert
        description: Fetch an Alert
        call: alert-alert.fetchalert
        outputParameters:
        - type: object
          mapping: $.
      - method: DELETE
        name: deletealert
        description: Delete an Alert
        call: alert-alert.deletealert
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/api/v2/databases/{database}/schemas/{schema}/alerts/name-clone
      name: api-v2-databases-database-schemas-schema-alerts-name-clone
      description: REST surface for api-v2-databases-database-schemas-schema-alerts-name}:clone.
      operations:
      - method: POST
        name: clonealert
        description: Create a New Alert by Cloning From the Specified Resource
        call: alert-alert.clonealert
        with:
          targetDatabase: rest.targetDatabase
          targetSchema: rest.targetSchema
          body: rest.body
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/api/v2/databases/{database}/schemas/{schema}/alerts/name-execute
      name: api-v2-databases-database-schemas-schema-alerts-name-execute
      description: REST surface for api-v2-databases-database-schemas-schema-alerts-name}:execute.
      operations:
      - method: POST
        name: executealert
        description: Execute an Alert
        call: alert-alert.executealert
        outputParameters:
        - type: object
          mapping: $.
  - type: mcp
    namespace: alert-alert-mcp
    port: 9090
    transport: http
    description: MCP adapter for Snowflake Alert API — alert. One tool per consumed operation, routed inline through this
      capability's consumes block.
    tools:
    - name: list-alerts
      description: List Alerts
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: alert-alert.listalerts
      outputParameters:
      - type: object
        mapping: $.
    - name: create-alert
      description: Create an Alert
      hints:
        readOnly: false
        destructive: false
        idempotent: false
      call: alert-alert.createalert
      with:
        body: tools.body
      outputParameters:
      - type: object
        mapping: $.
    - name: fetch-alert
      description: Fetch an Alert
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: alert-alert.fetchalert
      outputParameters:
      - type: object
        mapping: $.
    - name: delete-alert
      description: Delete an Alert
      hints:
        readOnly: false
        destructive: true
        idempotent: true
      call: alert-alert.deletealert
      outputParameters:
      - type: object
        mapping: $.
    - name: create-new-alert-cloning-specified
      description: Create a New Alert by Cloning From the Specified Resource
      hints:
        readOnly: false
        destructive: false
        idempotent: false
      call: alert-alert.clonealert
      with:
        targetDatabase: tools.targetDatabase
        targetSchema: tools.targetSchema
        body: tools.body
      outputParameters:
      - type: object
        mapping: $.
    - name: execute-alert
      description: Execute an Alert
      hints:
        readOnly: false
        destructive: false
        idempotent: false
      call: alert-alert.executealert
      outputParameters:
      - type: object
        mapping: $.