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

# Amazon Redshift

> Amazon Redshift data warehouse — execute SQL queries with automatic row limiting

## Overview

Amazon Redshift is a cloud data warehouse optimized for analytical queries. Connect it to Civic to let your AI agent run SQL queries against your Redshift cluster, with automatic row limiting to prevent runaway result sets.

<Card title="Add to Civic" icon="plus" href="https://app.civic.com">
  Connect Amazon Redshift at app.civic.com
</Card>

## Available Tools (1)

| Tool    | Description                                                                                                  |
| ------- | ------------------------------------------------------------------------------------------------------------ |
| `query` | Execute SQL queries against Amazon Redshift with automatic row limiting for safety (default 10 rows, max 50) |

***

## Guardrails

In addition to the [14 universal guardrails](/civic/concepts/guardrails), this server has **17 server-specific guardrails** across 1 operation.

| Guardrail                       | Operation | Timing  | Description                                                                                               |
| ------------------------------- | --------- | ------- | --------------------------------------------------------------------------------------------------------- |
| Block COPY/UNLOAD Operations    | `query`   | Request | Prevents bulk data operations (COPY, UNLOAD) that could enable data exfiltration                          |
| Block Dynamic SQL Construction  | `query`   | Request | Prevents queries using \|\|, CONCAT, CHR/CHAR functions, hex literals                                     |
| Block External Schema Access    | `query`   | Request | Prevents access to external schemas used for Redshift Spectrum or federated queries                       |
| Block Function Execution        | `query`   | Request | Prevents execution of stored procedures and functions with side effects                                   |
| Block Maintenance Operations    | `query`   | Request | Prevents maintenance operations (VACUUM, ANALYZE) that affect system performance                          |
| Block Query Stacking            | `query`   | Request | Prevents multiple queries in a single request by blocking semicolons                                      |
| Block SQL Comments              | `query`   | Request | Prevents queries containing SQL comments (-- or /\* \*/)                                                  |
| Block System Tables Access      | `query`   | Request | Prevents access to Redshift system catalogs (stv\_*, stl\_*, svv\_*, svl\_*, pg\_\*, information\_schema) |
| Block Write Operations          | `query`   | Request | Prevents all data modification (INSERT, UPDATE, DELETE, etc.) and DDL commands                            |
| Enforce Basic SQL Character Set | `query`   | Request | Restricts queries to alphanumeric plus basic SQL characters                                               |
| Enforce Custom Character Set    | `query`   | Request | Restricts queries to a user-defined character set                                                         |
| Limit JOIN Complexity           | `query`   | Request | Limits the number of JOINs allowed in a query                                                             |
| MaxRows Parameter Limit         | `query`   | Request | Limits the maxRows parameter to prevent large result sets                                                 |
| Protect Sensitive Columns       | `query`   | Request | Blocks queries that reference specified column names                                                      |
| Protect Tables (Anti-Aliasing)  | `query`   | Request | Blocks access to specified tables regardless of aliasing or obfuscation                                   |
| Query Length Limit              | `query`   | Request | Limits SQL query length to prevent resource exhaustion                                                    |
| Restrict SELECT \* Usage        | `query`   | Request | Controls use of SELECT \* wildcards                                                                       |

<Tip>
  Configure guardrails via the Civic UI or ask the Configurator Agent: "Add guardrails to my Amazon Redshift server."
</Tip>