# Triagic + MySQL: ticket investigations over your database, read-only

> MySQL in Triagic: Browse every database, table and schema the credentials can reach. Read-only, with a credential you configure.

Source: https://triagic.com/integrations/mysql

## What you can ask

- Look up account acme-labs in MySQL and tell me why their last export failed
- In MySQL, how many orders for org 8412 are stuck in a non-terminal state right now?
- Which rows in MySQL changed for user 51930 in the last 24 hours?
- Compare the MySQL record for invoice INV-2291 with what the customer says they see
- Does MySQL show the same plan for this account as the billing system does?

## What the agent can do

- `list_databases`
- `list_tables`
- `describe_table`
- `sample_table`

## Connect in three steps

1. **Mint a read-only credential in MySQL.** Create a dedicated user or token that can only read. Triagic writes this server: its four tools run fixed information_schema queries with bound parameters, there is no general SQL tool, and each connection opens SET SESSION TRANSACTION READ ONLY.
2. **Add it in the Triagic portal.** Integrations, then Add shared data source, then MySQL. Fill in: Host (required); User (required)
3. **Let a desktop pick it up.** Saving validates the shape of what you typed. The first desktop app to sync starts MySQL locally and reports running or degraded with the error text.

Setup reference: https://triagic.com/docs/integrations/databases#mysql

## Read-only, by construction

Triagic writes this server: its four tools run fixed information_schema queries with bound parameters, there is no general SQL tool, and each connection opens SET SESSION TRANSACTION READ ONLY.

## FAQ

**Can Triagic change anything in MySQL?**
No. Triagic writes this server: its four tools run fixed information_schema queries with bound parameters, there is no general SQL tool, and each connection opens SET SESSION TRANSACTION READ ONLY. Give it a read-only credential as well, so the guarantee does not rest on one layer.

**What do I need to connect MySQL?**
Host, User. The desktop app on a member's machine starts the connection; the portal never holds a live process.

**Does MySQL cost extra?**
No. Every connector is included in the seat price. Start a 14-day trial without a card.

## Related integrations

- [MongoDB](https://triagic.com/integrations/mongodb)
- [PostgreSQL](https://triagic.com/integrations/postgres)
- [Redis](https://triagic.com/integrations/redis)
- [ClickHouse](https://triagic.com/integrations/clickhouse)