Transform Sybase IQ DDL (views, tables, stored procedures) into production-quality dbt models

Transform Teradata DDL (views, tables, stored procedures) into production-quality dbt models

Define and enforce validation rules for dbt models during migration. This skill provides

Transform Vertica DDL (views, tables, stored procedures) into production-quality dbt models

Guide AI agents through the complete migration lifecycle from Snowflake or legacy database systems

Analyzes and refactors code using Domain-Driven Design principles. Use when refactoring domain models, identifying DDD anti-patterns, improving domain clarity, or applying tactical/strategic DDD patterns.

Follow a safe, repeatable workflow to find duplicated code, extract shared helpers, and reduce maintenance burden while preserving behavior.

Identify and remove unused code, commented blocks, unreachable code, and unused imports. This skill should be used during Phase 1 cleanup tasks to improve codebase maintainability.

Detects and safely removes unused code (imports, functions, classes)

Use when the user asks to design or refactor a declaration contract, such as a function signature, type shape, schema, or generic parameter list, and wants guidance on grouping, named vs positional elements, and stable ordering.

Analyzes development sessions to extract patterns, preferences, and learnings. Use after significant work sessions to capture insights, document system understanding, and improve future interactions.

Analyzes conversation history to improve job instructions and capture learnings. Use after running a job to refine it.

Development workflow for features, bugs, refactoring. Auto-activates for multi-file implementations.

Validate at every layer data passes through to make bugs impossible. Use when invalid data causes failures deep in execution, requiring validation at multiple system layers.

<!-- PM-Skills | https://github.com/product-on-purpose/pm-skills | Apache 2.0 -->

Modern TypeScript patterns and migration guidance for Deno: resource management with 'using', async generators, error handling, and Web Standard APIs. Use when migrating from Node.js, implementing cleanup logic, or learning modern JS/TS patterns.

Migrate Deno projects to Bun with API compatibility analysis. Use when converting Deno.* APIs to Bun equivalents, migrating from Deno Deploy, or updating permissions model and import maps.

Safely update dependencies with version analysis, breaking change detection, and rollback planning

Assist with deployment workflow to production. Run pre-deploy checks, verify migrations, and validate deployment readiness. Use when deploying, releasing, pushing to production, or preparing a release.

Pre-deployment validation with environment config, dependencies, DB migrations, and API compatibility checks

Deploy migrations to production safely using migrate deploy in CI/CD. Use when setting up production deployment pipelines.

Safe deployment rollback with health checks and database migration reversal

Validate release readiness through comprehensive pre-deployment checks. Use before deploying schedules, features, or infrastructure changes to production.

Handles deprecated APIs, types, and modules by applying safe migration patterns. Use when encountering deprecation warnings, migrating from deprecated code, updating dependencies with breaking changes, or modernizing legacy code to use current APIs.

Comprehensive guide to API deprecation processes, sunset timelines, communication strategies, and graceful migration paths

Distinction between laws (invariants) and style (conventions). Load when determining if a constraint is a law or style.

- Generate a real-time Markdown dashboard of component compliance.

design-improvement

Go design patterns and refactoring skill. Use when refactoring complex code, reducing technical debt, or applying design patterns. Detects code smells and suggests pattern-based solutions.

UI/UX design system for dashboards, admin panels, SaaS interfaces, and web apps. Stack: React, Tailwind, CSS, styled-components. Capabilities: spacing systems (4px grid), color palettes, typography hierarchy, shadows/elevation, card layouts, dark mode, component styling. Actions: design, style, beautify, fix, improve, refactor UI components. Keywords: ugly, inconsistent, cluttered, unprofessional, spacing, padding, margin, colors, fonts, shadows, cards, buttons, forms, navigation, sidebar, layout. Use when: building new UI, fixing ugly interfaces, making things look professional/modern/clean, implementing design systems, styling components, choosing colors/fonts/spacing.

Remove historical cruft from design docs. Use when docs accumulate outdated content, after major refactorings, or when preparing for releases.

Build or update frontend components and pages that strictly adhere to the project design system defined in design/design-system.json (and design/design.json when present).

Master skill for Backend Integration (Supabase) and API handling. Covers database schema, authentication, and SQL.

ring:dev-feedback-loop

FIX ESLint errors safely without breaking code. Prefix unused variables with `_`, fix no-case-declarations, add default props, and verify builds after each batch. Use when lint cleanup is needed for easier refactoring & faster Claude Code editing.

OPTIMIZE slow Vue applications, fix memory leaks, and improve render performance. Reduce unnecessary re-renders, optimize computed properties, and fix expensive operations. Use when application feels slow, memory usage grows, or animations lag.

Analyzes codebase against standards and generates refactoring tasks for ring:dev-cycle.

Complete backlog implementation in feature-driven development. Read backlog requirements, reference implemented features, design approach, implement code, and document. Use when implementing features, changes, bug fixes, or improvements.

Developer tools for The Fold - protocols (extensible dispatch), protocol bundles, refactoring toolkit (rename, move, dead code), and template DSL. Use when defining new protocols, refactoring code, or generating S-expressions.

Use this skill when developing Next.js 16 applications - creating pages, components, layouts, API routes, implementing proxy.ts, adding caching with Cache Components, or refactoring frontend code. This includes working with App Router patterns, Server Components, Server Actions, React 19.2 features, and Tailwind CSS v4.

Laravel framework patterns for PHP applications including Eloquent ORM, migrations, routing, queues, and Blade templates. Use when building Laravel applications or working with Laravel projects.

Development standards and best practices. Use when development standards guidance is required.

Manages PostgreSQL database operations including Alembic migrations (creation, application, rollback), database backups and restoration for both development and production environments, shell access, and pgvector extension management. This skill should be used when creating schema changes, running migrations, backing up data, or troubleshooting database issues.

AI-powered ranking of Dex system improvement ideas

Enable Obsidian integration and migrate existing vault to wiki links

Use for structured technical SEO audits, incident response, and validation.

Type-safe Rust ORM with compile-time query validation.

Reorganize any repository by discipline/domain with module-based

Use when the user asks for a deep codebase analysis to identify and rank improvements, optimizations, architectural enhancements, or potential bugs aligned to developer, end-user, and agent jobs-to-be-done.

Discovery-first development workflow. Use BEFORE creating worktrees for any non-trivial feature. Explores requirements through questions, proposes approaches, validates design incrementally, and generates implementation plans with verification commands.