Amazon Redshift
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.
Add to Civic
Connect Amazon Redshift at app.civic.com
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, 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."