Category

Tool

Description

Database Connection Management

Load connection configs from JSON/env vars

Import database configs from JSON files or environment variables

List all configured database connections

Display all available/pre-configured database connections

Validate connectivity and resolve provider mode

Test database connections and identify DB provider mode

Database Operations

Execute SQL queries

Run SQL statements against the connected database

GenAI Operations

Text generation with HeatWave GenAI

Use GenAI to generate or augment text

Create/populate vector columns for embeddings

Generate and save vector representations in DB columns

Retrieval-augmented generation from vector stores

Use vector store for improved GenAI results

Vector Store Ingestion

Load documents from Object Storage into vector store

Ingest files/objects from Object Storage to populate vector DB

OCI Object Store

List all compartments

Display all available OCI compartments

Get compartment by name

Find a compartment by its name

List buckets in a compartment

Show storage buckets within a selected compartment

List objects in a bucket

Display items stored in a specific storage bucket

Can you help me load my menu item into the database? I think the PDF was called something like IRIS lunch menu and was in something called ILA compartment.

Cline wants to use a tool on the mysql-mcp-server MCP server:

list_all_compartments

[MCP Tool] List all compartments in the tenancy. Args: None Returns: str: Stringified per-compartment access report: { “<compartment_name>”: { “compartment_id”: “<ocid>”, “object_storage”: true|false, “databases”: true|false, “errors”: [ “<error strings>” ] }, … } …..

Cline wants to use a tool on the mysql-mcp-server MCP server:

object_storage_list_buckets

[MCP Tool] List all accessible Object Storage buckets in a compartment. Args: compartment_name (str, optional): Case-insensitive compartment name to resolve to an OCID. compartment_id (str, optional): Compartment OCID. If provided, takes precedence over name resolution. Returns: str: Stringified list of oci.object_storage.models. BucketSummary objects on success. …..

ARGUMENTS

{
“compartment_name”: “ILA”
}

Cline wants to use a tool on the mysql-mcp-server MCP server:

object_storage_list_objects

[MCP Tool] List objects stored in an OCI Object Storage bucket. Args: namespace (str): Object Storage namespace for the tenancy. bucket_name (str): Name of the bucket to list objects from. Returns: str: Stringified list of oci.object_storage.models.ObjectSummary ………..default profile).

ARGUMENTS
{

“namespace”: “mysqlpm”,
“bucket_name”: “bucket-chicago-sp1”

}

Cline wants to use a tool on the mysql-mcp-server MCP server:

list_all_connections

[MCP Tool] List configured connection keys, validate connectivity, and report mode. Args: None Returns: str: JSON-encoded object: { “valid keys”: [{“key”: string, “mode”: “MYSQL_AI” | “OCI”}], “invalid keys”: [{“key”: string, “error”: string, “hint”: string}] } Notes: – …….

Cline wants to use a tool on the mysql-mcp-server MCP server:

load_vector_store_oci

[MCP Tool] Load documents from OCI Object Storage into a Heatwave vector store. Purpose: Load documents from object storage into a vector store for similarity search and RAG. The document_prefix can be a file name, a directory/prefix, or a partial prefix. Examples (assuming these objects exist in the bucket): heatwave-en-ml-9.2.0.pdf sample_files/document1.pdf sample_files/document2.pdf sample_files/documents_345.docx Valid document_prefix values: ‘heatwave-en-ml’ ……

ARGUMENTS

{

“connection_id”: “remote_via_bastion”,

“namespace”: “mysqlpm”,

“bucket_name”: “bucket-chicago-sp1”,

“document_prefix”: “restaurant_menus/PLUEP1EQiqfnaWZyVMYK_7.23.25 IRIS Lunch Menu Update.pdf”

}

Cline wants to use a tool on the mysql-mcp-server MCP server:

execute_sql_tool_by_connection_id

Execute a SQL script on the specified database connection. Args: connection_id (str): The key identifying the database connection to use. sql_script (str): The SQL statement to execute. Can be a query or a DML/DDL statement. params (list, optional): List of parameters to use for parameterized SQL scripts. If None, executes with no bind variables. Returns: ….. [42])

ARGUMENTS

{
“connection_id”: “remote_via_bastion”,

Ask the database what menu items I have

1. The user wants to query the vector store/database to extract/see the menu items from the uploaded “IRIS Lunch Menu” PDF.
2. The optimal approach is to use the AI vector store RAG query capability, which will retrieve the recognized menu items, since the file was processed as an OCR’d PDF
3. Use the ask_ml_rag_vector_store tool to ask: “What menu items do I have?” (which will return a list or summary from the ingested menu document).
4. Use the valid connection key: “remote_via_bastion”.

ask_ml_rag_vector_store

[MCP Tool] Retrieve segments from the default vector store (skip_generate=true). Args: connection_id (str): MySQL connection key. question (str): Natural language query. context_size (int): between (inclusive) 10 and 100, the context size for RAG. Try increasing if RAG call does not provide sufficient relevant documents. Returns: str: Scalar result from SELECT @response (often JSON). On error, a JSON-encoded object. Implementation details: – Equivalent to ask_ml_rag(connection_id, question). MCP usage example: – name: ask_ml_rag_vector_store arguments: {“connection_id”: “example_local_server”, “question”: “Find information about refunds.”}

ARGUMENTS

{

“connection_id”: “remote_via_bastion”,

“question”: “What menu items do I have?”, “context_size”: 40

Here is the final response:

The menu items currently in your database from the “IRIS Lunch Menu” include:

• Iris Tzatziki (v): fennel pollen, sorrel (16)
• Hummus (v): sumac, sesame (14)
• Roasted Eggplant (v): pine nut, golden raisin (12)
• Whipped Feta (v): (13)
• Village Salad (v): hot house tomato, cucumber, red onion, citrus marinated feta, olive (24/34)
• Add: falafel (10), chicken (10), shrimp (12), lamb (14)
• Little Ram Oysters*: pink peppercorn mignonette (18/33)
• Grilled Lagana Bread: taramasalata, pickled ramps, soft herbs (14)
• Dolmas (v): lemon agrumato, valencia orange (8)
• Hand-Cut Fries: lemon, oregano (14)
• Fried Squid: dashi lime aioli (19)
• Orzotto: (12)
• Swiss chard, kale, elephant garlic
• Grilled Octopus: potato-labne puree, cured lemon, paprika aioli (32)
• Quail Kebab: pepper crusted, sage butter, braised wild greens (32)

These were extracted using vector search from the uploaded PDF menu. Let me know if you want specific menu item details, prices, or further queries.