MySQL MCP by InsightfulPipe

MCP Compatible Insightful Pipe License

Connect MySQL to AI assistants: schemas, tables, SQL and database health for MySQL and MariaDB.

Part of the Insightful Pipe MCP Server Collection — use MySQL from Claude, ChatGPT, Cursor, and other AI assistants through the Model Context Protocol (MCP).

MCP Server URL

https://mysql.insightfulmcp.com/

What is MySQL MCP?

MySQL MCP is a remote Model Context Protocol server hosted by InsightfulPipe. Browse schemas, inspect tables, and run SQL against your own MySQL or MariaDB instance. Read vs. read-write is decided by the GRANT/REVOKE privileges on the role this connector logs in as.

Installation

Claude

1. Copy the MCP Server URL: https://mysql.insightfulmcp.com/
2. Open Claude Connectors Settings
3. Scroll to the bottom and click Add custom connector
4. Paste the URL and click Add
5. Click Connect and sign in to InsightfulPipe if asked. Claude then lists the connector as connected.

ChatGPT

Custom MCP servers are added through ChatGPT's Developer mode. Availability depends on your ChatGPT plan, and workspace admins may need to allow it.

1. Turn on Developer mode in ChatGPT settings
2. Create a new app for a remote MCP server and paste the URL: https://mysql.insightfulmcp.com/
3. Sign in to InsightfulPipe if asked. The connection finishes as soon as you are signed in.

See OpenAI's guide: Developer mode and MCP apps in ChatGPT

Claude Code

claude mcp add --transport http mysql https://mysql.insightfulmcp.com/

Cursor

Add the server to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (one project):

{
  "mcpServers": {
    "mysql": {
      "url": "https://mysql.insightfulmcp.com/"
    }
  }
}

When Cursor shows Needs authentication, click Connect and sign in to InsightfulPipe if asked.

Available Actions

8 actions: 7 read, 1 write.

Read Actions (7)

Action	Description
analyze_db_health	Connection pool + buffer pool size + tables with reclaimable space
explain_query	EXPLAIN plan for a query
get_table_metadata	Full metadata: columns + constraints + indexes + estimated size
get_table_schema	Column list (name, data_type, is_nullable, default) for a table or view
get_top_queries	Heaviest queries from performance_schema.events_statements_summary_by_digest
list_schemas	List all schemas (databases) on the server
list_tables	List tables, views, or plugins in a schema

Write Actions (1)

Action	Description
run_query	Execute a SQL statement

Control What Your AI Can Do

You decide what AI agents can do with each connected account:

• Turn individual actions on or off for every connected account, so agents only see the actions you allow.
• Connect as Read-only or Read & Write. A read-only connection can only enable read actions.
• Destructive actions stay off by default. Actions such as deletes are disabled until an admin enables them.
• Team access per account. Restricted team members only use the accounts they are granted, with the read actions enabled on them.

Usage Examples

"List the tables in my database"

"Show the schema of the orders table"

"Run a query for revenue by month"

Pricing

The MySQL MCP server is included in every InsightfulPipe plan, together with all other MCP servers and the CLI. Plans start at $29.99/month, and you can try it for 7 days. See insightfulpipe.com/pricing for current plans.

Explore More MCP Servers by Insightful Pipe

Visit insightfulpipe.com/mcp-servers to discover our full collection of MCP servers.

• PostgreSQL MCP
• SQL Server MCP
• BigQuery MCP

View All MCP Servers →

Resources

• Documentation
• Video Tutorial
• InsightfulPipe Blog

Support

• Documentation: insightfulpipe.com/docs
• All MCP Servers: insightfulpipe.com/mcp-servers
• Email: [email protected]

---

Insightful Pipe — AI-powered marketing analytics through MCP servers. Explore all integrations →

License

MIT License - see LICENSE for details.