pro-skills-repo-administraktor

Design, build, secure, document, and maintain robust RESTful and GraphQL APIs. Use when architecting API resource endpoints, implementing authentication and authorization (JWT, OAuth 2.0, API keys, RBAC/ABAC), handling pagination, filtering, and caching, standardizing error formats (RFC 7807), enforcing rate limits, authoring OpenAPI/Swagger specs, designing webhooks, or configuring CORS and security headers.

Deploy, configure, and maintain web applications, static sites, and edge functions on Cloudflare Pages and Workers. Use when configuring wrangler.toml or wrangler.jsonc, managing _routes.json, _headers, and _redirects, binding storage (KV, D1, R2), debugging edge functions, or executing deployments with Wrangler CLI.

Establish authoritative codebase guidelines, boundaries, and project goals for AI coding agents. Use when onboarding AI agents to an existing or new repository, conducting an interactive diagnostic interview with the developer, and generating standardized instruction files (AGENTS.md, CLAUDE.md, .cursorrules / .mdc, and project goals).

Use when asked to generate or set up coding guidelines, detect my stack, generate AGENTS.md rules, create stack-specific conventions, set up agent guidelines, or configure coding guidelines for this repo on first use in a codebase. Deterministically detects tech stack layers, confirms with the user, generates tailored guidelines from modular references, and links them from AGENTS.md without overwriting user content. Excludes general code review, linter/formatter configuration, or CI pipeline setup.

Plan, produce, optimize, distribute, and measure high-impact content marketing campaigns across technical blogs, landing pages, email sequences, social platforms, developer communities, and open source repositories. Use when creating content strategies, writing technical blog posts or launch announcements, optimizing copy for conversions and SEO, planning content calendars, building developer relations and open source marketing collateral, repurposing assets across channels, executing outreach and distribution, or establishing analytics and A/B testing frameworks.

Use when a task risks running out of context window, when a long-running agent session or multi-step workflow must stay coherent across many turns, when token cost or latency climbs with conversation length, or when the user asks about compaction, summarizing conversation history, truncating tool output, KV-cache or prefix caching, cache-friendly prompt ordering, context budgets, or splitting work across sub-agents. Covers compaction, observation masking, cache-aware layout, and context partitioning, both for an agent managing its own session and for code that builds agent systems. Do not use for RAG retrieval design or vector database selection.

Design, optimize, migrate, and maintain relational and hybrid database systems across PostgreSQL, MySQL, MariaDB, and SQLite. Covers schema design, normalization and denormalization, indexing strategies, transactions (ACID), migration management, ORM integration (Prisma, Drizzle, Eloquent, SQLAlchemy), security, backups, connection pooling, and engine-specific optimizations.

Containerize applications, design multi-stage Dockerfiles, configure Docker Compose v2 stacks, optimize image layers and caching, manage networks, volumes, and secrets, and harden container security across PHP/WordPress, Node.js/Next.js, and Python environments.

Use when creating, modifying, debugging, or verifying FOSSBilling themes, Twig templates, cart & checkout workflows, ticket and invoice systems, API forms, or strict-mode Twig runtime behavior. Excludes core FOSSBilling PHP backend development or server infrastructure management.

Use when setting up, auditing, or modernizing GitHub Actions CI/CD workflows: automated testing, Docker image builds, Kubernetes deployments, security scanning, matrix builds, reusable workflows, and approval-gated production releases. Covers workflow architecture, secret handling, caching, permissions, and environment protection rules. Excludes GitLab CI, CircleCI, Jenkins, or other non-GitHub CI systems (see `gitlab-ci-patterns` for GitLab).

Develop, test, and architect production-grade Go (Golang) applications and microservices. Covers standard project layouts, Go modules, concurrency primitives, net/http servers, table-driven testing, slog logging, database access, error wrapping, generics, and CLI tooling.

Use when the user asks to optimize, speed up, tune, or make a Linux system faster — laptops, desktops, or servers. Analyzes hardware, kernel and boot parameters, memory/swap/zram, storage, services, GPU, desktop environment, and network; proposes a prioritized, risk-labeled optimization plan; applies ONLY user-approved changes; verifies every change and documents rollback. Idempotent: re-running on the same system converges, never duplicates config, never re-installs. Analyze-only mode is available. Do NOT use for application code, containers, or website performance.

Manage, validate, compile, and render MDX (Markdown + JSX) content in modern web applications. Use when building content pipelines, technical documentation, blogs, component mappings, syntax highlighting, Zod frontmatter validation, or RSS feeds.

Build, maintain, and optimize production-grade full-stack web applications using the Next.js App Router (versions 14, 15, and 16+). Covers architecture, React Server Components, Client Components, data fetching, caching, Server Actions, Route Handlers, middleware, performance optimization, and TypeScript configuration.

Manage Node.js package managers, dependencies, lockfiles, workspaces, scripts, and module ecosystems across npm, pnpm, yarn, and bun. Use when selecting or migrating package managers, diagnosing dependency conflicts or phantom dependencies, configuring monorepos and Turborepo, hardening package.json, resolving lockfile drift, auditing vulnerabilities, configuring ESM/CJS compatibility, or publishing packages.

Architect, build, test, refactor, and maintain modern PHP 8.0-8.4 applications, libraries, and APIs using strict typing, modern language features, PSR standards, Composer dependency management, PDO database access, PHPUnit/Pest testing, PHPStan/Psalm static analysis, and secure coding practices.

Provides modern Python development standards (3.10-3.13+), covering environment management (uv, venv, poetry), packaging (pyproject.toml, src layout), static typing (PEP 604, PEP 695), data modeling (dataclasses, Pydantic v2), async concurrency (asyncio, TaskGroup, httpx), error handling, pathlib, structured logging, CLI creation (typer, click, argparse), pytest testing, and ruff linting/formatting. Use when creating, refactoring, packaging, or testing Python projects.

Develop, refactor, and architect production React applications using TypeScript and modern React 18 and 19 patterns. Covers functional components, strict typing, concurrent features (Suspense, transitions), hooks, state management, performance optimization, form actions, error boundaries, testing, and architecture conventions.

Use whenever the user wants to create, rewrite, or improve a README.md for a GitHub/GitLab repo, project, library, CLI tool, app, or package. Trigger on "write me a README", "make a README for this repo", "improve my project's README", "make my repo/GitHub page look professional", or requests for repo docs, project landing content, or quickstart docs. Also trigger when the user pastes project details, a package.json/pyproject.toml, or a repo link and asks for docs. Interviews the user with targeted questions, offers 4 distinct visual/structural README designs to pick from, researches any related or inspirational projects named, and produces a polished, SEO-optimized, beginner-friendly README.md with a full table of contents, working anchor links, badges, and a real quickstart. Not for generic blog posts or non-repo documentation.