MySQL - Civic Docs

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 app.civic.com

Available Tools (1)

Tool	Description
`mysql_query`	Execute 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_query`	Request	Prevents queries using CONCAT, CHAR functions, hex literals, DECODE, UNHEX
Block Function Execution	`mysql_query`	Request	Prevents execution of stored procedures and functions with side effects
Block Query Stacking	`mysql_query`	Request	Prevents multiple queries in a single request by blocking semicolons
Block SQL Comments	`mysql_query`	Request	Prevents queries containing SQL comments (—, /* */, or #)
Block System Tables Access	`mysql_query`	Request	Prevents access to MySQL system catalogs (mysql.*, information_schema)
Block Write Operations	`mysql_query`	Request	Prevents all data modification (INSERT, UPDATE, DELETE, etc.) and DDL commands
Enforce Basic SQL Character Set	`mysql_query`	Request	Restricts queries to alphanumeric plus basic SQL characters
Enforce Custom Character Set	`mysql_query`	Request	Restricts queries to a user-defined character set
Limit JOIN Complexity	`mysql_query`	Request	Limits the number of JOINs allowed in a query
Protect Sensitive Columns	`mysql_query`	Request	Blocks queries that reference specified column names
Protect Tables (Anti-Aliasing)	`mysql_query`	Request	Blocks access to specified tables regardless of aliasing or obfuscation
Query Length Limit	`mysql_query`	Request	Limits SQL query length to prevent resource exhaustion
Restrict SELECT * Usage	`mysql_query`	Request	Controls use of SELECT * wildcards
Result Row Limit	`mysql_query`	Response	Limits the number of rows returned
Block Table Schema Access	`read_resource`	Request	Prevents access to schema details of specified tables
Filter Table Listings	`read_resource`	Response	Filters specified tables from table listings

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