> ## Documentation Index
> Fetch the complete documentation index at: https://v1-docs.adapt.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# MySQL

> Connect MySQL to query your database and analyze your data with natural language

Connect Adapt to MySQL to query your database and analyze your data using
natural language. Adapt connects to your MySQL-compatible database directly, so
you can explore tables and pull insights without writing SQL by hand.

## Set up credentials

Gather these connection details from your MySQL database before connecting:

**1. Find your host and port**

Locate your database **host** (the server address, for example
`db.example.com` or an IP) from your database provider or server config.
MySQL uses port `3306` by default.

**2. Identify your database name**

Determine the **database** (schema) you want Adapt to query. You can list
databases with `SHOW DATABASES;` if you are unsure.

**3. Create a read-only user (recommended)**

For safety, create a dedicated user with read-only access and grant it
`SELECT` on the database you want Adapt to read, rather than using an admin
account. Note the **user** and **password**.

> [!NOTE]
>
> If your database is behind a firewall or private network, make sure the host is
> reachable and that any required IP addresses are allowlisted.

## Connect to Adapt

**1. Open Integrations**

In Adapt, go to **Settings > Integrations**.

**2. Find MySQL**

Search for **MySQL** and select it from the catalog.

**3. Start the connection**

Click **Connect** to open the connection form.

**4. Add your credentials**

Enter the values you gathered above, then click **Add connection**:

| Secret Name | Value |
| - | - |
| `MYSQL_HOST` | Your database host |
| `MYSQL_USER` | Your database user |
| `MYSQL_PASSWORD` | Your database password |
| `MYSQL_DATABASE` | Your database name |

You can rename the connection and choose whether it is shared with your
organization or kept personal to you.

**5. Test the connection**

Ask Adapt to list your tables or query your data.

### Security

* Credentials are encrypted at rest with AES-256
* Use a dedicated user with read-only (`SELECT`-only) privileges
* Connect over SSL/TLS whenever your server supports it
* Restrict network access to your database and allowlist only trusted addresses
* Never share your credentials publicly or commit them to source control

## Capabilities

Adapt can query your MySQL database. Explore your tables and analyze your data
using natural language.

### Examples

Explore data:

```
What tables are in my MySQL database?
```

Inspect a table:

```
Show me the columns and types in the orders table.
```

Summarize records:

```
How many orders were placed in the last 7 days?
```

Analyze trends:

```
What are my top 10 customers by total spend this year?
```


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.