Apache Ignite · Capability

Apache Ignite REST module — sql

Apache Ignite REST module — sql. 4 operations. Lead operation: Apache Ignite Invalidates SQL Planner Cache.. Self-contained Naftiko capability covering one Apache Ignite business surface.

Run with Naftiko Apache Ignitesql

What You Can Do

GET
Clearcache — Apache Ignite Invalidates SQL Planner Cache.
/v1/management/v1/sql/plan/clear-cache
GET
Queries — Apache Ignite Retrieve All Running Sql Queries.
/v1/management/v1/sql/queries
GET
Query — Apache Ignite Retrieve Sql Query.
/v1/management/v1/sql/queries/{queryid}
DELETE
Killquery — Apache Ignite Kill Sql Query.
/v1/management/v1/sql/queries/{queryid}

MCP Tools

apache-ignite-invalidates-sql-planner

Apache Ignite Invalidates SQL Planner Cache.

read-only idempotent
apache-ignite-retrieve-all-running

Apache Ignite Retrieve All Running Sql Queries.

read-only idempotent
apache-ignite-retrieve-sql-query

Apache Ignite Retrieve Sql Query.

read-only idempotent
apache-ignite-kill-sql-query

Apache Ignite Kill Sql Query.

idempotent

Capability Spec

rest-sql.yaml Raw ↑
naftiko: 1.0.0-alpha2
info:
  label: Apache Ignite REST module — sql
  description: 'Apache Ignite REST module — sql. 4 operations. Lead operation: Apache Ignite Invalidates SQL Planner Cache..
    Self-contained Naftiko capability covering one Apache Ignite business surface.'
  tags:
  - Apache Ignite
  - sql
  created: '2026-05-19'
  modified: '2026-05-19'
binds:
- namespace: env
  keys:
    APACHE_IGNITE_API_KEY: APACHE_IGNITE_API_KEY
capability:
  consumes:
  - type: http
    namespace: rest-sql
    baseUri: http://localhost:10300
    description: Apache Ignite REST module — sql business capability. Self-contained, no shared references.
    resources:
    - name: management-v1-sql-plan-clear-cache
      path: /management/v1/sql/plan/clear-cache
      operations:
      - name: clearcache
        method: GET
        description: Apache Ignite Invalidates SQL Planner Cache.
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: tableNames
          in: query
          type: array
    - name: management-v1-sql-queries
      path: /management/v1/sql/queries
      operations:
      - name: queries
        method: GET
        description: Apache Ignite Retrieve All Running Sql Queries.
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: management-v1-sql-queries-queryId
      path: /management/v1/sql/queries/{queryId}
      operations:
      - name: query
        method: GET
        description: Apache Ignite Retrieve Sql Query.
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: queryId
          in: path
          type: string
          description: The unique identifier of the sql query.
          required: true
      - name: killquery
        method: DELETE
        description: Apache Ignite Kill Sql Query.
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: queryId
          in: path
          type: string
          description: The unique identifier of the sql query.
          required: true
    authentication:
      type: basic
      username: '{{env.APACHE_IGNITE_USER}}'
      password: '{{env.APACHE_IGNITE_PASS}}'
  exposes:
  - type: rest
    namespace: rest-sql-rest
    port: 8080
    description: REST adapter for Apache Ignite REST module — sql. One Spectral-compliant resource per consumed operation,
      prefixed with /v1.
    resources:
    - path: /v1/management/v1/sql/plan/clear-cache
      name: management-v1-sql-plan-clear-cache
      description: REST surface for management-v1-sql-plan-clear-cache.
      operations:
      - method: GET
        name: clearcache
        description: Apache Ignite Invalidates SQL Planner Cache.
        call: rest-sql.clearcache
        with:
          tableNames: rest.tableNames
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/management/v1/sql/queries
      name: management-v1-sql-queries
      description: REST surface for management-v1-sql-queries.
      operations:
      - method: GET
        name: queries
        description: Apache Ignite Retrieve All Running Sql Queries.
        call: rest-sql.queries
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/management/v1/sql/queries/{queryid}
      name: management-v1-sql-queries-queryid
      description: REST surface for management-v1-sql-queries-queryId.
      operations:
      - method: GET
        name: query
        description: Apache Ignite Retrieve Sql Query.
        call: rest-sql.query
        with:
          queryId: rest.queryId
        outputParameters:
        - type: object
          mapping: $.
      - method: DELETE
        name: killquery
        description: Apache Ignite Kill Sql Query.
        call: rest-sql.killquery
        with:
          queryId: rest.queryId
        outputParameters:
        - type: object
          mapping: $.
  - type: mcp
    namespace: rest-sql-mcp
    port: 9090
    transport: http
    description: MCP adapter for Apache Ignite REST module — sql. One tool per consumed operation, routed inline through this
      capability's consumes block.
    tools:
    - name: apache-ignite-invalidates-sql-planner
      description: Apache Ignite Invalidates SQL Planner Cache.
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: rest-sql.clearcache
      with:
        tableNames: tools.tableNames
      outputParameters:
      - type: object
        mapping: $.
    - name: apache-ignite-retrieve-all-running
      description: Apache Ignite Retrieve All Running Sql Queries.
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: rest-sql.queries
      outputParameters:
      - type: object
        mapping: $.
    - name: apache-ignite-retrieve-sql-query
      description: Apache Ignite Retrieve Sql Query.
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: rest-sql.query
      with:
        queryId: tools.queryId
      outputParameters:
      - type: object
        mapping: $.
    - name: apache-ignite-kill-sql-query
      description: Apache Ignite Kill Sql Query.
      hints:
        readOnly: false
        destructive: true
        idempotent: true
      call: rest-sql.killquery
      with:
        queryId: tools.queryId
      outputParameters:
      - type: object
        mapping: $.