Skill UI

Generates production-ready stored procedures, functions, and triggers for PostgreSQL, MySQL, or SQL Server by analyzing requirements, using the stored-procedure-generator plugin, and returning optimized SQL code for complex logic, integrity, and transaction safety.

This guide provides comprehensive techniques to optimize LangChain applications for production environments. Learn how to measure baseline latency, implement efficient caching strategies (in-memory, Redis, SQLite), utilize batch processing with concurrency control, and maximize perceived speed through streaming. Furthermore, it covers prompt optimization and strategic model selection to ensure high throughput and low costs.

A specialized security auditor for Laravel applications. It analyzes code, APIs, and configurations against OWASP standards to detect vulnerabilities such as XSS, IDOR, SQL injection, and misconfigurations. Ideal for reviewing backend logic to ensure robust data protection and authorization.

Manages database schema migrations by generating timestamped up/down scripts for PostgreSQL, MySQL, SQLite, or MongoDB, letting you create, apply, or rollback changes safely when handling schema updates.

Automates designing and implementing table partitioning strategies to keep large databases performant, optimize time-series workloads, and shorten maintenance windows, with guidance on key selection, SQL scripts, and query tuning.

Automates database replication tasks with the database-replication-manager plugin, covering setup, failover, lag monitoring, and read scaling for PostgreSQL/MySQL clusters.

This comprehensive skill manages the entire lifecycle of database testing, ensuring data integrity and system reliability. It covers setting up isolated test environments (using Docker or in-memory databases), executing migrations, and implementing robust test isolation strategies (such as transaction rollback). Use cases include verifying CRUD operations, validating referential constraints, performance benchmarking (EXPLAIN ANALYZE), and ensuring backward compatibility across multiple databases (PostgreSQL, MySQL, MongoDB) and ORMs.

Mastery of modern mobile development across multiple platforms, including React Native, Flutter, and native iOS/Android. Expertise covers the entire lifecycle, specializing in architectural patterns (Clean, MVVM), performance optimization, offline-first data synchronization (GraphQL, SQLite), advanced DevOps practices (CI/CD, Fastlane), and App Store Optimization (ASO). Ideal for building robust, scalable, and highly performant cross-platform applications.

This skill provides comprehensive guidance for building scalable, maintainable, and production-ready backend applications using Node.js. It covers modern architectural patterns, best practices, and implementation details for REST APIs, GraphQL servers, microservices, authentication, real-time WebSockets, and complex database integrations (SQL/NoSQL).

Analyzes SQL statements, identifies bottlenecks, suggests indexes and rewrites, and leverages the sql-query-optimizer plugin so you can improve database responsiveness when queries run slowly.

Enables Claude to run a security-focused code review via the security-agent plugin, flagging SQL injection, XSS, authentication flaws, and unsafe dependencies with severity, location, impact, and remediation guidance for requested audits.

Automates vulnerability scans for applications and APIs via the security-test-scanner plugin, covering OWASP Top 10, SQL injection, XSS, CSRF, authentication, and authorization weaknesses while generating detailed remediation reports.