wmysql-mcp: Model Context Protocol Server for WMysql

wmysql-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 WMysql (MySQL 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.
• WMysql: MySQL 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 WMysql compatibility.
2. search_wmysql_pattern(query: str): Searches the official wisrovi SUITE catalog for WMysql architectural patterns.
3. deploy_wmysql_scaffolding(target_dir: str, project_name: str, scaffold_type: str): Deploys project scaffolding with repository, config, models, and tests.
4. get_wmysql_architect_blueprints(): Returns code reference and blueprints for WMysql features.
5. get_wmysql_architect_manual(): Returns the comprehensive WMysql architecting manual.
6. generate_wmysql_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.