AWS Redshift · Capability

Redshift Data API Service

Redshift Data API Service. 10 operations. Lead operation: Amazon Redshift Data - Batch Execute Statement. Self-contained Naftiko capability covering one Aws Redshift business surface.

Run with Naftiko Aws RedshiftRedshift Data API Service

What You Can Do

POST
Batchexecutestatement — Amazon Redshift Data - Batch Execute Statement
/v1/x-amz-target-redshiftdata-batchexecutestatement
POST
Cancelstatement — Amazon Redshift Data - Cancel Statement
/v1/x-amz-target-redshiftdata-cancelstatement
POST
Describestatement — Amazon Redshift Data - Describe Statement
/v1/x-amz-target-redshiftdata-describestatement
POST
Describetable — Amazon Redshift Data - Describe Table
/v1/x-amz-target-redshiftdata-describetable
POST
Executestatement — Amazon Redshift Data - Execute Statement
/v1/x-amz-target-redshiftdata-executestatement
POST
Getstatementresult — Amazon Redshift Data - Get Statement Result
/v1/x-amz-target-redshiftdata-getstatementresult
POST
Listdatabases — Amazon Redshift Data - List Databases
/v1/x-amz-target-redshiftdata-listdatabases
POST
Listschemas — Amazon Redshift Data - List Schemas
/v1/x-amz-target-redshiftdata-listschemas
POST
Liststatements — Amazon Redshift Data - List Statements
/v1/x-amz-target-redshiftdata-liststatements
POST
Listtables — Amazon Redshift Data - List Tables
/v1/x-amz-target-redshiftdata-listtables

MCP Tools

amazon-redshift-data-batch-execute

Amazon Redshift Data - Batch Execute Statement

amazon-redshift-data-cancel-statement

Amazon Redshift Data - Cancel Statement

amazon-redshift-data-describe-statement

Amazon Redshift Data - Describe Statement

amazon-redshift-data-describe-table

Amazon Redshift Data - Describe Table

amazon-redshift-data-execute-statement

Amazon Redshift Data - Execute Statement

amazon-redshift-data-get-statement

Amazon Redshift Data - Get Statement Result

read-only
amazon-redshift-data-list-databases

Amazon Redshift Data - List Databases

read-only
amazon-redshift-data-list-schemas

Amazon Redshift Data - List Schemas

read-only
amazon-redshift-data-list-statements

Amazon Redshift Data - List Statements

read-only
amazon-redshift-data-list-tables

Amazon Redshift Data - List Tables

read-only

Capability Spec

data.yaml Raw ↑
naftiko: 1.0.0-alpha2
info:
  label: Redshift Data API Service
  description: 'Redshift Data API Service. 10 operations. Lead operation: Amazon Redshift Data - Batch Execute Statement.
    Self-contained Naftiko capability covering one Aws Redshift business surface.'
  tags:
  - Aws Redshift
  - Redshift Data API Service
  created: '2026-05-19'
  modified: '2026-05-19'
binds:
- namespace: env
  keys:
    AWS_REDSHIFT_API_KEY: AWS_REDSHIFT_API_KEY
capability:
  consumes:
  - type: http
    namespace: data
    baseUri: http://redshift-data.{region}.amazonaws.com
    description: Redshift Data API Service business capability. Self-contained, no shared references.
    resources:
    - name: '#X-Amz-Target=RedshiftData.BatchExecuteStatement'
      path: /#X-Amz-Target=RedshiftData.BatchExecuteStatement
      operations:
      - name: batchexecutestatement
        method: POST
        description: Amazon Redshift Data - Batch Execute Statement
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: X-Amz-Target
          in: header
          type: string
          required: true
        - name: body
          in: body
          type: object
          description: Request body (JSON).
          required: true
    - name: '#X-Amz-Target=RedshiftData.CancelStatement'
      path: /#X-Amz-Target=RedshiftData.CancelStatement
      operations:
      - name: cancelstatement
        method: POST
        description: Amazon Redshift Data - Cancel Statement
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: X-Amz-Target
          in: header
          type: string
          required: true
        - name: body
          in: body
          type: object
          description: Request body (JSON).
          required: true
    - name: '#X-Amz-Target=RedshiftData.DescribeStatement'
      path: /#X-Amz-Target=RedshiftData.DescribeStatement
      operations:
      - name: describestatement
        method: POST
        description: Amazon Redshift Data - Describe Statement
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: X-Amz-Target
          in: header
          type: string
          required: true
        - name: body
          in: body
          type: object
          description: Request body (JSON).
          required: true
    - name: '#X-Amz-Target=RedshiftData.DescribeTable'
      path: /#X-Amz-Target=RedshiftData.DescribeTable
      operations:
      - name: describetable
        method: POST
        description: Amazon Redshift Data - Describe Table
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: MaxResults
          in: query
          type: string
          description: Pagination limit
        - name: NextToken
          in: query
          type: string
          description: Pagination token
        - name: X-Amz-Target
          in: header
          type: string
          required: true
        - name: body
          in: body
          type: object
          description: Request body (JSON).
          required: true
    - name: '#X-Amz-Target=RedshiftData.ExecuteStatement'
      path: /#X-Amz-Target=RedshiftData.ExecuteStatement
      operations:
      - name: executestatement
        method: POST
        description: Amazon Redshift Data - Execute Statement
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: X-Amz-Target
          in: header
          type: string
          required: true
        - name: body
          in: body
          type: object
          description: Request body (JSON).
          required: true
    - name: '#X-Amz-Target=RedshiftData.GetStatementResult'
      path: /#X-Amz-Target=RedshiftData.GetStatementResult
      operations:
      - name: getstatementresult
        method: POST
        description: Amazon Redshift Data - Get Statement Result
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: NextToken
          in: query
          type: string
          description: Pagination token
        - name: X-Amz-Target
          in: header
          type: string
          required: true
        - name: body
          in: body
          type: object
          description: Request body (JSON).
          required: true
    - name: '#X-Amz-Target=RedshiftData.ListDatabases'
      path: /#X-Amz-Target=RedshiftData.ListDatabases
      operations:
      - name: listdatabases
        method: POST
        description: Amazon Redshift Data - List Databases
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: MaxResults
          in: query
          type: string
          description: Pagination limit
        - name: NextToken
          in: query
          type: string
          description: Pagination token
        - name: X-Amz-Target
          in: header
          type: string
          required: true
        - name: body
          in: body
          type: object
          description: Request body (JSON).
          required: true
    - name: '#X-Amz-Target=RedshiftData.ListSchemas'
      path: /#X-Amz-Target=RedshiftData.ListSchemas
      operations:
      - name: listschemas
        method: POST
        description: Amazon Redshift Data - List Schemas
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: MaxResults
          in: query
          type: string
          description: Pagination limit
        - name: NextToken
          in: query
          type: string
          description: Pagination token
        - name: X-Amz-Target
          in: header
          type: string
          required: true
        - name: body
          in: body
          type: object
          description: Request body (JSON).
          required: true
    - name: '#X-Amz-Target=RedshiftData.ListStatements'
      path: /#X-Amz-Target=RedshiftData.ListStatements
      operations:
      - name: liststatements
        method: POST
        description: Amazon Redshift Data - List Statements
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: MaxResults
          in: query
          type: string
          description: Pagination limit
        - name: NextToken
          in: query
          type: string
          description: Pagination token
        - name: X-Amz-Target
          in: header
          type: string
          required: true
        - name: body
          in: body
          type: object
          description: Request body (JSON).
          required: true
    - name: '#X-Amz-Target=RedshiftData.ListTables'
      path: /#X-Amz-Target=RedshiftData.ListTables
      operations:
      - name: listtables
        method: POST
        description: Amazon Redshift Data - List Tables
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: MaxResults
          in: query
          type: string
          description: Pagination limit
        - name: NextToken
          in: query
          type: string
          description: Pagination token
        - name: X-Amz-Target
          in: header
          type: string
          required: true
        - name: body
          in: body
          type: object
          description: Request body (JSON).
          required: true
    authentication:
      type: apikey
      key: Authorization
      value: '{{env.AWS_REDSHIFT_API_KEY}}'
      placement: header
  exposes:
  - type: rest
    namespace: data-rest
    port: 8080
    description: REST adapter for Redshift Data API Service. One Spectral-compliant resource per consumed operation, prefixed
      with /v1.
    resources:
    - path: /v1/x-amz-target-redshiftdata-batchexecutestatement
      name: x-amz-target-redshiftdata-batchexecutestatement
      description: 'REST surface for #X-Amz-Target=RedshiftData.BatchExecuteStatement.'
      operations:
      - method: POST
        name: batchexecutestatement
        description: Amazon Redshift Data - Batch Execute Statement
        call: data.batchexecutestatement
        with:
          X-Amz-Target: rest.X-Amz-Target
          body: rest.body
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/x-amz-target-redshiftdata-cancelstatement
      name: x-amz-target-redshiftdata-cancelstatement
      description: 'REST surface for #X-Amz-Target=RedshiftData.CancelStatement.'
      operations:
      - method: POST
        name: cancelstatement
        description: Amazon Redshift Data - Cancel Statement
        call: data.cancelstatement
        with:
          X-Amz-Target: rest.X-Amz-Target
          body: rest.body
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/x-amz-target-redshiftdata-describestatement
      name: x-amz-target-redshiftdata-describestatement
      description: 'REST surface for #X-Amz-Target=RedshiftData.DescribeStatement.'
      operations:
      - method: POST
        name: describestatement
        description: Amazon Redshift Data - Describe Statement
        call: data.describestatement
        with:
          X-Amz-Target: rest.X-Amz-Target
          body: rest.body
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/x-amz-target-redshiftdata-describetable
      name: x-amz-target-redshiftdata-describetable
      description: 'REST surface for #X-Amz-Target=RedshiftData.DescribeTable.'
      operations:
      - method: POST
        name: describetable
        description: Amazon Redshift Data - Describe Table
        call: data.describetable
        with:
          MaxResults: rest.MaxResults
          NextToken: rest.NextToken
          X-Amz-Target: rest.X-Amz-Target
          body: rest.body
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/x-amz-target-redshiftdata-executestatement
      name: x-amz-target-redshiftdata-executestatement
      description: 'REST surface for #X-Amz-Target=RedshiftData.ExecuteStatement.'
      operations:
      - method: POST
        name: executestatement
        description: Amazon Redshift Data - Execute Statement
        call: data.executestatement
        with:
          X-Amz-Target: rest.X-Amz-Target
          body: rest.body
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/x-amz-target-redshiftdata-getstatementresult
      name: x-amz-target-redshiftdata-getstatementresult
      description: 'REST surface for #X-Amz-Target=RedshiftData.GetStatementResult.'
      operations:
      - method: POST
        name: getstatementresult
        description: Amazon Redshift Data - Get Statement Result
        call: data.getstatementresult
        with:
          NextToken: rest.NextToken
          X-Amz-Target: rest.X-Amz-Target
          body: rest.body
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/x-amz-target-redshiftdata-listdatabases
      name: x-amz-target-redshiftdata-listdatabases
      description: 'REST surface for #X-Amz-Target=RedshiftData.ListDatabases.'
      operations:
      - method: POST
        name: listdatabases
        description: Amazon Redshift Data - List Databases
        call: data.listdatabases
        with:
          MaxResults: rest.MaxResults
          NextToken: rest.NextToken
          X-Amz-Target: rest.X-Amz-Target
          body: rest.body
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/x-amz-target-redshiftdata-listschemas
      name: x-amz-target-redshiftdata-listschemas
      description: 'REST surface for #X-Amz-Target=RedshiftData.ListSchemas.'
      operations:
      - method: POST
        name: listschemas
        description: Amazon Redshift Data - List Schemas
        call: data.listschemas
        with:
          MaxResults: rest.MaxResults
          NextToken: rest.NextToken
          X-Amz-Target: rest.X-Amz-Target
          body: rest.body
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/x-amz-target-redshiftdata-liststatements
      name: x-amz-target-redshiftdata-liststatements
      description: 'REST surface for #X-Amz-Target=RedshiftData.ListStatements.'
      operations:
      - method: POST
        name: liststatements
        description: Amazon Redshift Data - List Statements
        call: data.liststatements
        with:
          MaxResults: rest.MaxResults
          NextToken: rest.NextToken
          X-Amz-Target: rest.X-Amz-Target
          body: rest.body
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/x-amz-target-redshiftdata-listtables
      name: x-amz-target-redshiftdata-listtables
      description: 'REST surface for #X-Amz-Target=RedshiftData.ListTables.'
      operations:
      - method: POST
        name: listtables
        description: Amazon Redshift Data - List Tables
        call: data.listtables
        with:
          MaxResults: rest.MaxResults
          NextToken: rest.NextToken
          X-Amz-Target: rest.X-Amz-Target
          body: rest.body
        outputParameters:
        - type: object
          mapping: $.
  - type: mcp
    namespace: data-mcp
    port: 9090
    transport: http
    description: MCP adapter for Redshift Data API Service. One tool per consumed operation, routed inline through this capability's
      consumes block.
    tools:
    - name: amazon-redshift-data-batch-execute
      description: Amazon Redshift Data - Batch Execute Statement
      hints:
        readOnly: false
        destructive: false
        idempotent: false
      call: data.batchexecutestatement
      with:
        X-Amz-Target: tools.X-Amz-Target
        body: tools.body
      outputParameters:
      - type: object
        mapping: $.
    - name: amazon-redshift-data-cancel-statement
      description: Amazon Redshift Data - Cancel Statement
      hints:
        readOnly: false
        destructive: false
        idempotent: false
      call: data.cancelstatement
      with:
        X-Amz-Target: tools.X-Amz-Target
        body: tools.body
      outputParameters:
      - type: object
        mapping: $.
    - name: amazon-redshift-data-describe-statement
      description: Amazon Redshift Data - Describe Statement
      hints:
        readOnly: false
        destructive: false
        idempotent: false
      call: data.describestatement
      with:
        X-Amz-Target: tools.X-Amz-Target
        body: tools.body
      outputParameters:
      - type: object
        mapping: $.
    - name: amazon-redshift-data-describe-table
      description: Amazon Redshift Data - Describe Table
      hints:
        readOnly: false
        destructive: false
        idempotent: false
      call: data.describetable
      with:
        MaxResults: tools.MaxResults
        NextToken: tools.NextToken
        X-Amz-Target: tools.X-Amz-Target
        body: tools.body
      outputParameters:
      - type: object
        mapping: $.
    - name: amazon-redshift-data-execute-statement
      description: Amazon Redshift Data - Execute Statement
      hints:
        readOnly: false
        destructive: false
        idempotent: false
      call: data.executestatement
      with:
        X-Amz-Target: tools.X-Amz-Target
        body: tools.body
      outputParameters:
      - type: object
        mapping: $.
    - name: amazon-redshift-data-get-statement
      description: Amazon Redshift Data - Get Statement Result
      hints:
        readOnly: true
        destructive: false
        idempotent: false
      call: data.getstatementresult
      with:
        NextToken: tools.NextToken
        X-Amz-Target: tools.X-Amz-Target
        body: tools.body
      outputParameters:
      - type: object
        mapping: $.
    - name: amazon-redshift-data-list-databases
      description: Amazon Redshift Data - List Databases
      hints:
        readOnly: true
        destructive: false
        idempotent: false
      call: data.listdatabases
      with:
        MaxResults: tools.MaxResults
        NextToken: tools.NextToken
        X-Amz-Target: tools.X-Amz-Target
        body: tools.body
      outputParameters:
      - type: object
        mapping: $.
    - name: amazon-redshift-data-list-schemas
      description: Amazon Redshift Data - List Schemas
      hints:
        readOnly: true
        destructive: false
        idempotent: false
      call: data.listschemas
      with:
        MaxResults: tools.MaxResults
        NextToken: tools.NextToken
        X-Amz-Target: tools.X-Amz-Target
        body: tools.body
      outputParameters:
      - type: object
        mapping: $.
    - name: amazon-redshift-data-list-statements
      description: Amazon Redshift Data - List Statements
      hints:
        readOnly: true
        destructive: false
        idempotent: false
      call: data.liststatements
      with:
        MaxResults: tools.MaxResults
        NextToken: tools.NextToken
        X-Amz-Target: tools.X-Amz-Target
        body: tools.body
      outputParameters:
      - type: object
        mapping: $.
    - name: amazon-redshift-data-list-tables
      description: Amazon Redshift Data - List Tables
      hints:
        readOnly: true
        destructive: false
        idempotent: false
      call: data.listtables
      with:
        MaxResults: tools.MaxResults
        NextToken: tools.NextToken
        X-Amz-Target: tools.X-Amz-Target
        body: tools.body
      outputParameters:
      - type: object
        mapping: $.