Simplify MCP setup by publishing to PyPI and adding a console entry point

[VIEWVIEWVIEW]

Hi,

I really enjoy this MCP, however I found the setup to be more complicated than it should be. Most MCPs can be set up in agent tools (claude, codex etc) via a simple codex mcp add mariadb-mcp -- uxv mariadb-mcp. However, it is not published on the PyPi index and has no console entry point defined in pyproject.toml, so it's currently not possible to setup this project like this. I find it really cumbersome to clone the project via git for local usage and manually start the stdio server, especially for multiple projects.

I think this should be changed, but only the maintainers of this project are able to complete all tasks to do this, as it requires to set up a PyPi account, org and project.

Task list:

• rename the package from "mariadb-server" to "mariadb-mcp". Mariadb-server is not what this thing is, and I think "mariadb-mcp" would be more in line with current naming conventions of MCPs.

  mcp/pyproject.toml

  Line 2 in 3c533f6

  name = "mariadb-server"

• Add console entry point in pyproject.toml, so you can simply run uvx mariadb-mcp. Ex.: https://github.com/VIEWVIEWVIEW/mariadb-mcp/blob/afb3f2a9df70704d070e97b21b1eb85b1dc6ae29/pyproject.toml#L21-L22
• Add setuptools config to pyproject.toml, require for PyPi publish job Ex.: https://github.com/VIEWVIEWVIEW/mariadb-mcp/blob/afb3f2a9df70704d070e97b21b1eb85b1dc6ae29/pyproject.toml#L21-L26
• Setup project on a PyPi account and "trusted publisher" (https://docs.pypi.org/trusted-publishers/adding-a-publisher/) (Needs to be done by the maintainers, please)
• Setup a Github action for publishing on PyPi. Ex.: https://github.com/VIEWVIEWVIEW/mariadb-mcp/blob/main/.github/workflows/publish-pypi.yml
• Change README to prefer uvx mariadb-mcp
• Push version number in pyproject.toml
• Run job to publish

---

I already played around on how to do it it in the test environment test.pypi.org, my fork is here https://github.com/VIEWVIEWVIEW/mariadb-mcp and the PyPi package is here: https://test.pypi.org/project/mariadb-mcp/. I wrote it together with an LLM and reviewed+tested the code, but I'm not aware of guidelines of MariaDB about LLM generated code. (Maybe you don't like it or have fear of licensing stuff)