Yii2 MCP Server

A Model Context Protocol (MCP) server for Yii2 framework, providing database schema inspection, console command execution, and project management tools for Claude Code.

Features

Database Tools

• db_list_tables: List all database tables with details (rows, size, comments)
• db_describe_table: Get detailed schema information for a specific table
• db_table_relationships: Analyze foreign key relationships
• db_execute_query: Execute SELECT queries safely with results

Database Optimization & Analysis (NEW)

• db_analyze_table: Comprehensive table analysis including fragmentation, index efficiency, and storage engine recommendations
• db_get_index_suggestions: Smart index recommendations based on table structure and query patterns
• db_profile_query: Query performance profiling with execution plans and optimization suggestions
• db_monitor_connections: Real-time database connection monitoring with alerting

Yii2 Console Tools

• yii_list_commands: List all available Yii console commands with descriptions
• yii_command_help: Get detailed help for specific commands
• yii_execute_command: Execute safe console commands (dangerous commands blocked)
• yii_list_migrations: Show migration status (applied and pending)

Model & Project Tools

• yii_list_models: List all ActiveRecord models with relationships
• yii_analyze_model: Analyze specific model classes
• project_structure: Get overview of project directory structure
• module_info: Detailed information about specific modules
• config_inspect: Inspect application configuration files

Advanced Module Analysis

• module_detailed_analysis: Comprehensive module analysis including controllers, models, assets, widgets, jobs, services, and traits
• asset_list_bundles: List all asset bundles with CSS/JS files and dependencies
• asset_analyze_dependencies: Analyze asset dependency chains and registration order
• widget_list: Discover widgets and their associated asset bundles

Migration Management

• migration_create: Create new database migrations
• migration_diff: Generate migrations from model/database differences
• migration_rollback: Rollback migrations safely
• migration_generate_from_model: Generate migrations from ActiveRecord models

Code Generation Tools

• generate_crud: Generate CRUD controllers and views
• generate_model: Generate ActiveRecord models from database tables
• generate_api: Generate REST API controllers
• generate_form: Generate form classes

Cache Management

• cache_clear: Clear application cache with options
• cache_inspect: Inspect cache configuration and status
• cache_performance: Analyze cache performance and hit rates

RBAC (Role-Based Access Control)

• rbac_permission_tree: Visualize permission hierarchy
• rbac_user_access: Check user permissions and access levels
• rbac_role_analysis: Analyze role assignments and permissions
• rbac_access_debug: Debug access control issues

Queue System Management

• queue_job_status: Monitor queue job status and progress
• queue_retry_failed: Retry failed queue jobs
• queue_worker_status: Check queue worker status
• queue_clear_failed: Clear failed jobs from queue

Logging & Debugging

• log_error_analysis: Analyze error logs and patterns
• log_performance_issues: Identify performance bottlenecks in logs
• log_search: Search through application logs
• log_tail: Real-time log monitoring

Advanced Database Analysis

• db_index_suggestions: Advanced index optimization recommendations
• db_query_profiler: Detailed query performance profiling
• db_table_analysis: In-depth table structure analysis
• db_connection_monitor: Real-time database connection monitoring

Testing & Quality Assurance

• test_run: Execute test suites
• test_generate: Generate test cases
• **test_c

... View full README on GitHub