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 nexus.civic.com
Tool Description queryExecute 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 queryRequest Prevents bulk data operations (COPY, UNLOAD) that could enable data exfiltration Block Dynamic SQL Construction queryRequest Prevents queries using ||, CONCAT, CHR/CHAR functions, hex literals Block External Schema Access queryRequest Prevents access to external schemas used for Redshift Spectrum or federated queries Block Function Execution queryRequest Prevents execution of stored procedures and functions with side effects Block Maintenance Operations queryRequest Prevents maintenance operations (VACUUM, ANALYZE) that affect system performance Block Query Stacking queryRequest Prevents multiple queries in a single request by blocking semicolons Block SQL Comments queryRequest Prevents queries containing SQL comments (— or /* */) Block System Tables Access queryRequest Prevents access to Redshift system catalogs (stv_, stl_ , svv_, svl_ , pg_*, information_schema) Block Write Operations queryRequest Prevents all data modification (INSERT, UPDATE, DELETE, etc.) and DDL commands Enforce Basic SQL Character Set queryRequest Restricts queries to alphanumeric plus basic SQL characters Enforce Custom Character Set queryRequest Restricts queries to a user-defined character set Limit JOIN Complexity queryRequest Limits the number of JOINs allowed in a query MaxRows Parameter Limit queryRequest Limits the maxRows parameter to prevent large result sets Protect Sensitive Columns queryRequest Blocks queries that reference specified column names Protect Tables (Anti-Aliasing) queryRequest Blocks access to specified tables regardless of aliasing or obfuscation Query Length Limit queryRequest Limits SQL query length to prevent resource exhaustion Restrict SELECT * Usage queryRequest Controls use of SELECT * wildcards
Configure guardrails via the Civic UI or ask the Configurator Agent: “Add guardrails to my Amazon Redshift server.”
