Ai MCP Sql

🚀 Running the MCP Server

This guide provides steps to run the MCP server and test its full "CRUD" (Create, Read, Update, Delete) cycle.

🚀 Quick Start

Prerequisites

• Download the Gemini Code Assist VS Code extension.
• Ensure that the Gemini Code extension is in agent mode.
• Important: Reload VS Code after updating any settings to refresh.
• Add the following JSON to .gemini/settings.json in C:/Users/Lenovo/.gemini:

{
  "mcpServers": {
    "my-persistent-memory": {
      "command": "C:/Users/Lenovo/Downloads/mcp_sql_project/venv/Scripts/python.exe",
      "args": ["C:/Users/Lenovo/Downloads/mcp_sql_project/server.py"],
      "env": {
        "PYTHONPATH": "C:/Users/Lenovo/Downloads/mcp_sql_project"
      }
    }
  }
}

Initialization

• Run the /init command in Gemini Code Assist to initialize the agent.
• Use the /mcp command in Gemini Code Assist to list all tools in the chat.

💻 Usage Examples

Testing the CRUD Cycle

• Create: Store a memory by running the prompt "Add key as project lead and content is Alex to db." (Uses store_memory).
• Read: Retrieve a memory by running the prompt "Who is my project lead?" (Uses retrieve_memory).
• Read All: Fetch all memories by running the prompt "List all memories" (Uses list_memories).
• Update: Update a memory by running the prompt "Actually, Alex left; update my project lead memory to say the lead is now Sarah." (Uses update_memory).
• Delete: Delete a memory by running the prompt "I'm done with the project lead info, you can delete that memory now." (Uses delete_memory).