Data Api Capability

naftiko: 1.0.0-alpha2
info:
  title: Data Api Capability
  description: A capability that exposes a data warehouse over a uniform Data API surface — query, schema, and lineage as REST + MCP.
  tags: [Naftiko, Data API, Snowflake]
  created: '2026-05-01'
  modified: '2026-05-04'
binds:
- namespace: snowflake-env
  keys: {SNOWFLAKE_ACCOUNT: SNOWFLAKE_ACCOUNT, SNOWFLAKE_TOKEN: SNOWFLAKE_TOKEN}
capability:
  consumes:
  - namespace: snowflake
    type: http
    baseUri: https://{{SNOWFLAKE_ACCOUNT}}.snowflakecomputing.com
    authentication: {type: bearer, token: '{{SNOWFLAKE_TOKEN}}'}
    resources:
    - {name: statements, path: /api/v2/statements, operations: [{name: run-sql, method: POST}]}
    - name: statement
      path: /api/v2/statements/{{statement_handle}}
      operations:
      - {name: get-statement, method: GET, inputParameters: [{name: statement_handle, in: path}]}
  exposes:
  - type: rest
    address: 0.0.0.0
    port: 8080
    namespace: data-api-capability-rest
    description: REST surface for the data API.
    resources:
    - {name: query, path: /query, operations: [{method: POST, name: run-sql, call: snowflake.run-sql}]}
  - type: mcp
    address: 0.0.0.0
    port: 3010
    namespace: data-api-capability-mcp
    description: MCP for data API.
    tools:
    - {name: run-sql, call: snowflake.run-sql}
    - name: get-statement
      hints: {readOnly: true}
      inputParameters: [{name: statement_handle, type: string, required: true}]
      call: snowflake.get-statement
  - type: skill
    address: 0.0.0.0
    port: 3011
    namespace: data-api-capability-skills
    description: Skill for data API.
    skills:
    - name: data-api-capability
      description: Data API over warehouse.
      location: file:///opt/naftiko/skills/data-api-capability
      allowed-tools: run-sql,get-statement
      tools:
      - {name: run-sql, from: {sourceNamespace: data-api-capability-mcp, action: run-sql}}
      - {name: get-statement, from: {sourceNamespace: data-api-capability-mcp, action: get-statement}}