Oracle Database Oracle REST Data Services (ORDS) API — Monitoring

naftiko: 1.0.0-alpha2
info:
  label: Oracle Database Oracle REST Data Services (ORDS) API — Monitoring
  description: 'Oracle Database Oracle REST Data Services (ORDS) API — Monitoring. 10 operations. Lead operation: Oracle Database
    Get all alerts. Self-contained Naftiko capability covering one Oracle Database business surface.'
  tags:
  - Oracle Database
  - Monitoring
  created: '2026-05-19'
  modified: '2026-05-19'
binds:
- namespace: env
  keys:
    ORACLE_DATABASE_API_KEY: ORACLE_DATABASE_API_KEY
capability:
  consumes:
  - type: http
    namespace: ords-monitoring
    baseUri: https://{host}:{port}/ords
    description: Oracle Database Oracle REST Data Services (ORDS) API — Monitoring business capability. Self-contained, no
      shared references.
    resources:
    - name: database-monitoring-alerts
      path: /database/monitoring/alerts/
      operations:
      - name: getalerts
        method: GET
        description: Oracle Database Get all alerts
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: database-monitoring-alerts_summaries-by_message_level
      path: /database/monitoring/alerts_summaries/by_message_level
      operations:
      - name: getalertsummaries
        method: GET
        description: Oracle Database Get alert summaries by message level
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: database-monitoring-session_limits
      path: /database/monitoring/session_limits
      operations:
      - name: getsessionlimits
        method: GET
        description: Oracle Database Get session limits
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: database-monitoring-session_locks
      path: /database/monitoring/session_locks/
      operations:
      - name: getsessionlocks
        method: GET
        description: Oracle Database Get all session locks
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: database-monitoring-session_locks-holding
      path: /database/monitoring/session_locks/holding/
      operations:
      - name: getblockinglocks
        method: GET
        description: Oracle Database Get blocking locks
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: database-monitoring-session_locks-waiting
      path: /database/monitoring/session_locks/waiting/
      operations:
      - name: getwaitinglocks
        method: GET
        description: Oracle Database Get waiting locks
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: database-monitoring-sessions
      path: /database/monitoring/sessions/
      operations:
      - name: getsessions
        method: GET
        description: Oracle Database Get all sessions
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: database-monitoring-sessions-sid},{serial_number
      path: /database/monitoring/sessions/{sid},{serial_number}/
      operations:
      - name: getsession
        method: GET
        description: Oracle Database Get a specific session
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: sid
          in: path
          type: integer
          required: true
        - name: serial_number
          in: path
          type: integer
          required: true
    - name: database-monitoring-wait_class_metrics
      path: /database/monitoring/wait_class_metrics
      operations:
      - name: getwaitclassmetrics
        method: GET
        description: Oracle Database Get wait class metrics
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: database-monitoring-wait_class_totals
      path: /database/monitoring/wait_class_totals
      operations:
      - name: getwaitclasstotals
        method: GET
        description: Oracle Database Get wait class totals
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    authentication:
      type: bearer
      token: '{{env.ORACLE_DATABASE_API_KEY}}'
  exposes:
  - type: rest
    namespace: ords-monitoring-rest
    port: 8080
    description: REST adapter for Oracle Database Oracle REST Data Services (ORDS) API — Monitoring. One Spectral-compliant
      resource per consumed operation, prefixed with /v1.
    resources:
    - path: /v1/database/monitoring/alerts
      name: database-monitoring-alerts
      description: REST surface for database-monitoring-alerts.
      operations:
      - method: GET
        name: getalerts
        description: Oracle Database Get all alerts
        call: ords-monitoring.getalerts
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/monitoring/alerts-summaries/by-message-level
      name: database-monitoring-alerts-summaries-by-message-level
      description: REST surface for database-monitoring-alerts_summaries-by_message_level.
      operations:
      - method: GET
        name: getalertsummaries
        description: Oracle Database Get alert summaries by message level
        call: ords-monitoring.getalertsummaries
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/monitoring/session-limits
      name: database-monitoring-session-limits
      description: REST surface for database-monitoring-session_limits.
      operations:
      - method: GET
        name: getsessionlimits
        description: Oracle Database Get session limits
        call: ords-monitoring.getsessionlimits
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/monitoring/session-locks
      name: database-monitoring-session-locks
      description: REST surface for database-monitoring-session_locks.
      operations:
      - method: GET
        name: getsessionlocks
        description: Oracle Database Get all session locks
        call: ords-monitoring.getsessionlocks
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/monitoring/session-locks/holding
      name: database-monitoring-session-locks-holding
      description: REST surface for database-monitoring-session_locks-holding.
      operations:
      - method: GET
        name: getblockinglocks
        description: Oracle Database Get blocking locks
        call: ords-monitoring.getblockinglocks
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/monitoring/session-locks/waiting
      name: database-monitoring-session-locks-waiting
      description: REST surface for database-monitoring-session_locks-waiting.
      operations:
      - method: GET
        name: getwaitinglocks
        description: Oracle Database Get waiting locks
        call: ords-monitoring.getwaitinglocks
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/monitoring/sessions
      name: database-monitoring-sessions
      description: REST surface for database-monitoring-sessions.
      operations:
      - method: GET
        name: getsessions
        description: Oracle Database Get all sessions
        call: ords-monitoring.getsessions
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/monitoring/sessions/{sid-serial-number}
      name: database-monitoring-sessions-sid-serial-number
      description: REST surface for database-monitoring-sessions-sid},{serial_number.
      operations:
      - method: GET
        name: getsession
        description: Oracle Database Get a specific session
        call: ords-monitoring.getsession
        with:
          sid: rest.sid
          serial_number: rest.serial_number
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/monitoring/wait-class-metrics
      name: database-monitoring-wait-class-metrics
      description: REST surface for database-monitoring-wait_class_metrics.
      operations:
      - method: GET
        name: getwaitclassmetrics
        description: Oracle Database Get wait class metrics
        call: ords-monitoring.getwaitclassmetrics
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/monitoring/wait-class-totals
      name: database-monitoring-wait-class-totals
      description: REST surface for database-monitoring-wait_class_totals.
      operations:
      - method: GET
        name: getwaitclasstotals
        description: Oracle Database Get wait class totals
        call: ords-monitoring.getwaitclasstotals
        outputParameters:
        - type: object
          mapping: $.
  - type: mcp
    namespace: ords-monitoring-mcp
    port: 9090
    transport: http
    description: MCP adapter for Oracle Database Oracle REST Data Services (ORDS) API — Monitoring. One tool per consumed
      operation, routed inline through this capability's consumes block.
    tools:
    - name: oracle-database-get-all-alerts
      description: Oracle Database Get all alerts
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: ords-monitoring.getalerts
      outputParameters:
      - type: object
        mapping: $.
    - name: oracle-database-get-alert-summaries
      description: Oracle Database Get alert summaries by message level
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: ords-monitoring.getalertsummaries
      outputParameters:
      - type: object
        mapping: $.
    - name: oracle-database-get-session-limits
      description: Oracle Database Get session limits
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: ords-monitoring.getsessionlimits
      outputParameters:
      - type: object
        mapping: $.
    - name: oracle-database-get-all-session
      description: Oracle Database Get all session locks
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: ords-monitoring.getsessionlocks
      outputParameters:
      - type: object
        mapping: $.
    - name: oracle-database-get-blocking-locks
      description: Oracle Database Get blocking locks
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: ords-monitoring.getblockinglocks
      outputParameters:
      - type: object
        mapping: $.
    - name: oracle-database-get-waiting-locks
      description: Oracle Database Get waiting locks
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: ords-monitoring.getwaitinglocks
      outputParameters:
      - type: object
        mapping: $.
    - name: oracle-database-get-all-sessions
      description: Oracle Database Get all sessions
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: ords-monitoring.getsessions
      outputParameters:
      - type: object
        mapping: $.
    - name: oracle-database-get-specific-session
      description: Oracle Database Get a specific session
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: ords-monitoring.getsession
      with:
        sid: tools.sid
        serial_number: tools.serial_number
      outputParameters:
      - type: object
        mapping: $.
    - name: oracle-database-get-wait-class
      description: Oracle Database Get wait class metrics
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: ords-monitoring.getwaitclassmetrics
      outputParameters:
      - type: object
        mapping: $.
    - name: oracle-database-get-wait-class-2
      description: Oracle Database Get wait class totals
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: ords-monitoring.getwaitclasstotals
      outputParameters:
      - type: object
        mapping: $.