code-analyze

• [Features](#features)
• [Installation](#installation)
• [Available Skills](#available-skills)

- [Database & Backend](#database--backend)

- [.NET Development](#net-development)

- [Frontend & Design](#frontend--design)

- [DevOps & Tools](#devops--tools)

- [Documentation & Analysis](#documentation--analysis)

• [Usage](#usage)
• [Skill Details](#skill-details)
• [Contributing](#contributing)
• [License](#license)

• 21+ Specialized Skills: Production-ready skills covering full-stack development
• Multi-Language Support: C#, SQL, JavaScript/TypeScript, and more
• Best Practices Built-in: Each skill embeds industry best practices and patterns
• Reference Documentation: Comprehensive guides and examples included
• MCP Integration: Seamless integration with Model Context Protocol servers

Prerequisites

• Claude Code CLI installed
• Claude Code plugin system enabled

Quick Start

1. Clone the repository:

```bash

git clone https://github.com/your-username/icartsh-plugin.git

cd icartsh-plugin

```

1. Register with Claude Code marketplace:

```bash

# The plugin is automatically detected from .claude-plugin/marketplace.json

```

1. Start using skills in your Claude Code sessions:

```bash

# Skills are available with the icartsh-plugin: prefix

```

Database & Backend

| Skill | Description |

|-------|-------------|

| sql-expert | Expert SQL query writing, optimization, and schema design for PostgreSQL, MySQL, SQLite, and SQL Server |

| api-designer | Design and document RESTful and GraphQL APIs with OpenAPI/Swagger specifications |

.NET Development

| Skill | Description |

|-------|-------------|

| csharp-developer | Modern .NET development with C# 12+, ASP.NET Core, Blazor, and cloud-native patterns |

| csharp-async-patterns | Async/await patterns including Task, ValueTask, async streams, and cancellation |

| coding-conventions | .NET/C# coding standards, naming rules, and C# 12/13/14 feature guidelines |

| dotnet-build | Build .NET solutions using dotnet CLI |

| dotnet-test | Run .NET tests with coverage reports and benchmarks |

| code-analyze | Static analysis, security scans, and dependency checks for .NET |

| code-format | Format code using dotnet format, prettier, and other tools |

Frontend & Design

| Skill | Description |

|-------|-------------|

| frontend-design | Create distinctive, production-grade frontend interfaces with high design quality |

| webapp-testing | Test local web applications using Playwright |

| web-artifacts-builder | Build multi-component Claude.ai HTML artifacts with React, Tailwind CSS, and shadcn/ui |

DevOps & Tools

| Skill | Description |

|-------|-------------|

| docker-workflow | Docker containerization with multi-stage builds and docker-compose orchestration |

| git-advanced | Advanced Git operations including rebasing, conflict resolution, and branch strategies |

| mcp-builder | Guide for creating MCP (Model Context Protocol) servers |

| skill-creator | Guide for creating effective Claude Code skills |

Documentation & Analysis

| Skill | Description |

|-------|-------------|

| markdown-pro | Professional Markdown documentation for READMEs, changelogs, and technical docs |

| error-detective | Systematic debugging using the TRACE framework |

| code-reviewer | Automated code review with security scanning and quality metrics |

| sequential-thinking | Structured problem-solving for complex multi-step analysis |

Invoking a Skill

Skills can be invoked using the icartsh-plugin: prefix:

```

Use the sql-expert skill to optimize this query

```

Or reference the skill directly:

```

@icartsh-plugin:sql-expert Help me design a database schema for an e-commerce platform

```

Example Workflows

Database Design:

```

1. Use sql-expert to design the schema
2. Use api-designer to create the REST API specification
3. Use csharp-developer to implement the backend

```

Code Quality:

```

1. Use code-analyze to run static analysis
2. Use code-reviewer to review changes
3. Use code-format to enforce style consistency

```

Documentation:

```

1. Use markdown-pro to create README and documentation
2. Use error-detective for troubleshooting guides

```

sql-expert

Expert guidance for writing, optimizing, and managing SQL databases.

Capabilities:

• Write complex SQL queries with JOINs, subqueries, CTEs, and window functions
• Optimize slow queries using EXPLAIN plans
• Design database schemas with proper normalization (1NF, 2NF, 3NF, BCNF)
• Create effective indexes for query performance
• Write safe database migrations with rollback support

Supported Databases:

• PostgreSQL
• MySQL/MariaDB
• SQLite
• SQL Server

csharp-developer

Senior-level C# development expertise for modern .NET applications.

Capabilities:

• ASP.NET Core with Minimal APIs and Blazor
• Entity Framework Core optimization
• Clean Architecture and CQRS patterns
• Cloud-native development with Azure integration
• Performance optimization with Span, Memory, and AOT compilation

frontend-design

Create distinctive, production-grade frontend interfaces.

Design Focus:

• Bold typography with unique font choices
• Cohesive color themes with CSS variables
• Motion and micro-interactions
• Unexpected layouts with asymmetry and creative composition
• Rich backgrounds and visual details

sequential-thinking

Structured problem-solving through reflective thinking.

Use Cases:

• Breaking down complex problems
• Multi-step analysis with course correction
• Hypothesis generation and verification
• Planning and design with revision capability

```

icartsh-plugin/

├── .claude-plugin/

│ └── plugin.json # Plugin configuration

├── skills/

│ ├── sql-expert/ # SQL expertise skill

│ │ ├── SKILL.md

│ │ ├── README.md

│ │ ├── references/ # Optimization guides, best practices

│ │ └── examples/ # Query examples

│ ├── csharp-developer/ # C# development skill

│ ├── frontend-design/ # UI/UX design skill

│ ├── docker-workflow/ # Docker containerization

│ ├── git-advanced/ # Advanced Git operations

│ ├── markdown-pro/ # Documentation skill

│ └── ... # Additional skills

└── README.md

```

We welcome contributions! Here's how to get started:

Adding a New Skill

1. Create a new directory under skills/
2. Add a SKILL.md with frontmatter:

```yaml

---

name: your-skill-name

description: "Brief description of the skill"

---

```

1. Include comprehensive documentation and examples
2. Submit a pull request

Improving Existing Skills

1. Fork the repository
2. Create a feature branch (git checkout -b feature/improve-sql-expert)
3. Make your changes with clear commit messages
4. Push to the branch (git push origin feature/improve-sql-expert)
5. Open a Pull Request

Guidelines

• Follow existing skill structure patterns
• Include practical examples and references
• Test skills thoroughly before submitting
• Document any new dependencies or requirements

This project is licensed under the MIT License - see the [LICENSE](LICENSE) file for details.

• Built for [Claude Code](https://claude.ai) by Anthropic
• Inspired by the Claude Co