> For the complete documentation index, see [llms.txt](https://docs.aisuru.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.aisuru.com/en/advanced-features/integrations/mcp/aisuru-mcp-which-ones-and-how-to-activate/19.-mysql-mcp-server.md).

# 19. MySQL MCP Server

MySQL is a database. It can store all kinds of information like customer lists, orders and product details.\
It can also inspect the schema\*, run queries and optionally enable write operations.

## What can it do 

This MCP acts as a  **bridge** between an Agent and your MySQL database. It allows the Agent to:

* **Read data**: ask questions like *"How many customers do we have?"* and get a real answer pulled directly from the user’s database
* **Write or update data**: add new records, update existing ones, or make changes. All through a simple conversation
* **Search and filter**: find specific information quickly without needing to dig through spreadsheets or reports manually
* **Analyze information**: get summaries, counts, or insights from your data in plain language
* **Read schema** and data, run SQL queries
* **Run INSERT/UPDATE/DELETE/DDL**: only if the related permissions are enabled

### **Is my database safe?**

This MCP is **configured**, meaning it is set up with specific rules about what it can and cannot access. That meaning, it can only access the parts of the database it's supposed to, keeping everything else secure.

### **Who can benefit from this?**

* **Business owners** who want quick answers from their data without waiting for a developer
* **Team members** who need to look up or update information but have no technical knowledge
* **Anyone** who wants to interact with a database as easily as having a conversation

## Configuration parameters

1. Create a dedicated MySQL user with the minimum required privileges
2. Collect host, port, user, password and database name
3. Enable write operations only if needed

| Parameter                | Required | Description                                                                                    |
| ------------------------ | -------- | ---------------------------------------------------------------------------------------------- |
| `MYSQL_HOST`             | Yes      | Hostname or IP of the MySQL server (must be reachable by AIsuru).                              |
| `MYSQL_PORT`             | No       | MySQL port (default: `3306`).                                                                  |
| `MYSQL_USER`             | Yes      | MySQL user to connect with.                                                                    |
| `MYSQL_PASS`             | Yes      | MySQL user password.                                                                           |
| `MYSQL_DB`               | Yes      | Name of the database to use.                                                                   |
| `ALLOW_INSERT_OPERATION` | No       | `true`/`false`. Allows `INSERT` operations. Default: `false` (read-only).                      |
| `ALLOW_UPDATE_OPERATION` | No       | `true`/`false`. Allows `UPDATE` operations. Default: `false`.                                  |
| `ALLOW_DELETE_OPERATION` | No       | `true`/`false`. Allows `DELETE` operations. Default: `false`.                                  |
| `ALLOW_DDL_OPERATION`    | No       | `true`/`false`. Allows structural operations (`CREATE TABLE`, `DROP`, etc.). Default: `false`. |

### Custom parameters

No additional parameters needed.

{% hint style="warning" %}
Keep write operations off until you're sure: that way the agent can only read.
{% endhint %}