wesleysmits/agent-skills
Overview
This skill analyzes database schemas and suggests practical improvements for Prisma, TypeORM, or Drizzle projects. It helps detect ORM tool usage, review models and relations, recommend DRY refactors, and generate TypeScript types or migration commands. Use it to improve performance, consistency, and maintainability of your database layer.
How this skill works
The skill detects which ORM is in use by scanning common config and source files, reads schema or entity definitions, and extracts models, fields, relationships, indexes, and enums. It identifies common issues (missing indexes, inconsistent naming, absent timestamps, duplicate field groups, N+1 risks) and produces targeted suggestions, DRY refactor patterns, and migration or type-generation commands.
When to use it
- You want a review of your database schema or entity definitions.
- You need migration recommendations or production-safe migration commands.
- You want TypeScript types generated or synchronized from your schema.
- You notice performance issues or suspect missing indexes or relations.
- You’re standardizing naming, timestamps, soft deletes, or audit fields.
Best practices
- Detect the ORM first (prisma, typeorm, drizzle) to run tool-specific checks.
- Enforce consistent naming (choose camelCase or snake_case across models).
- Add createdAt/updatedAt and consider deletedAt for soft deletes on most tables.
- Index foreign keys and frequently queried columns to avoid slow joins.
- Extract repeated fields into shared mixins/base entities for DRY code.
- Run schema validation and generate types after applying schema changes.
Example use cases
- Audit a Prisma schema.prisma and suggest indexes, enum changes, and migration commands.
- Convert repeated Drizzle column definitions into a shared timestamps/primaryId module.
- Create a TypeORM BaseEntity for common audit fields and update entities to extend it.
- Generate TypeScript models from Drizzle or Prisma schema for API DTOs.
- Analyze proposed schema changes and produce a Schema Change Analysis report with breaking-change notes.
FAQ
I scan typical config and source files: prisma/schema.prisma or package.json for Prisma, drizzle.config.* or package.json for Drizzle, and ormconfig/data-source or entity files for TypeORM.
Can you generate production-safe migration commands?
Yes. I recommend the appropriate migration commands for the detected ORM and highlight risks or required data migrations before applying them in production.
26 skills
This skill analyzes database schemas and suggests improvements for Prisma, TypeORM, or Drizzle, and can generate TypeScript types.
This skill creates high-converting landing page sections with headlines, CTAs, and social proof to boost conversions.
This skill generates structured YouTube video scripts with hooks, segments, CTAs, and B-roll notes to streamline production.
This skill helps you generate and update CI/CD configurations for GitHub Actions, GitLab CI, or CircleCI to streamline pipelines and deployments.
This skill helps identify WCAG 2.1 accessibility violations in components and pages, guiding remediation and validation for inclusive UI.
This skill generates WordPress Full Site Editing blocks and theme files, guiding block.json, theme.json, and PHP registrations for seamless FSE development.
This skill generates unit tests for changed files and identifies coverage gaps to improve reliability and maintainability.
This skill generates structured webinar slide decks with speaker notes, visuals, and engagement prompts to power compelling virtual events.
This skill enforces code quality by linting changed files with ESLint, Prettier, and stylelint, and suggesting or applying fixes.
This skill provides a single source of truth for brand guidelines, design tokens, voice, and tech choices to ensure consistent UI and copy.
This skill helps you conduct competitor content analysis, identify gaps, and craft differentiation angles with actionable plans.
This skill enforces design system consistency by identifying hardcoded colors and spacing, mapping violations to tokens, and suggesting token-based fixes.
This skill helps you extract, format, and tag customer testimonials for marketing, social proof, and quote cards across channels.
This skill creates comprehensive ebooks and lead magnets with structured chapters, design briefs, landing page copy, and email sequences to boost gated content
This skill helps you curate and repurpose customer photos, reviews, and testimonials into cohesive, brand-aligned UGC campaigns.
This skill generates SEO-optimized glossaries and definitions, organizing terms, examples, and related links for knowledge bases and terminology documentation.
This skill transforms a single content piece into multiple formats across platforms, maximizing reach and ROI.
This skill scaffolds marketplace integrations by generating boilerplate API clients, rate limiting, webhooks, and type-safe code for WooCommerce, Shopify,
This skill generates timestamped show notes, transcripts, and key takeaways from podcast episodes to streamline publishing and repurposing.
This skill scaffolds React and Next.js components with TypeScript, CSS modules, tests, and Storybook stories to accelerate development.
This skill formats commit messages following Conventional Commits, helping you generate clear, release-ready messages for staged changes.
This skill generates platform-specific social media captions with hashtags, hooks, and CTAs to boost engagement across Instagram, LinkedIn, Twitter, and TikTok.
This skill helps you create compelling product descriptions and optimize e-commerce listings by transforming features into benefits and engaging copy.
This skill generates SEO metadata including meta tags, Open Graph, Twitter cards, JSON-LD, and hreflang guidance to boost search visibility.
This skill helps you generate platform-specific ad copy for paid campaigns with A/B variants across Google, Facebook, LinkedIn, and more.
This skill helps you draft comprehensive long-form blog posts with SEO-ready structure, outlines, introductions, bodies, and conclusions.
