> **Building with AI coding agents?** Install the authstack plugin with one command. This equips your agent with accurate Scalekit implementation patterns. > > **Recommended**: > ```bash > npx @scalekit-inc/cli setup > ``` > > Global: > ```bash > npm install -g @scalekit-inc/cli > scalekit setup > ``` > > Supports Claude Code, Cursor, GitHub Copilot, Codex + skills for 40+ agents. > Features: full-stack-auth, agent-auth, mcp-auth, modular-sso, modular-scim. > [Full setup guide](https://docs.scalekit.com/dev-kit/build-with-ai/) --- # AWS Redshift connector Amazon Redshift is a fully managed cloud data warehouse that enables fast, cost-effective analysis of structured and semi-structured data at scale. **Authentication:** Trusted IDP **Categories:** Analytics, Databases 1. ### Install the SDK ### Node.js ```bash frame="terminal" npm install @scalekit-sdk/node ``` ### Python ```bash frame="terminal" pip install scalekit ``` Full SDK reference: [Node.js](/agentkit/sdks/node/) | [Python](/agentkit/sdks/python/) 2. ### Set your credentials Add your Scalekit credentials to your `.env` file. Find values in **[app.scalekit.com](https://app.scalekit.com)** > **Developers** > **API Credentials**. ```sh showLineNumbers=false title=".env" SCALEKIT_ENVIRONMENT_URL= SCALEKIT_CLIENT_ID= SCALEKIT_CLIENT_SECRET= ``` ## What you can do Connect this agent connector to let your agent: - **List tables, statements, schemas** — List tables in an Amazon Redshift database using the Redshift Data API - **Get query result** — Retrieve the results of a previously executed Redshift SQL statement using the statement ID returned by redshift_execute_sql - **Execute sql** — Execute a SQL statement against Amazon Redshift using the Redshift Data API - **Table describe** — Describe the schema of a table in Amazon Redshift using the Redshift Data API, including column names, types, and metadata - **Query cancel** — Cancel a running Amazon Redshift SQL statement using its statement ID ## Tool list Use the exact tool names from the **Tool list** below when you call `execute_tool`. If you're not sure which name to use, list the tools available for the current user first. ## Tool list ### `redshift_cancel_query` Cancel a running Amazon Redshift SQL statement using its statement ID. Parameters: - `statement_id` (`string`, required): The ID of the statement to cancel. Must be non-empty. ### `redshift_describe_table` Describe the schema of a table in Amazon Redshift using the Redshift Data API, including column names, types, and metadata. Parameters: - `table` (`string`, required): Name of the table to describe. Must be non-empty. - `connected_database` (`string`, optional): Override the connected account's default database for this request. - `max_results` (`integer`, optional): Maximum number of columns to return per page. - `next_token` (`string`, optional): Pagination cursor from a previous redshift_describe_table response. - `schema` (`string`, optional): Schema name that contains the table. ### `redshift_execute_sql` Execute a SQL statement against Amazon Redshift using the Redshift Data API. Returns a statement ID that can be used with redshift_get_query_result to fetch results. Parameters: - `sql` (`string`, required): SQL statement to execute. Must be non-empty. - `statement_name` (`string`, optional): Optional label for the statement, echoed back by DescribeStatement for tracking purposes. - `with_event` (`boolean`, optional): If true, AWS publishes an EventBridge event when the statement completes. ### `redshift_get_query_result` Retrieve the results of a previously executed Redshift SQL statement using the statement ID returned by redshift_execute_sql. Supports pagination via next_token. Parameters: - `statement_id` (`string`, required): The statement ID returned by redshift_execute_sql. Must be non-empty. - `next_token` (`string`, optional): Pagination token from a prior redshift_get_query_result response when results spanned multiple pages. ### `redshift_list_schemas` List schemas in an Amazon Redshift database using the Redshift Data API. Supports filtering by schema name pattern with pagination. Parameters: - `connected_database` (`string`, optional): Override the connected account's default database for this request. - `max_results` (`integer`, optional): Maximum number of schemas to return. - `next_token` (`string`, optional): Pagination cursor from a previous redshift_list_schemas response. - `schema_pattern` (`string`, optional): LIKE pattern to filter schemas (e.g., public, my_schema%). ### `redshift_list_statements` List previously executed SQL statements in Amazon Redshift using the Redshift Data API. Supports filtering by name, status, and role level with pagination. Parameters: - `max_results` (`integer`, optional): Maximum number of statements to return. - `next_token` (`string`, optional): Pagination cursor from a previous redshift_list_statements response. - `role_level` (`boolean`, optional): When true, lists all statements run by the IAM role rather than just the current session. - `statement_name` (`string`, optional): Filter statements by name label. - `status` (`string`, optional): Filter by execution status (e.g., FINISHED, FAILED, ABORTED, PICKED, STARTED, SUBMITTED). ### `redshift_list_tables` List tables in an Amazon Redshift database using the Redshift Data API. Supports filtering by schema and table name patterns with pagination. Parameters: - `connected_database` (`string`, optional): Override the connected account's default database for this request. - `max_results` (`integer`, optional): Maximum number of tables to return. - `next_token` (`string`, optional): Pagination cursor from a previous redshift_list_tables response. - `schema_pattern` (`string`, optional): LIKE pattern to filter schemas (e.g., public, my_schema%). - `table_pattern` (`string`, optional): LIKE pattern to filter tables (e.g., orders, user%). --- ## More Scalekit documentation | Resource | What it contains | When to use it | |----------|-----------------|----------------| | [/llms.txt](/llms.txt) | Structured index with routing hints per product area | Start here — find which documentation set covers your topic before loading full content | | [/llms-full.txt](/llms-full.txt) | Complete documentation for all Scalekit products in one file | Use when you need exhaustive context across multiple products or when the topic spans several areas | | [sitemap-0.xml](https://docs.scalekit.com/sitemap-0.xml) | Full URL list of every documentation page | Use to discover specific page URLs you can fetch for targeted, page-level answers |