Use Claude to Talk to Your MySQL Data via CData Connect AI

Claude is a family of advanced large language models (LLMs) built by Anthropic, an AI research company founded in 2021. These models power the Claude conversational assistant and developer tools.

CData Connect AI offers a dedicated cloud-to-cloud interface for connecting to MySQL data. The CData Connect AI Remote MCP Server enables secure communication between Claude and MySQL. This allows you to ask questions and take actions on your MySQL data using Claude, all without the need for data replication to a natively supported database. With its inherent optimized data processing capabilities, CData Connect AI efficiently channels all supported SQL operations, including filters and JOINs, directly to MySQL. This leverages server-side processing to swiftly deliver the requested MySQL data.

Step 1: Configure MySQL Connectivity for Claude

Connectivity to MySQL from Claude is made possible through CData Connect AI Remote MCP. To interact with MySQL data from Claude, we start by creating and configuring a MySQL connection in CData Connect AI.

1. Log into Connect AI, click Sources, and then click Add Connection
👁 Adding a Connection

2. Select "MySQL" from the Add Connection panel
👁 Selecting a data source

3. Enter the necessary authentication properties to connect to MySQL.

   The CData Provider supports connecting to on-premises and cloud-hosted versions of MySQL such as Amazon RDS for MySQL, Google Cloud SQL for MySQL, Azure Database for MySQL, or Oracle MySQL HeatWave. The Server and Port properties must be set to a MySQL server. If IntegratedSecurity is set to false, then User and Password must be set to valid user credentials. Optionally, Database can be set to connect to a specific database. If not set, tables from all databases will be returned.

   SSH Connectivity for MySQL

   You can use SSH (Secure Shell) to authenticate with MySQL, whether the instance is hosted on-premises or in supported cloud environments. SSH authentication ensures that access is encrypted (as compared to direct network connections).

   SSH Connections to MySQL in Password Auth Mode

   To connect to MySQL via SSH in Password Auth mode, set the following connection properties:

   • User: MySQL User name
   • Password: MySQL Password
   • Database: MySQL database name
   • Server: MySQL Server name
   • Port: MySQL port number like 3306
   • UserSSH: "true"
   • SSHAuthMode: "Password"
   • SSHPort: SSH Port number
   • SSHServer: SSH Server name
   • SSHUser: SSH User name
   • SSHPassword: SSH Password

   SSH Connections to MySQL in Public Key Auth Mode

   To connect to MySQL via SSH in Password Auth mode, set the following connection properties:

   • User: MySQL User name
   • Password: MySQL Password
   • Database: MySQL database name
   • Server: MySQL Server name
   • Port: MySQL port number like 3306
   • UserSSH: "true"
   • SSHAuthMode: "Public_Key"
   • SSHPort: SSH Port number
   • SSHServer: SSH Server name
   • SSHUser: SSH User name
   • SSHClientCret: the path for the public key certificate file
   👁 Configuring a connection (Salesforce is shown)
   
4. Click Save & Test

Step 2: Connect Claude to CData Connect AI

Follow these steps to add a CData Connect AI connector in Claude:

1. Sign in to Claude.ai or create a new account.
2. Expand the left navigation menu.
3. In the bottom-left corner, click your user name and select Settings from the menu. The Settings screen appears.
4. In the Settings screen, click Connectors.
5. Click the button to Browse Connectors.
6. Search for "CData Connect AI" and click the listing. 👁 Adding CData Connect AI
   
7. Click "Connect" and sign into your Connect AI account. 👁 Connecting to your Connect AI account
   
8. After connecting, Claude opens a new chat.

Step 3: Explore Live MySQL Data with Claude

1. You can now start exploring your data with natural language prompts. Claude outlines the steps it uses to retrieve data from the source in CData Connect AI. Refer to CData's prompt library for prompt ideas.
👁 Exploring data with Claude

NOTE: Claude's setup process is subject to change. Refer to Claude's documentation for the latest setup information.

Get CData Connect AI

To get live data access to hundreds of SaaS, Big Data, and NoSQL sources directly from your cloud applications, try CData Connect AI today!