wmariadb-mcp: Model Context Protocol Server for WMariaDB

wmariadb-mcp is an official Model Context Protocol (MCP) server built on top of FastMCP that equips AI agents with tools to architect, validate, scaffold, and generate code for WMariaDB (MariaDB ORM using Pydantic models).

Key Technologies & Libraries

• MCP Protocol: Open standard connecting AI models to external tools and context.
• FastMCP: Python framework for fast MCP server implementation.
• WMariaDB: MariaDB ORM engine with multi-table management, forensic audit trails, and Pydantic validation.
• Pydantic v2: Data schema validation and Python AST inspection.
• Pytest: Modern Python testing framework.
• Pytest-Cov: Code coverage measurement for pytest.
• Docker: Containerized test execution environment.

MCP Tools Exposed

1. validate_model_schema(model_code: str): Validates Pydantic document models for WMariaDB compatibility.
2. search_wmariadb_pattern(query: str): Searches the official wisrovi SUITE catalog for WMariaDB architectural patterns.
3. deploy_wmariadb_scaffolding(target_dir: str, project_name: str, scaffold_type: str): Deploys project scaffolding with repository, config, models, and tests.
4. get_wmariadb_architect_blueprints(): Returns code reference and blueprints for WMariaDB features.
5. get_wmariadb_architect_manual(): Returns the comprehensive WMariaDB architecting manual.
6. generate_wmariadb_crud(model_code: str): Automatically generates repository CRUD class for Pydantic models.

Running Unit Tests & Coverage

Local Pytest Execution

pip install -e .
PYTHONPATH=src pytest tests/
./scripts/run_coverage.sh

Docker Containerized Test Execution

./scripts/run_tests_docker.sh

Part of the wisrovi SUITE ecosystem.