MCP-XAMP

MCP server that gives Claude Code and OpenCode direct access to your XAMPP MariaDB/MySQL databases. Five tools: list databases, list tables, describe table, read query, write query.

Quick Start

1. Clone the repo
2. Configure your AI agent (Claude Code or OpenCode)
3. Start querying — list_databases, read_query, etc.

No global install needed — runs directly with uv run.

---

Requirements

• Python 3.13+
• XAMPP with MariaDB/MySQL running on localhost:3306
• uv

---

Installation

git clone https://github.com/<user>/mcp-xamp.git
cd mcp-xamp
uv sync

Verify it works:

uv run mcp-xamp

Optional: install globally

If you prefer mcp-xamp available as a command anywhere:

uv tool install --python 3.13 .

Then use "command": "mcp-xamp" instead of uv run --directory ... in the configs below.

---

Claude Code Setup

Option A: global install (recomendado)

Instala mcp-xamp como comando global y registralo en Claude Code:

uv tool install --python 3.13 .

Luego agregá el server MCP. Elegí el scope que prefieras:

# Scope project (crea .mcp.json en el directorio actual)
claude mcp add xamp \
  -e MCP_XAMP_HOST=localhost \
  -e MCP_XAMP_PORT=3306 \
  -e MCP_XAMP_USER=root \
  -e MCP_XAMP_PASSWORD= \
  -e MCP_XAMP_ALLOW_WRITE=true \
  -- mcp-xamp

# Scope user (disponible en todos tus proyectos)
claude mcp add --scope user xamp \
  -e MCP_XAMP_HOST=localhost \
  -e MCP_XAMP_PORT=3306 \
  -e MCP_XAMP_USER=root \
  -e MCP_XAMP_PASSWORD= \
  -e MCP_XAMP_ALLOW_WRITE=true \
  -- mcp-xamp

Ajusta los valores de las variables según tu instalacion de XAMPP.

Option B: sin instalar (usando uv run)

Si preferis no instalar globalmente, apunta al directorio del repo:

claude mcp add xamp \
  -e MCP_XAMP_HOST=localhost \
  -e MCP_XAMP_PORT=3306 \
  -e MCP_XAMP_USER=root \
  -e MCP_XAMP_PASSWORD= \
  -e MCP_XAMP_ALLOW_WRITE=true \
  -- uv run --directory /ruta/a/mcp-xamp mcp-xamp

Reemplaza /ruta/a/mcp-xamp con la ruta real donde clonaste el repo.

Config manual (archivo .mcp.json)

Si preferis editar el archivo a mano, tambien funciona:

{
  "mcpServers": {
    "xamp": {
      "command": "mcp-xamp",
      "args": [],
      "env": {
        "MCP_XAMP_HOST": "localhost",
        "MCP_XAMP_PORT": "3306",
        "MCP_XAMP_USER": "root",
        "MCP_XAMP_PASSWORD": "",
        "MCP_XAMP_ALLOW_WRITE": "true"
      }
    }
  }
}

Si no instalaste globalmente, usa "command": "uv" con los args correspondientes (ver el .mcp.json de este repo como referencia).

Verify

Dentro de Claude Code, corre /mcp para confirmar que xamp aparece como conectado. Despues proba:

List all databases on my XAMPP server.

---

OpenCode Setup

Config location

OpenCode reads MCP config from opencode.json or opencode.jsonc. The file can be in:

Location	Scope
<project-root>/opencode.json	Project-specific
<project-root>/.opencode/opencode.json	Project-specific (alt)
~/.config/opencode/opencode.json	Global (all projects)

Add the MCP server

Add this block to your opencode.json or opencode.jsonc:

{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "xamp": {
      "type": "local",
      "command": ["uv", "run", "--directory", "/path/to/mcp-xamp", "mcp-xamp"],
      "enabled": true,
      "environment": {
        "MCP_XAMP_ALLOW_WRITE": "true"
      }
    }
  }
}

Replace /path/to/mcp-xamp with your actual clone path.

If you used uv tool install, simplify to:

{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "xamp": {
      "type": "local",
      "command": ["mcp-xamp"],
      "enabled": true,
      "environment": {
        "MCP_XAMP_ALLOW_WRITE": "true"
      }
    }
  }
}

Verify

Restart OpenCode, then try:

Show me all databases on the xamp server. use xamp tools

---

Environment Variables

All configuration goes through environment variables. Sensible defaults for a standard XAMPP installation.

Variable	Default	Description
MCP_XAMP_HOST	127.0.0.1	MariaDB/MySQL host
MCP_XAMP_PORT	3306	MariaDB/MySQL port
MCP_XAMP_USER	root	Database user
MCP_XAMP_PASSWORD	(empty)	Database password
MCP_XAMP_ALLOW_WRITE	false	Set to true to enable INSERT/UPDATE/DELETE/DDL

Credentials are read from environment variables only. They never appear in tool arguments, log output, or error messages.

---

Tools

Tool	Description	Requires
list_databases	Show all accessible databases	—
list_tables	Show tables in a database	database
describe_table	Show columns, types, and keys	database, table
read_query	Execute SELECT / SHOW / DESCRIBE / EXPLAIN	database, query
write_query	Execute INSERT / UPDATE / DELETE / DDL	database, query, MCP_XAMP_ALLOW_WRITE=true

---

Security

• Read-only by default. Write operations require MCP_XAMP_ALLOW_WRITE=true.

• Credentials never logged. Host, port, user, and password are stripped from error messages.

• Credentials only from env vars. No tool parameters, no config files, no CLI args.

• Connection-per-query. Each tool invocation opens and closes its own connection — no shared state, no stale connections.

• XAMPP default is root with no password. Create a dedicated user for production use:

  CREATE USER 'mcp_agent'@'127.0.0.1' IDENTIFIED BY 'secure_password';
  GRANT SELECT ON *.* TO 'mcp_agent'@'127.0.0.1';
  

---

Development

# Install dev dependencies
uv sync --group dev

# Run tests
uv run pytest -v --cov=src/mcp_xamp

# Lint
uv run ruff check src/ tests/

# Format
uv run ruff format src/ tests/

---

License

MIT — see LICENSE.