Connect MySQL to Claude in 5 Minutes

Let Claude and ChatGPT query your MySQL database directly using the Model Context Protocol (MCP). Ask questions in plain English, get answers from live data — no backend code, no API wrappers, no SQL knowledge required.

What You Need

  • MySQL 5.7+, MySQL 8.0, or MariaDB
  • A free Conexor account
  • Claude Desktop, Claude API, or ChatGPT

Step-by-Step Setup

1

Sign up at conexor.io

Create a free account at conexor.io/register — no credit card required. The free tier includes one database connection and 1,000 queries per month.

2

Download and install the Conexor agent

Install the Conexor agent on your server or any machine that can reach your MySQL instance. The agent connects outbound only — no firewall changes needed.

3

Add MySQL as a data source

Provide your MySQL connection details. We recommend creating a dedicated read-only user for security.

Server=yourhost;Port=3306;Database=yourdb;Uid=youruser;Pwd=yourpassword;
4

Schema discovery runs automatically

Conexor reads your MySQL schema — tables, columns, types, and relationships — and generates MCP tools for each table automatically.

5

Connect Claude Desktop to your MCP server URL

Copy the MCP server URL from your Conexor dashboard. Open Claude Desktop → Settings → MCP Servers → Add Server. Paste the URL and start querying your data.

https://mcp.conexor.io/sse?apiKey=cnx_your_api_key

What AI Can Now Do With Your MySQL Data

How many active users do we have?

Queries users table

Returns the count from your users table

What were our top 5 products by revenue last month?

Complex GROUP BY query

Returns your top products ranked by revenue

Show me customers who haven't ordered in 90 days

Joins orders + customers tables

Lists inactive customers with last order dates

What's the average order value by country?

Aggregate query across orders

Returns average order values grouped by country

Common MySQL use cases for Claude and ChatGPT

E-commerce and order analysis

Ask which products are slowing down, which countries have the highest repeat purchase rates, or which customers are close to churn, directly from live MySQL tables.

Support and operations lookups

Let teams inspect ticket volume, failed jobs, signup drops, or account health without waiting for someone to write SQL manually.

Ad hoc reporting for fast-moving teams

When questions change daily, AI on top of MySQL gives flexible reporting without building a new dashboard for every stakeholder request.

Safer database access for AI workflows

Use scoped credentials, read-only defaults, and audit logs instead of exposing raw MySQL access to every assistant, bot, or internal tool.

Enterprise-Grade Security

SELECT-Only Enforcement

AI can only read your data. INSERT, UPDATE, DELETE, and DDL statements are blocked at the protocol level.

Credential Encryption

Database credentials are AES-256 encrypted at rest. They never leave your infrastructure when using the on-premise agent.

Full Audit Logging

Every AI-generated query is logged with timestamp, user, and results. Review any query from your dashboard.

Start Free — Connect MySQL to Claude

Free tier includes 1 database connection and 1,000 queries/month. No credit card required.

Get Started Free →
Relay

Quick questions

Relay

Quick questions

Ask me