MySQL MCP Server

No. Oracle publishes a MySQL MCP Server in its oracle/mcp repository as a proof of concept for MySQL AI and MySQL HeatWave, and says it is not intended for production use. InsightfulPipe is an independent, hosted server and is not affiliated with Oracle.

Oracle's server runs locally with uvx, reads MySQL credentials from a config file or environment variable, and adds MySQL AI, HeatWave and OCI tools. InsightfulPipe is a hosted service for any MySQL database reachable over TLS, with read and write classification for every SQL request, team roles and per-database action controls.

Any AI client that supports remote MCP servers. The setup guide on this page covers Claude, ChatGPT, Claude Code, Cursor, Gemini CLI and Codex. You can also work with the same connected accounts from the terminal with the InsightfulPipe CLI.

Yes. In Claude, add https://mysql.insightfulmcp.com/ as a custom connector and authorize your InsightfulPipe account. You can also add InsightfulPipe from the Claude Directory, which connects all of your linked accounts at once.

Yes. Add the server URL as a custom connector in ChatGPT Developer mode, or add InsightfulPipe from the ChatGPT app directory to connect all of your linked accounts. Developer mode availability depends on your ChatGPT plan.

Any statement the MySQL user is allowed to run. A single SELECT runs as a read, while INSERT, UPDATE, DELETE, DDL, SELECT INTO OUTFILE and multiple statements are treated as writes. Writes run only through the write tool and only for owners, admins and operators.

Connect with a MySQL user that has only SELECT privileges, so the database rejects any write. InsightfulPipe has no separate Read-only mode for database connections, but owners, admins and operators can turn off the run query and explain query actions. EXPLAIN ANALYZE executes the statement it explains.

The database needs a public hostname or IP address, because private and loopback addresses are rejected. TLS is required: the disabled and preferred modes are refused, and connections verify the server certificate and hostname, with an optional CA certificate you provide. If the database is firewalled, allowlist InsightfulPipe's outbound IP addresses shown in your workspace settings.

Yes. Each connection is one database on one host, with its own name, and you can connect several. Each connected database counts as one connection on your plan.

You connect with a MySQL user and password, or with a TLS client certificate and key. InsightfulPipe tests the connection before saving it and stores the password and certificates encrypted. Your AI client signs in to the MCP server with your InsightfulPipe account and never sees the database credentials.

Results are capped at 10,000 rows and query text at 256 KB. The query timeout uses MySQL's MAX_EXECUTION_TIME, which MySQL applies to SELECT statements. Databases on private networks without a public address are not supported, the top queries action needs performance_schema, and EXPLAIN ANALYZE needs MySQL 8 or later.

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 include a trial. See insightfulpipe.com/pricing for current plans.