Skill UI

A comprehensive, expert-level skill for designing, analyzing, and optimizing robust database schemas. It covers normalization, index tuning, choosing between SQL/NoSQL, and implementing zero-downtime data migrations. Provides systematic workflows for schema analysis, performance modeling, and advanced SQL pattern generation.

Specializes in generating production-grade SQL database migrations with zero-downtime strategies for PostgreSQL, MySQL, and SQL Server. Provides comprehensive plans covering data integrity, detailed rollback procedures, performance optimization, and validation checks for critical schema changes.

Actionable guidance for analyzing plans, indexing, connection pooling, partitioning, and detecting N+1 queries to keep PostgreSQL and MySQL workloads fast and reliable.

Implements multi-tier database caching using Redis, in-memory stores, and CDN integration to reduce load, lower query latency, and support scalable cache-aside, write-through, or read-through workflows when users ask for caching optimizations.

This skill provides comprehensive guidance for senior-level Laravel engineering. It focuses on building production-grade, maintainable, and highly secure applications using modern architectural patterns (clean architecture, services, etc.). Use this when developing new features, refactoring complex code, designing robust APIs, or optimizing database interactions within a Laravel environment. Adheres to best practices like Eloquent optimization and proper authentication flows.

Provides a structured workflow to analyze and improve application performance across frontend, backend, and database layers, including profiling, bottleneck identification, optimization tactics, and validation steps.

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.

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.

This skill provides comprehensive expertise for senior database administrators to optimize and manage PostgreSQL databases at an advanced level. Use it for deep query analysis via EXPLAIN ANALYZE, implementing advanced features like JSONB indexing, configuring streaming or logical replication, and maintaining database health through VACUUM tuning and monitoring pg_stat views. Ideal for building highly available, high-performance, and resilient system architectures.

A specialized, comprehensive workflow designed for optimizing PostgreSQL databases. It guides users through performance assessment, advanced query tuning (using EXPLAIN ANALYZE), defining optimal indexing strategies, fine-tuning configuration parameters (like shared_buffers), and setting up robust maintenance and monitoring practices for production environments.

An expert assistant providing deep knowledge and best practices for Prisma ORM. It covers the entire lifecycle of database interaction, including optimal schema design, relation modeling, safe migration workflows, and advanced query optimization techniques (addressing N+1 issues and implementing raw queries) across PostgreSQL, MySQL, and SQLite.

A comprehensive toolset for the full backend development lifecycle. This suite enables developers to scaffold API routes from OpenAPI specifications, manage complex database migrations and optimization (PostgreSQL), and perform rigorous load/performance testing. It supports building robust microservices, securing REST APIs, and ensuring system scalability.