database-query-profiler

roach Marketplace

Private Claude Code plugin marketplace.

Background

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.

Included Plugins

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

Installation

Prerequisites

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

Add the marketplace

/plugin
# Select "Add Marketplace"
# Enter: https://github.com/stefanfaur/roach-marketplace.git

Enable plugins

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.

Install required CLI tools

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

Configure JetBrains MCP (recommended)

If you use a JetBrains IDE (IntelliJ, WebStorm, PyCharm, etc.):

1. Open your JetBrains IDE
2. Go to Settings > Tools > MCP Server
3. Check Enable MCP Server
4. In the Clients Auto-Configuration section, click Auto-Configure next to Claude Code
5. Restart Claude Code

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.

Team Distribution

Add this to your project's .claude/settings.json to auto-prompt teammates:

{
  "extraKnownMarketplaces": {
    "roach-marketplace": {
      "source": {
        "source": "github",
        "repo": "stefanfaur/roach-marketplace"
      }
    }
  }
}

What Each Plugin Does

roach

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.

Skills