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

naftiko: 1.0.0-alpha2
info:
  label: Oracle Database Oracle REST Data Services (ORDS) API — Performance
  description: 'Oracle Database Oracle REST Data Services (ORDS) API — Performance. 8 operations. Lead operation: Oracle Database
    Get active sessions history. Self-contained Naftiko capability covering one Oracle Database business surface.'
  tags:
  - Oracle Database
  - Performance
  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-performance
    baseUri: https://{host}:{port}/ords
    description: Oracle Database Oracle REST Data Services (ORDS) API — Performance business capability. Self-contained, no
      shared references.
    resources:
    - name: database-performance-active_sessions_history
      path: /database/performance/active_sessions_history/
      operations:
      - name: getactivesessionshistory
        method: GET
        description: Oracle Database Get active sessions history
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: database-performance-active_sessions_history_waits
      path: /database/performance/active_sessions_history_waits/
      operations:
      - name: getactivesessionshistorywaits
        method: GET
        description: Oracle Database Get active session history waits
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: database-performance-sql_statements
      path: /database/performance/sql_statements/
      operations:
      - name: getsqlstatements
        method: GET
        description: Oracle Database Get all SQL statements
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: database-performance-sql_statements-sql_id
      path: /database/performance/sql_statements/{sql_id}/
      operations:
      - name: getsqlstatementstats
        method: GET
        description: Oracle Database Get SQL statement statistics
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: sql_id
          in: path
          type: string
          required: true
    - name: database-performance-sql_statements-sql_id-history
      path: /database/performance/sql_statements/{sql_id}/history
      operations:
      - name: getsqlhistory
        method: GET
        description: Oracle Database Get SQL statement history
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: sql_id
          in: path
          type: string
          required: true
    - name: database-performance-sql_statements-sql_id-plan
      path: /database/performance/sql_statements/{sql_id}/plan
      operations:
      - name: getsqlexecutionplan
        method: GET
        description: Oracle Database Get SQL execution plan
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: sql_id
          in: path
          type: string
          required: true
    - name: database-performance-sql_statements-sql_id-text
      path: /database/performance/sql_statements/{sql_id}/text
      operations:
      - name: getsqlstatementtext
        method: GET
        description: Oracle Database Get SQL statement text
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: sql_id
          in: path
          type: string
          required: true
    - name: database-performance-top_sql_statements
      path: /database/performance/top_sql_statements/
      operations:
      - name: gettopsqlstatements
        method: GET
        description: Oracle Database Get top SQL by CPU usage
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    authentication:
      type: bearer
      token: '{{env.ORACLE_DATABASE_API_KEY}}'
  exposes:
  - type: rest
    namespace: ords-performance-rest
    port: 8080
    description: REST adapter for Oracle Database Oracle REST Data Services (ORDS) API — Performance. One Spectral-compliant
      resource per consumed operation, prefixed with /v1.
    resources:
    - path: /v1/database/performance/active-sessions-history
      name: database-performance-active-sessions-history
      description: REST surface for database-performance-active_sessions_history.
      operations:
      - method: GET
        name: getactivesessionshistory
        description: Oracle Database Get active sessions history
        call: ords-performance.getactivesessionshistory
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/performance/active-sessions-history-waits
      name: database-performance-active-sessions-history-waits
      description: REST surface for database-performance-active_sessions_history_waits.
      operations:
      - method: GET
        name: getactivesessionshistorywaits
        description: Oracle Database Get active session history waits
        call: ords-performance.getactivesessionshistorywaits
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/performance/sql-statements
      name: database-performance-sql-statements
      description: REST surface for database-performance-sql_statements.
      operations:
      - method: GET
        name: getsqlstatements
        description: Oracle Database Get all SQL statements
        call: ords-performance.getsqlstatements
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/performance/sql-statements/{sql-id}
      name: database-performance-sql-statements-sql-id
      description: REST surface for database-performance-sql_statements-sql_id.
      operations:
      - method: GET
        name: getsqlstatementstats
        description: Oracle Database Get SQL statement statistics
        call: ords-performance.getsqlstatementstats
        with:
          sql_id: rest.sql_id
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/performance/sql-statements/{sql-id}/history
      name: database-performance-sql-statements-sql-id-history
      description: REST surface for database-performance-sql_statements-sql_id-history.
      operations:
      - method: GET
        name: getsqlhistory
        description: Oracle Database Get SQL statement history
        call: ords-performance.getsqlhistory
        with:
          sql_id: rest.sql_id
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/performance/sql-statements/{sql-id}/plan
      name: database-performance-sql-statements-sql-id-plan
      description: REST surface for database-performance-sql_statements-sql_id-plan.
      operations:
      - method: GET
        name: getsqlexecutionplan
        description: Oracle Database Get SQL execution plan
        call: ords-performance.getsqlexecutionplan
        with:
          sql_id: rest.sql_id
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/performance/sql-statements/{sql-id}/text
      name: database-performance-sql-statements-sql-id-text
      description: REST surface for database-performance-sql_statements-sql_id-text.
      operations:
      - method: GET
        name: getsqlstatementtext
        description: Oracle Database Get SQL statement text
        call: ords-performance.getsqlstatementtext
        with:
          sql_id: rest.sql_id
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/performance/top-sql-statements
      name: database-performance-top-sql-statements
      description: REST surface for database-performance-top_sql_statements.
      operations:
      - method: GET
        name: gettopsqlstatements
        description: Oracle Database Get top SQL by CPU usage
        call: ords-performance.gettopsqlstatements
        outputParameters:
        - type: object
          mapping: $.
  - type: mcp
    namespace: ords-performance-mcp
    port: 9090
    transport: http
    description: MCP adapter for Oracle Database Oracle REST Data Services (ORDS) API — Performance. One tool per consumed
      operation, routed inline through this capability's consumes block.
    tools:
    - name: oracle-database-get-active-sessions
      description: Oracle Database Get active sessions history
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: ords-performance.getactivesessionshistory
      outputParameters:
      - type: object
        mapping: $.
    - name: oracle-database-get-active-session
      description: Oracle Database Get active session history waits
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: ords-performance.getactivesessionshistorywaits
      outputParameters:
      - type: object
        mapping: $.
    - name: oracle-database-get-all-sql
      description: Oracle Database Get all SQL statements
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: ords-performance.getsqlstatements
      outputParameters:
      - type: object
        mapping: $.
    - name: oracle-database-get-sql-statement
      description: Oracle Database Get SQL statement statistics
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: ords-performance.getsqlstatementstats
      with:
        sql_id: tools.sql_id
      outputParameters:
      - type: object
        mapping: $.
    - name: oracle-database-get-sql-statement-2
      description: Oracle Database Get SQL statement history
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: ords-performance.getsqlhistory
      with:
        sql_id: tools.sql_id
      outputParameters:
      - type: object
        mapping: $.
    - name: oracle-database-get-sql-execution
      description: Oracle Database Get SQL execution plan
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: ords-performance.getsqlexecutionplan
      with:
        sql_id: tools.sql_id
      outputParameters:
      - type: object
        mapping: $.
    - name: oracle-database-get-sql-statement-3
      description: Oracle Database Get SQL statement text
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: ords-performance.getsqlstatementtext
      with:
        sql_id: tools.sql_id
      outputParameters:
      - type: object
        mapping: $.
    - name: oracle-database-get-top-sql
      description: Oracle Database Get top SQL by CPU usage
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: ords-performance.gettopsqlstatements
      outputParameters:
      - type: object
        mapping: $.