Unclear docs re: running server in sse mode

[gakowalski]

Docs state that all you have to do to run the server is:

python server.py

...but without any info that it starts the server in stdio mode.

To run in sse mode you have to:

python src/server.py --transport sse

Then this part of docs works as intended inside the IDE:

{
  "servers": {
    "mariadb-mcp-server": {
      "url": "http://{host}:9001/sse",
      "type": "sse"
    }
  }
}

[Utkarsh-P-07]

Hi! I'm interested in working on this issue.

I'd like to update the docs to better explain how to run the server in both stdio and sse modes. My plan is to:

• Show the exact commands/flags for each mode
• Explain when you'd use sse vs stdio
• Add a small example for running in sse mode

Does this sound okay, or is there anything specific you'd like me to cover?