> ## Documentation Index
> Fetch the complete documentation index at: https://docs.blinkops.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Redshift Data List Databases

List the names of the databases visible from a Redshift cluster or Serverless workgroup.

**Note**: `Database` is the database the Data API connects through in order to run the listing - it is required, and it is not a filter. Every cluster and workgroup is created with a `dev` database, which is the usual value to use here.

Results are paginated. When the response contains a `NextToken`, run the action again with that value in `Next Token` to fetch the next page.

<Note>
  External Documentation

  To learn more, visit the [AWS documentation](https://docs.aws.amazon.com/redshift-data/latest/APIReference/API_ListDatabases.html).
</Note>

## Basic Parameters

<div className="integrations-table">
  | Parameter          | Description                                                                                                                                                                                                                                                                    |
  | ------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
  | AWS Region         | The AWS Region of the Redshift cluster or Serverless workgroup.                                                                                                                                                                                                                |
  | Cluster Identifier | The identifier of the provisioned Redshift cluster to connect to.<br /><br />Required when connecting to a cluster. Leave empty when connecting to a Redshift Serverless workgroup.                                                                                            |
  | Database           | The name of the database to connect through in order to run the listing.<br /><br />This is not a filter - the response lists every database visible from this connection.                                                                                                     |
  | Database User      | The database user name to connect as.<br /><br />Only relevant when connecting to a provisioned cluster as a database user using temporary credentials.                                                                                                                        |
  | Max Results        | The maximum number of databases to return in a single response.<br /><br />Valid values range from `0` to `1000`.                                                                                                                                                              |
  | Next Token         | The pagination token for fetching the next page of records, taken from the `NextToken` field of a previous response.<br /><br />Leave empty to fetch the first page.                                                                                                           |
  | Secret ARN         | The name or ARN of the AWS Secrets Manager secret holding the `username` and `password` of the database user.<br /><br />Required when authenticating with Secrets Manager. Leave empty to authenticate with temporary credentials derived from the connection's IAM identity. |
  | Workgroup Name     | The Redshift Serverless workgroup name or ARN to connect to.<br /><br />Required when connecting to a serverless workgroup. Leave empty when connecting to a provisioned cluster.                                                                                              |
</div>

## Advanced Parameters

<div className="integrations-table">
  | Parameter                        | Description                                                                   |
  | -------------------------------- | ----------------------------------------------------------------------------- |
  | Disable XML To JSON Auto Convert | When checked, XML responses are not automatically converted into JSON format. |
</div>

## Example Output

```json theme={"dark"}
{
	"Databases": [
		"dev",
		"analytics"
	],
	"NextToken": ""
}
```

## Workflow Library Example

[Redshift Data List Databases with Aws and Send Results Via Email](https://library.blinkops.com/workflows/redshift-data-list-databases-with-aws-and-send-results-via-email)

<div className="iframe-wrapper">
  <div className="iframe-media">
    <img src="https://mintcdn.com/blinkops-2/ojHYuDeYX5FWuN8a/img/Icons/play-box.svg?fit=max&auto=format&n=ojHYuDeYX5FWuN8a&q=85&s=b8af968e71438a9499c3223c9bd29fb2" alt="Workflow Library" width="16" height="16" data-path="img/Icons/play-box.svg" />

    Preview this Workflow on desktop
  </div>

  <iframe className="iframe" src="https://library.blinkops.com/workflows/redshift-data-list-databases-with-aws-and-send-results-via-email/canvas" />
</div>
