Skip to main content
Watch: I Built an AI App Without Leaving Databricks

Databases - official Oracle server

MySQL MCP server

Python MCP server for managing connections to MySQL AI and MySQL HeatWave, running SQL, using HeatWave ML/GenAI features such as RAG and natural-language-to-SQL, managing vector stores and browsing OCI Object Storage. It runs locally from oracle.mysql-mcp-server (pypi); the notes below cover how it authenticates.

Last verified 6 tools2 sources

Install

Generic

JSON
{
  "mcpServers": {
    "mysql": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "oracle.mysql-mcp-server"
      ],
      "env": {
        "OCI_CONFIG_PROFILE": "DEFAULT",
        "MYSQL_MCP_CONFIG": "/path/to/your/config.json"
      }
    }
  }
}

Tools

ml_generate
Text generation with HeatWave GenAI.
ragify_column
Creates and populates vector columns for embeddings.
ask_ml_rag
Retrieval-augmented generation from vector stores.
ask_nl_sql
Converts natural language questions into SQL and executes them.
heatwave_ask_help
Answers questions about using HeatWave ML.
retrieve_relevant_schema_information
Retrieves relevant schemas and table DDL for a natural language question.

As documented on October 17, 2026. A running server reports its current list through tools/list.

Notes and caveats

  • Oracle states it is not intended for production use and is a proof of concept.
  • Runs over stdio.
  • Requires a database connection config file (MYSQL_MCP_CONFIG); an OCI config is only needed for OCI-dependent features such as Object Storage and compartments.

FAQ

What does the MySQL MCP server do?

Python MCP server for managing connections to MySQL AI and MySQL HeatWave, running SQL, using HeatWave ML/GenAI features such as RAG and natural-language-to-SQL, managing vector stores and browsing OCI Object Storage. The vendor documents 6 tools, including ml_generate, ragify_column, ask_ml_rag and ask_nl_sql.

How do I add the MySQL MCP server to an MCP client?

Oracle documents a Generic config; copy it from the Generic section of this page.

Does the MySQL MCP server need authentication?

It uses a scheme other than OAuth or an API key, such as the session of the app or instance it runs in; the notes on this page describe it. Transport: stdio. Status: Preview, last checked October 17, 2026.

Sources

Last verified against 2 Oracle pages, then re-checked independently.

Newsletter

New MCP servers, the week they ship

One email per week. New official MCP servers, the coding tools that support them and how developers wire them up.