Amazon Redshift · Capability
Amazon Redshift Data Warehouse Analytics
Data warehouse analytics workflow combining Redshift Data API for SQL execution, statement management, and database metadata exploration. Used by data analysts and engineers for ad-hoc queries, ETL processing, and serverless data warehouse operations.
What You Can Do
POST
Execute statement
— Execute a SQL statement
/v1/statements
GET
List statements
— List SQL statements
/v1/statements
GET
List databases
— List databases
/v1/databases
GET
List tables
— List tables in a schema
/v1/tables
MCP Tools
execute-statement
Execute a SQL statement asynchronously against Redshift
batch-execute-statement
Execute multiple SQL statements in a batch transaction
describe-statement
Get details about a SQL statement execution
read-only
list-statements
List SQL statement executions
read-only
cancel-statement
Cancel a running SQL statement
get-statement-result
Retrieve results from a completed SQL statement
read-only
list-databases
List databases in a Redshift cluster or workgroup
read-only
list-schemas
List schemas in a database
read-only
list-tables
List tables in a schema
read-only
describe-table
Describe the columns of a table
read-only
APIs Used
redshift-data