redshift - Pinkfish - AI Agents & Workflows for Getting Work Done

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

Tools

Tool	Description
`redshift_create_table`	Create a new table in Amazon Redshift
`redshift_delete_data`	Delete data from an Amazon Redshift table
`redshift_describe_table`	Get table structure and column information for an Amazon Redshift table
`redshift_execute_query`	Execute a SQL query on Amazon Redshift
`redshift_get_database_info`	Get Amazon Redshift connection metadata including host, port, database name, and SSL status
`redshift_insert_data`	Insert data into an Amazon Redshift table
`redshift_list_tables`	List all tables in the Amazon Redshift database
`redshift_select_data`	Select data from an Amazon Redshift table
`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`	array	Yes	—	Table column definitions

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "tableName": {
      "type": "string",
      "description": "Name of the table to create"
    },
    "columns": {
      "type": "array",
      "description": "Table column definitions",
      "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",
            "description": "Whether column can be NULL",
            "default": true
          },
          "primaryKey": {
            "type": "boolean",
            "description": "Whether column is primary key",
            "default": false
          },
          "autoIncrement": {
            "type": "boolean",
            "description": "Whether column auto-increments (uses IDENTITY(1,1) in Redshift)",
            "default": false
          }
        },
        "required": ["name", "type"]
      }
    }
  },
  "required": [
    "PCID",
    "tableName",
    "columns"
  ]
}

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`	array	No	—	Parameters for WHERE clause

Show inputSchema

{
  "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",
      "description": "Parameters for WHERE clause"
    }
  },
  "required": [
    "PCID",
    "table",
    "where"
  ]
}

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

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "table": {
      "type": "string",
      "description": "Table name to describe"
    }
  },
  "required": [
    "PCID",
    "table"
  ]
}

redshift_execute_query

Execute a SQL query on Amazon Redshift Parameters:

Parameter	Type	Required	Default	Description
`query`	string	Yes	—	SQL query to execute
`parameters`	array	No	—	Query parameters for parameterized queries

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "query": {
      "type": "string",
      "description": "SQL query to execute"
    },
    "parameters": {
      "type": "array",
      "description": "Query parameters for parameterized queries"
    }
  },
  "required": [
    "PCID",
    "query"
  ]
}

redshift_get_database_info

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

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    }
  },
  "required": [
    "PCID"
  ]
}

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

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "table": {
      "type": "string",
      "description": "Table name"
    },
    "data": {
      "type": "object",
      "description": "Data to insert as key-value pairs"
    }
  },
  "required": [
    "PCID",
    "table",
    "data"
  ]
}

redshift_list_tables

List all tables in the Amazon Redshift database

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    }
  },
  "required": [
    "PCID"
  ]
}

redshift_select_data

Select data from an Amazon Redshift table Parameters:

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

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "table": {
      "type": "string",
      "description": "Table name"
    },
    "columns": {
      "type": "array",
      "description": "Columns to select (defaults to all)",
      "items": {
        "type": "string"
      }
    },
    "where": {
      "type": "string",
      "description": "WHERE clause conditions"
    },
    "whereParams": {
      "type": "array",
      "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"
  ]
}

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`	array	No	—	Parameters for WHERE clause

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "table": {
      "type": "string",
      "description": "Table name"
    },
    "data": {
      "type": "object",
      "description": "Data to update as key-value pairs"
    },
    "where": {
      "type": "string",
      "description": "WHERE clause"
    },
    "whereParams": {
      "type": "array",
      "description": "Parameters for WHERE clause"
    }
  },
  "required": [
    "PCID",
    "table",
    "data",
    "where"
  ]
}

Reducto Relativity

⌘I

​Tools

​redshift_create_table

​redshift_delete_data

​redshift_describe_table

​redshift_execute_query

​redshift_get_database_info

​redshift_insert_data

​redshift_list_tables

​redshift_select_data

​redshift_update_data

Tools

redshift_create_table

redshift_delete_data

redshift_describe_table

redshift_execute_query

redshift_get_database_info

redshift_insert_data

redshift_list_tables

redshift_select_data

redshift_update_data