MariaDB MCP server integration with comprehensive best practices for schema design, indexing, query optimization, Hibernate/QueryDSL, and operations
Own this plugin?
Verify ownership to unlock analytics, metadata editing, and a verified badge. GitHub access is read-only (username + org membership).
Sign in to claimOwn this plugin?
Verify ownership to unlock analytics, metadata editing, and a verified badge. GitHub access is read-only (username + org membership).
Sign in to claimBased on adoption, maintenance, documentation, and repository signals. Not a security audit or endorsement.
Private Claude Code plugin marketplace.
The core plugins — roach, preroach, and agent-browser — derive from the Claude Code configurations of HumanLayer and obra/superpowers, restructured into a unified plugin with domain-scoped artifact storage (thoughts/shared/{plans|research|handoffs}/<domain>/).
The marketplace also includes community-contributed plugins from Jeremy Longshore for CI/CD, Ansible, Docker Compose, and database query profiling.
| Plugin | Author | Description |
|---|---|---|
| roach | Stefan Faur | Research-first methodology with skills-first enforcement |
| preroach | Stefan Faur | Legacy plan-centric workflow skills (creating, implementing, validating, iterating plans) |
| agent-browser | Stefan Faur | Browser automation with workflow persistence (requires agent-browser CLI) |
| mariadb-mcp | Stefan Faur | MariaDB MCP server integration with automated setup and database best practices |
| ci-cd-pipeline-builder | Jeremy Longshore | Build CI/CD pipelines for GitHub Actions, Gitea, GitLab CI, Jenkins |
| ansible-playbook-creator | Jeremy Longshore | Create and validate Ansible playbooks |
| docker-compose-generator | Jeremy Longshore | Generate Docker Compose files with validation |
| database-query-profiler | Jeremy Longshore | Profile and optimize database queries |
1. Install and authenticate the GitHub CLI:
| Platform | Command |
|---|---|
| macOS | brew install gh |
| Linux | See gh installation docs |
| Windows | winget install GitHub.cli or choco install gh |
# All platforms — log in and select HTTPS when prompted
gh auth login
gh auth status
2. Verify access to this repository:
gh repo view stefanfaur/roach-marketplace --json name
/plugin
# Select "Add Marketplace"
# Enter: https://github.com/stefanfaur/roach-marketplace.git
After adding the marketplace, enable the plugins you want. Available plugins: roach, preroach, agent-browser, mariadb-mcp, ci-cd-pipeline-builder, ansible-playbook-creator, docker-compose-generator, database-query-profiler.
ripgrep (required — used by Claude Code for codebase searching):
| Platform | Command |
|---|---|
| macOS | brew install ripgrep |
| Linux | apt install ripgrep or cargo install ripgrep |
| Windows | winget install BurntSushi.ripgrep.MSVC or choco install ripgrep |
agent-browser (recommended — enables browser automation):
# All platforms (requires Node.js)
npm install -g agent-browser
agent-browser install
If you use a JetBrains IDE (IntelliJ, WebStorm, PyCharm, etc.):
roach detects JetBrains MCP availability at session start and tells the agent whether to use JetBrains tools or fall back to built-in tools.
roach warns at session start if any companion is missing.
Add this to your project's .claude/settings.json to auto-prompt teammates:
{
"extraKnownMarketplaces": {
"roach-marketplace": {
"source": {
"source": "github",
"repo": "stefanfaur/roach-marketplace"
}
}
}
}
The core plugin. Derived from obra/superpowers and HumanLayer's Claude Code configurations, restructured into a single plugin with domain-scoped artifact storage (thoughts/shared/{plans|research|handoffs}/<domain>/).
A SessionStart hook injects the foundational skill into every session, forcing Claude to check for applicable skills before responding. A PostToolUse hook monitors context window usage after every tool call and warns when remaining context drops below 35% (warning) or 25% (critical), prompting handoff creation before context runs out.
npx claudepluginhub stefanfaur/roach-marketplace --plugin mariadb-mcpUnified workflow plugin combining research-first methodology with skills-first enforcement for Claude Code
stefanfaurBuild CI/CD pipelines for GitHub Actions, Gitea Actions, GitLab CI, Jenkins, and more
stefanfaurCreate Ansible playbooks for configuration management
stefanfaurGenerate Docker Compose and Podman Compose configurations for multi-container applications with best practices
stefanfaurProfile and optimize database queries for performance
stefanfaurComplete AI coding workflow system. Self-correcting memory + persistent FTS5-indexed research wikis + auto-research loop + multi-LLM council on a single SQLite store. 33 skills, 8 agents, 22 commands, 37 hook scripts across 24 events. Cross-agent via SkillKit.
rohitg00Open-source, local-first Claude Code plugin for token reduction, context compression, and cost optimization using hybrid RAG retrieval (BM25 + vector search), reranking, AST-aware chunking, and compact context packets.
Madhan230205Comprehensive skill pack with 66 specialized skills for full-stack developers: 12 language experts (Python, TypeScript, Go, Rust, C++, Swift, Kotlin, C#, PHP, Java, SQL, JavaScript), 10 backend frameworks, 6 frontend/mobile, plus infrastructure, DevOps, security, and testing. Features progressive disclosure architecture for 50% faster loading.
JeffallanIntelligent draw.io diagramming plugin with AI-powered diagram generation, multi-platform embedding (GitHub, Confluence, Azure DevOps, Notion, Teams, Harness), conditional formatting, live data binding, and MCP server integration for programmatic diagram creation and management.
markus41TypeScript/JavaScript full-stack development with NestJS, React, and React Native
giuseppe-trisciuoglioGive your AI a memory — mine projects and conversations into a searchable palace. 33 MCP tools, auto-save hooks, and guided setup.
MemPalace