Overview MySQL is a widely used open-source relational database. Connect it to Civic to let your AI agent run SQL queries against your MySQL database, with configurable support for read-only or read-write operations.
Add to Civic Connect MySQL at nexus.civic.com
Tool Description mysql_queryExecute SQL queries against the MySQL database. SELECT is always enabled; INSERT, UPDATE, DELETE, and DDL are enabled based on security configuration
Guardrails In addition to the 14 universal guardrails , this server has 16 server-specific guardrails across 2 operations.
Guardrail Operation Timing Description Block Dynamic SQL Construction mysql_queryRequest Prevents queries using CONCAT, CHAR functions, hex literals, DECODE, UNHEX Block Function Execution mysql_queryRequest Prevents execution of stored procedures and functions with side effects Block Query Stacking mysql_queryRequest Prevents multiple queries in a single request by blocking semicolons Block SQL Comments mysql_queryRequest Prevents queries containing SQL comments (—, /* */, or #) Block System Tables Access mysql_queryRequest Prevents access to MySQL system catalogs (mysql.*, information_schema) Block Write Operations mysql_queryRequest Prevents all data modification (INSERT, UPDATE, DELETE, etc.) and DDL commands Enforce Basic SQL Character Set mysql_queryRequest Restricts queries to alphanumeric plus basic SQL characters Enforce Custom Character Set mysql_queryRequest Restricts queries to a user-defined character set Limit JOIN Complexity mysql_queryRequest Limits the number of JOINs allowed in a query Protect Sensitive Columns mysql_queryRequest Blocks queries that reference specified column names Protect Tables (Anti-Aliasing) mysql_queryRequest Blocks access to specified tables regardless of aliasing or obfuscation Query Length Limit mysql_queryRequest Limits SQL query length to prevent resource exhaustion Restrict SELECT * Usage mysql_queryRequest Controls use of SELECT * wildcards Result Row Limit mysql_queryResponse Limits the number of rows returned Block Table Schema Access read_resourceRequest Prevents access to schema details of specified tables Filter Table Listings read_resourceResponse Filters specified tables from table listings
Configure guardrails via the Civic UI or ask the Configurator Agent: “Add guardrails to my MySQL server.”
