wsnowflake-mcp: Model Context Protocol Server for WSnowflake

wsnowflake-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 WSnowflake (Snowflake SQL 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.
• WSnowflake: Snowflake SQL ORM engine with 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 WSnowflake compatibility.
2. search_wsnowflake_pattern(query: str): Searches the official wisrovi SUITE catalog for WSnowflake architectural patterns.
3. deploy_wsnowflake_scaffolding(target_dir: str, project_name: str): Deploys project scaffolding.
4. get_wsnowflake_architect_blueprints(): Returns code reference and blueprints for WSnowflake features.
5. get_wsnowflake_architect_manual(): Returns the comprehensive WSnowflake architecting manual.
6. generate_wsnowflake_crud(model_code: str): Automatically generates repository CRUD class for Pydantic models.

Running Unit Tests & Coverage

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

Part of the wisrovi SUITE ecosystem.