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.
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
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: $.