Skill UI

Offers automated guidance for database query profiler tasks in performance testing, including best practices, code/config generation, and validation when working with load/stress benchmarking.

A comprehensive, end-to-end workflow bundle guiding developers through the entire software development lifecycle. It covers project scaffolding, frontend development (React/Next.js), robust backend architecture, database design, rigorous testing (TDD, E2E), code quality review, and modern CI/CD deployment practices for web and mobile applications.

Scans Android APKs for Firebase misconfigurations, testing databases, storage, authentication, and cloud functions to surface vulnerabilities during mobile security audits.

This comprehensive workflow guides the entire lifecycle of building a complex full-stack feature, from initial architectural design to final integration testing. It enforces an API-first approach, ensuring that the database schema, backend services, and frontend components are developed cohesively, promoting scalability, testability, and adherence to modern industry best practices.

Generates realistic database seed data and scripts for development or testing, leveraging Faker libraries to respect schema constraints, maintain relationships, and allow configurable volumes for quick population of demo or test environments.

Generates realistic users, products, orders, or schema-driven data via the test-data-generator plugin for populating test databases, simulating user behavior, and creating fixtures for automated or API testing.

Execute comprehensive load, stress, and soak tests to validate API performance, identify scaling bottlenecks, and establish throughput baselines. This tool simulates realistic, high-volume traffic patterns using industry-standard tools like k6 or Artillery, allowing users to define complex scenarios (e.g., e-commerce checkout flows, traffic spikes) and assert performance thresholds (p95 latency, error rates). It helps pinpoint resource limitations in databases, network layers, or compute resources, ensuring the API is ready for production scalability.

Handles disaster recovery, PITR, and automated failover for production databases via the database-recovery-manager plugin, streamlining backup validation and recovery testing whenever users ask for database recovery support.

Manages complete database testing workflows by generating realistic test data, wrapping tests in automatic transactions, and validating schema integrity to keep migrations and interactions reliable.

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.

Enables Claude to orchestrate isolated test environments using Docker Compose, Testcontainers, and environment variables, ensuring consistent setups for database, cache, and message-queue based testing across software projects.

Automates load, stress, spike, and endurance tests through the performance-test-suite plugin, collecting response time, throughput, and error-rate metrics to spot CPU/memory/database/network bottlenecks and deliver graphs plus optimization guidance.