Skip to main content
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.
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 NameValue
MYSQL_HOSTYour database host
MYSQL_USERYour database user
MYSQL_PASSWORDYour database password
MYSQL_DATABASEYour 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?