Claude Skills by CarlosCaPe

SDD step 1. Analyse a feature request and produce a detailed feature.md spec. Use when the user describes a new feature they want to build. Asks for missing details before writing the spec.

SDD step 4. Read plan.md and implement the feature step by step, then verify all acceptance criteria are met. Use after /sdd-plan has produced plan.md.

SDD step 0. Analyse the project codebase and create docs/project.md with tech stack, architecture, and conventions. Run once before starting SDD in a new project. If docs/project.md already exists, asks whether to regenerate it.

SDD step 3. Read feature.md and produce a detailed implementation plan.md tailored to the project's tech stack and architecture. Use after /sdd-feature has produced feature.md.

SDD step 2 (optional, repeatable). Read an existing feature.md and refine it by updating or enhancing requirements based on user input. Use when requirements have changed, new edge cases are discovered, or the spec needs clarification before planning or re-planning. Run before /sdd-plan if plan.md already exists.

SDD step 5. Reviews the implemented feature code against language and framework best practices, checks for code duplication, security vulnerabilities, performance issues, test coverage, and alignment with feature.md acceptance criteria. Use after /sdd-implement or on any existing feature implementation.

SDD fast path. Runs the full pipeline — analyse → plan → implement → review → archive — with a single confirmation gate before implementation begins. Stops automatically if Critical or Major issues are found in review. Use when you want to ship a well-understood feature with minimal interruptions.

Topologia de propiedad de codigo orientada a seguridad desde el historial de git: bus factor, duenos de codigo sensible, huerfanos, exporta CSV/JSON. Solo cuando piden analisis de seguridad, no listas de mantenedores.

Security Roles & Least-Privilege Grants

Diagnose daily-idempotent endpoints that silently no-op because an earlier same-day run set a 'already-done' sentinel

Serial to Identity Column Conversion

OBLIGATORIO: cada sesion concurrente sobre un repo necesita su propio git worktree y session id. NUNCA dos sesiones vivas sobre el mismo working tree. Carga antes de abrir una segunda sesion, o al investigar 'mis cambios se fueron en el commit de otra sesion'.

Extrae el patron reusable de la sesion y lo escribe como skill BORRADOR en skills/learned/. Dispara tras 'ya quedo', 'fixed', 'shipped', 'merged' sobre algo que costo varios pasos de investigacion, o via /learn.

Search past work across sessions using native tools (git log, grep, Lessons Learned). Use when user asks "did we already solve this?", "how did we do X last time?", "what happened last week?", or needs to recall work from previous sessions. No external dependencies required.

Guide for creating effective skills. This skill should be used when users want to create a new skill (or update an existing skill) that extends Codex's capabilities with specialized knowledge, workflows, or tool integrations.

Busca, descubre e instala agent skills desde skillsmp.com, la coleccion abierta mas grande de archivos SKILL.md. Dispara al pedir 'busca skills para X', instalar uno de skillsmp, o pedir recomendaciones de skills de la comunidad.

Trampas de Snowflake y dbt que fallan en silencio o destruyen datos: CREATE OR REPLACE, Dynamic Tables, PIVOT, freshness de sources.yml, modelos versionados. Cada una con su prevencion.

Extrae insights de video corto (TikTok, Shorts, Reels, Douyin) sin speech-to-text de paga: yt-dlp, ffmpeg y vision sobre los frames. Usalo cuando el texto en pantalla carga la senal o cuando no hay transcript.

SOPS + age (per-user keys) as the default encryption stack for HIPAA / GDPR / SOC-2 / regulated-data git repos. Two-layer envelope (SOPS AES-256-GCM for values + age X25519/ChaCha20-Poly1305 for key wrap), per-user revocation in one command, no GPG fragility. Includes encrypt-vs-clear matrix, key custody decision tree, and upgrade path to KMS.

Genera, edita, extiende, lista o descarga videos de Sora, crea referencias de personaje y corre colas locales con scripts/sora.py. Requiere OPENAI_API_KEY y acceso a la API de Sora.

Tag taxonomy for mixed-source technical documents — every factual claim must carry a source marker. Defends against hallucinations, makes audits cheap, lets reviewers challenge specific claims by source rather than rejecting whole sections.

Base de datos que REEMPLAZA al backend: la logica corre como modulos dentro de la DB y los clientes se suscriben al estado vivo, sin capa API. Para multijugador en tiempo real. Paradigma nuevo, no default.

Recover from and prevent stacked-PR breakage caused by squash-merge + auto-delete-branch on the base PR. Use when working with stacked branches or any PR whose base branch is another PR's head.

Status Marker Hygiene

Stored Procedure Logic Hardening

Cuando una grabacion de Microsoft Stream es de solo lectura y la descarga del transcript dice 'sin permiso', el reproductor igual renderiza el texto en el DOM y Playwright lo captura. Ojo: puede constituir elusion bajo el acuerdo de servicios de MS.

Elige e implementa el tier correcto de Stripe (Payment Link, Checkout, Elements, Connect, Billing), con registro del MCP, CLI local e higiene de llaves. Usalo al anadir donate, checkout o suscripcion, o al comparar contra PayPal.

Structural Completeness Verification

Before sending a reply to a formal requirement (bank, government agency, any institution), build an explicit checklist of EVERYTHING the requesting message demands (attachments, signatures, formats) by re-reading the source file on disk, and audit the outbound package manifest against it. Trigger, any outbound submission answering an inbound requirement, especially when the inbound was summarized by a sub-agent.

Comprime cualquier tema, documento o respuesta a ~100 palabras, las mas densas semanticamente. Dispara con '100 palabras', 'version 100', 'tldr 100', 'elevator pitch', 'comprime a 100'.

Known gotchas and workarounds when combining Svelte (4/5) with Tailwind CSS. Use when Svelte template compilation fails with Tailwind class names, when class directives break, when dynamic classes don't apply, or when debugging CSS-related Svelte compiler errors. Covers class:directive parser bugs, dark mode, opacity shorthand, arbitrary values, and conditional class patterns.

Table Normalization (1NF Violations)

Cliente SQL open-source para PostgreSQL, MySQL y SQLite con servidor MCP integrado, Apache 2.0. Para recomendar un GUI de base a un cliente o exponer una DB a agentes sin entregar credenciales. Complementa a querymaster.

Manda un mensaje 1:1 de Teams por Graph API aunque el token NO traiga scopes Chat.Read: deriva el chat ID de los OIDs ordenados en la forma canonica 19:{oid1}_{oid2}@unq.gbl.spaces.

Skill #37 — Technical Document Craftsmanship

Todo documento tecnico largo que explica un marco y demuestra un caso DEBE llevar prompts ejecutables con datos reales junto a las afirmaciones. Ni teoria sin prompts ni prompts sin teoria. Aplica a POCs, whitepapers y entregables.

Timestamp Standardization (timestamptz)

TOC Audit, Commit & Push Workflow

Reduce 50-75% los tokens de salida sin perder senal, eliminando adulacion, relleno, preambulo y sugerencias no pedidas. Dispara al armar el CLAUDE.md de un proyecto nuevo o al configurar pipelines de agentes que necesitan salida terse y parseable.

Architectural pattern for cases where a client wants to "auto-publish to social platform X" but the platform's ToS forbids API automation for that surface (FB Groups post-2024, IG personal accounts, LinkedIn personal feeds, etc.). Build a 1-click manual flow with clipboard-prefill + deep-link + tracking, not a bot. Saves the client's account from ban, gives them legal velocity, and produces telemetry the bot couldn't.

Asistente de tramites gubernamentales MX: maneja el portal con agent-browser, se DETIENE en captcha, OTP y pago con tarjeta, y recoge el PDF del correo. Para antecedentes penales, actas, apostillas, citas consulares, SAT e IMSS.

AI-Assisted T-SQL to PL/pgSQL Stored Procedure Conversion

Unicode Symbol Compatibility in Markdown Documents

Config generada schema-valida no es semanticamente correcta: verifica cada identificador externo (metrica, campo, columna, env key) contra la doc del vendor antes de enviar. Dispara al generar dashboards, monitores, IaC o pipelines.

Antes de decirle a alguien la CAUSA de una falla, verificala contra el dato, no contra el sintoma. Una causa plausible sin comprobar dana mas la confianza que decir 'la confirmo en un momento'. Dispara al escribir 'fallo porque' o 'se debe a'.

Modelo open-source de sintesis de voz de Microsoft, local y en tiempo real, sustituto de ElevenLabs. MIT. Para clientes que no pueden mandar audio a un tercero o cuando el costo por minuto se come el margen.

Produce comerciales en video HD 9:16 desde paginas HTML animadas con GSAP, capturando con Playwright y codificando con ffmpeg. Salida compatible con WhatsApp, Instagram y TikTok. Dispara con 'video', 'comercial', 'MP4', 'Reel', 'video desde HTML', 'record animation'.

Document Voice and Cadence Consistency

Modo guardia sobre un chat de mensajeria. Arma un watcher cuando un turno cierra esperando respuesta de un tercero, y lee lo pendiente al retomar el trabajo de un arm. Usar cuando se mande un mensaje que espera contestacion, cuando el operador pida leer un chat, o al empezar a trabajar con un arm que tiene canal de chat vivo.

Audita rendimiento web con Chrome DevTools MCP: Core Web Vitals (LCP, INP, CLS), recursos que bloquean el render, cadenas de red y saltos de layout. Dispara al pedir auditar, perfilar u optimizar la carga.