Skip to content
Scalekit Docs
Talk to an Engineer Dashboard

Connect AI agents to AWS Redshift

Scalekit connector
Open markdown

The AWS Redshift connector lets your AI agent work with AWS Redshift. Scalekit handles authentication for every call, so your agent never handles credentials. It comes with 10 tools.

Tools
10
What they doRead · write · destructive
7 · 2 · 17 read2 write1 destructive
Users sign in with

Setup

  1. Install the SDK

    Terminal window
    npm install @scalekit-sdk/node dotenv

  2. Set your credentials

    Add your Scalekit credentials to your .env file. Find values in app.scalekit.com > Developers > API Credentials.

    .env
    SCALEKIT_ENVIRONMENT_URL=<your-environment-url>
    SCALEKIT_CLIENT_ID=<your-client-id>
    SCALEKIT_CLIENT_SECRET=<your-client-secret>

  3. Create the AWS Redshift connection

    In AgentKit > Connections, create an AWS Redshift connection. The name you give it is the connection_name your code passes. See Configure connections.

Tools

Pass the exact name to execute_tool
Try in PlaygroundRequest a tool
  • redshift_describe_statementGet the status, duration, and row count of a previously submitted statement without fetching result rows.Read-only

    Describe Statement

    Get the status, duration, and row count of a previously submitted statement without fetching result rows. This is the only way to poll or confirm success/failure of DDL/DML statements (CREATE/INSERT/UPDATE) that cannot be passed to redshift_get_query_result, which requires a statement that returns a result set. redshift_list_statements lists many statements at once but doesn't substitute for checking one specific statement's full status detail (e.g. its error message on failure).

    Inputs

    statement_idstringrequired
    The ID of the statement to describe. Must be non-empty.
  • redshift_describe_tableDescribe the schema of a table in Amazon Redshift using the Redshift Data API, including column names, types, and metadata.Read-only

    Describe Table

    Describe the schema of a table in Amazon Redshift using the Redshift Data API, including column names, types, and metadata.

    Inputs

    tablestringrequired
    Name of the table to describe. Must be non-empty.
    connected_databasestring
    Override the connected account's default database for this request.
    max_resultsinteger
    Maximum number of columns to return per page.
    next_tokenstring
    Pagination cursor from a previous redshift_describe_table response.
    schemastring
    Schema name that contains the table.
  • redshift_get_query_resultRetrieve the results of a previously executed Redshift SQL statement using the statement ID returned by redshift_execute_sql.Read-only

    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.

    Inputs

    statement_idstringrequired
    The statement ID returned by redshift_execute_sql. Must be non-empty.
    next_tokenstring
    Pagination token from a prior redshift_get_query_result response when results spanned multiple pages.
  • redshift_list_databasesList the databases available in the connected Amazon Redshift cluster or serverless workgroup, using the Redshift Data API.Read-only

    List Databases

    List the databases available in the connected Amazon Redshift cluster or serverless workgroup, using the Redshift Data API. Mirrors redshift_list_schemas / redshift_list_tables one level up the hierarchy.

    Inputs

    connected_databasestring
    Override the connected account's default database for this request.
    max_resultsinteger
    Maximum number of databases to return.
    next_tokenstring
    Pagination cursor from a previous redshift_list_databases response.
  • redshift_list_schemasList schemas in an Amazon Redshift database using the Redshift Data API.Read-only

    List Schemas

    List schemas in an Amazon Redshift database using the Redshift Data API. Supports filtering by schema name pattern with pagination.

    Inputs

    connected_databasestring
    Override the connected account's default database for this request.
    max_resultsinteger
    Maximum number of schemas to return.
    next_tokenstring
    Pagination cursor from a previous redshift_list_schemas response.
    schema_patternstring
    LIKE pattern to filter schemas (e.g., public, my_schema%).
  • redshift_list_statementsList previously executed SQL statements in Amazon Redshift using the Redshift Data API.Read-only

    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.

    Inputs

    max_resultsinteger
    Maximum number of statements to return.
    next_tokenstring
    Pagination cursor from a previous redshift_list_statements response.
    role_levelboolean
    When true, lists all statements run by the IAM role rather than just the current session.
    statement_namestring
    Filter statements by name label.
    statusstring
    Filter by execution status (e.g., FINISHED, FAILED, ABORTED, PICKED, STARTED, SUBMITTED).one of SUBMITTEDPICKEDSTARTEDFINISHEDABORTEDFAILEDALL
  • redshift_list_tablesList tables in an Amazon Redshift database using the Redshift Data API.Read-only

    List Tables

    List tables in an Amazon Redshift database using the Redshift Data API. Supports filtering by schema and table name patterns with pagination.

    Inputs

    connected_databasestring
    Override the connected account's default database for this request.
    max_resultsinteger
    Maximum number of tables to return.
    next_tokenstring
    Pagination cursor from a previous redshift_list_tables response.
    schema_patternstring
    LIKE pattern to filter schemas (e.g., public, my_schema%).
    table_patternstring
    LIKE pattern to filter tables (e.g., orders, user%).
  • redshift_batch_execute_sqlRun multiple SQL statements serially in a single call against Amazon Redshift using the Redshift Data API's BatchExecuteStatement action, returning one batch statement ID.Write

    Batch Execute SQL

    Run multiple SQL statements serially in a single call against Amazon Redshift using the Redshift Data API's BatchExecuteStatement action, returning one batch statement ID. Distinct from redshift_execute_sql, which only accepts a single statement. If any statement in the batch fails, remaining statements are not run.

    Inputs

    sqlsarrayrequired
    The SQL statements to run, in order. Each must be non-empty.
    statement_namestring
    Optional label for the batch, echoed back by DescribeStatement for tracking purposes.
    with_eventboolean
    If true, AWS publishes an EventBridge event when the batch completes.default false
All 93 in Analytics