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

# redshift

> Amazon Redshift integration server for data warehouse operations

**Server path:** `/redshift` | **Type:** Application | **PCID required:** Yes

## Tools

| Tool                                                        | Description                                                                                 |
| ----------------------------------------------------------- | ------------------------------------------------------------------------------------------- |
| [`redshift_create_table`](#redshift_create_table)           | Create a new table in Amazon Redshift                                                       |
| [`redshift_delete_data`](#redshift_delete_data)             | Delete data from an Amazon Redshift table                                                   |
| [`redshift_describe_table`](#redshift_describe_table)       | Get table structure and column information for an Amazon Redshift table                     |
| [`redshift_execute_query`](#redshift_execute_query)         | Execute a SQL query on Amazon Redshift                                                      |
| [`redshift_get_database_info`](#redshift_get_database_info) | Get Amazon Redshift connection metadata including host, port, database name, and SSL status |
| [`redshift_insert_data`](#redshift_insert_data)             | Insert data into an Amazon Redshift table                                                   |
| [`redshift_list_tables`](#redshift_list_tables)             | List all tables in the Amazon Redshift database                                             |
| [`redshift_select_data`](#redshift_select_data)             | Select data from an Amazon Redshift table                                                   |
| [`redshift_update_data`](#redshift_update_data)             | Update data in an Amazon Redshift table                                                     |

***

## redshift\_create\_table

Create a new table in Amazon Redshift

**Parameters:**

| Parameter   | Type      | Required | Default | Description                 |
| ----------- | --------- | -------- | ------- | --------------------------- |
| `tableName` | string    | Yes      | —       | Name of the table to create |
| `columns`   | object\[] | Yes      | —       | Table column definitions    |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "tableName": {
        "type": "string",
        "description": "Name of the table to create"
      },
      "columns": {
        "type": "array",
        "items": {
          "type": "object",
          "properties": {
            "name": {
              "type": "string",
              "description": "Column name"
            },
            "type": {
              "type": "string",
              "description": "Column data type (e.g., VARCHAR(255), INTEGER, TEXT)"
            },
            "nullable": {
              "type": "boolean",
              "default": true,
              "description": "Whether column can be NULL"
            },
            "primaryKey": {
              "type": "boolean",
              "default": false,
              "description": "Whether column is primary key"
            },
            "autoIncrement": {
              "type": "boolean",
              "default": false,
              "description": "Whether column auto-increments (uses IDENTITY(1,1) in Redshift)"
            }
          }
        },
        "description": "Table column definitions"
      }
    },
    "required": [
      "PCID",
      "tableName",
      "columns"
    ]
  }
  ```
</Expandable>

***

## redshift\_delete\_data

Delete data from an Amazon Redshift table

**Parameters:**

| Parameter     | Type      | Required | Default | Description                             |
| ------------- | --------- | -------- | ------- | --------------------------------------- |
| `table`       | string    | Yes      | —       | Table name                              |
| `where`       | string    | Yes      | —       | WHERE clause to identify rows to delete |
| `whereParams` | string\[] | No       | —       | Parameters for WHERE clause             |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "table": {
        "type": "string",
        "description": "Table name"
      },
      "where": {
        "type": "string",
        "description": "WHERE clause to identify rows to delete"
      },
      "whereParams": {
        "type": "array",
        "items": {
          "oneOf": [
            {
              "type": "string"
            },
            {
              "type": "number"
            },
            {
              "type": "boolean"
            },
            {
              "type": "null"
            }
          ]
        },
        "description": "Parameters for WHERE clause"
      }
    },
    "required": [
      "PCID",
      "table",
      "where"
    ]
  }
  ```
</Expandable>

***

## redshift\_describe\_table

Get table structure and column information for an Amazon Redshift table

**Parameters:**

| Parameter | Type   | Required | Default | Description            |
| --------- | ------ | -------- | ------- | ---------------------- |
| `table`   | string | Yes      | —       | Table name to describe |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "table": {
        "type": "string",
        "description": "Table name to describe"
      }
    },
    "required": [
      "PCID",
      "table"
    ]
  }
  ```
</Expandable>

***

## redshift\_execute\_query

Execute a SQL query on Amazon Redshift

**Parameters:**

| Parameter    | Type      | Required | Default | Description                                |
| ------------ | --------- | -------- | ------- | ------------------------------------------ |
| `query`      | string    | Yes      | —       | SQL query to execute                       |
| `parameters` | string\[] | No       | —       | Query parameters for parameterized queries |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "query": {
        "type": "string",
        "description": "SQL query to execute"
      },
      "parameters": {
        "type": "array",
        "items": {
          "oneOf": [
            {
              "type": "string"
            },
            {
              "type": "number"
            },
            {
              "type": "boolean"
            },
            {
              "type": "null"
            }
          ]
        },
        "description": "Query parameters for parameterized queries"
      }
    },
    "required": [
      "PCID",
      "query"
    ]
  }
  ```
</Expandable>

***

## redshift\_get\_database\_info

Get Amazon Redshift connection metadata including host, port, database name, and SSL status

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      }
    },
    "required": [
      "PCID"
    ]
  }
  ```
</Expandable>

***

## redshift\_insert\_data

Insert data into an Amazon Redshift table

**Parameters:**

| Parameter | Type   | Required | Default | Description                       |
| --------- | ------ | -------- | ------- | --------------------------------- |
| `table`   | string | Yes      | —       | Table name                        |
| `data`    | object | Yes      | —       | Data to insert as key-value pairs |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "table": {
        "type": "string",
        "description": "Table name"
      },
      "data": {
        "type": "object",
        "additionalProperties": true,
        "description": "Data to insert as key-value pairs"
      }
    },
    "required": [
      "PCID",
      "table",
      "data"
    ]
  }
  ```
</Expandable>

***

## redshift\_list\_tables

List all tables in the Amazon Redshift database

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      }
    },
    "required": [
      "PCID"
    ]
  }
  ```
</Expandable>

***

## redshift\_select\_data

Select data from an Amazon Redshift table

**Parameters:**

| Parameter     | Type      | Required | Default | Description                         |
| ------------- | --------- | -------- | ------- | ----------------------------------- |
| `table`       | string    | Yes      | —       | Table name                          |
| `columns`     | string\[] | No       | —       | Columns to select (defaults to all) |
| `where`       | string    | No       | —       | WHERE clause conditions             |
| `whereParams` | string\[] | No       | —       | Parameters for WHERE clause         |
| `orderBy`     | string    | No       | —       | ORDER BY clause                     |
| `limit`       | number    | No       | —       | LIMIT number of results             |
| `offset`      | number    | No       | —       | OFFSET for pagination               |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "table": {
        "type": "string",
        "description": "Table name"
      },
      "columns": {
        "type": "array",
        "items": {
          "type": "string"
        },
        "description": "Columns to select (defaults to all)"
      },
      "where": {
        "type": "string",
        "description": "WHERE clause conditions"
      },
      "whereParams": {
        "type": "array",
        "items": {
          "oneOf": [
            {
              "type": "string"
            },
            {
              "type": "number"
            },
            {
              "type": "boolean"
            },
            {
              "type": "null"
            }
          ]
        },
        "description": "Parameters for WHERE clause"
      },
      "orderBy": {
        "type": "string",
        "description": "ORDER BY clause"
      },
      "limit": {
        "type": "number",
        "description": "LIMIT number of results"
      },
      "offset": {
        "type": "number",
        "description": "OFFSET for pagination"
      }
    },
    "required": [
      "PCID",
      "table"
    ]
  }
  ```
</Expandable>

***

## redshift\_update\_data

Update data in an Amazon Redshift table

**Parameters:**

| Parameter     | Type      | Required | Default | Description                       |
| ------------- | --------- | -------- | ------- | --------------------------------- |
| `table`       | string    | Yes      | —       | Table name                        |
| `data`        | object    | Yes      | —       | Data to update as key-value pairs |
| `where`       | string    | Yes      | —       | WHERE clause                      |
| `whereParams` | string\[] | No       | —       | Parameters for WHERE clause       |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "table": {
        "type": "string",
        "description": "Table name"
      },
      "data": {
        "type": "object",
        "additionalProperties": true,
        "description": "Data to update as key-value pairs"
      },
      "where": {
        "type": "string",
        "description": "WHERE clause"
      },
      "whereParams": {
        "type": "array",
        "items": {
          "oneOf": [
            {
              "type": "string"
            },
            {
              "type": "number"
            },
            {
              "type": "boolean"
            },
            {
              "type": "null"
            }
          ]
        },
        "description": "Parameters for WHERE clause"
      }
    },
    "required": [
      "PCID",
      "table",
      "data",
      "where"
    ]
  }
  ```
</Expandable>