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.

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.

Autonomous, safety-first pull request review-and-merge pass over a repository with many open PRs, on any tech stack (Node, PHP, Go, Python, Rust, Ruby, Java/Kotlin, Android, monorepos). Reviews each PR's full diff, classifies it CLEAN / FIXABLE / BLOCKED, fixes small issues, merges safe PRs one at a time, verifies the default branch still builds and passes tests, and produces a final report. Use this skill whenever the user mentions a backlog of pull requests, asks to review and merge PRs, clear the PR queue, "merge what's safe", check that nothing breaks after merging, or hands PR handling to an agent while they are away, even if they don't say "skill" or name a specific stack. Supports "review only" / "dry run" mode.

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.

Audits, hardens, and remediates security vulnerabilities across web applications, APIs, and server environments. Use when implementing OWASP Top 10 defenses, HTTP security headers (CSP, HSTS), input validation, parameterized queries, authentication and session security, secrets management, file upload safety, rate limiting, dependency auditing, or baseline Linux server hardening.

Audit or improve SEO, AEO (answer engine optimization), GEO (generative engine optimization), and AI search visibility in websites and codebases. Use for crawl/indexing problems, crawl budget, indexability, metadata, canonical tags, hreflang, robots.txt, sitemaps, structured data, schema.org markup, Core Web Vitals, rendering, search performance, or AI search citations. Also covers content audits, technical SEO remediation, and answer-engine readiness. Supports codebase-only, website-only, audit, implementation, and continuation requests with evidence-backed findings and verified fixes.