Amazon Redshift - Civic Docs

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

Configure guardrails via the Civic UI or ask the Configurator Agent: “Add guardrails to my Amazon Redshift server.”