Skill UI

A comprehensive skill for optimizing complex SQL queries, designing robust database schemas, and troubleshooting performance bottlenecks across various dialects (PostgreSQL, MySQL, etc.). Use this when queries are slow, complex set-based logic is needed (CTEs, Window Functions), or when structuring/migrating a database schema. It provides detailed query plan analysis, advanced indexing strategies, and industry best practices.

Expert capability for designing and implementing complex semantic search systems using vector databases. Proficient in embedding strategies, index optimization (HNSW, IVF), and advanced retrieval methods like RAG and hybrid search. Masters major platforms including Pinecone, Weaviate, Qdrant, Milvus, and pgvector for building sophisticated recommendation and similarity search applications.

A comprehensive, multi-phase workflow for developing professional WordPress plugins. Covers foundational architecture, hooks, admin UI, database design, and REST API implementation. Crucially, it incorporates advanced WordPress 7.0 features, including Real-Time Collaboration (RTC) compatibility, AI Connector integration (OpenAI, Claude, etc.), and the Abilities API, ensuring modern, scalable, and secure plugins.

This powerful tool helps translate natural language requirements into robust, normalized relational database schemas. It can generate comprehensive schema designs, complete with relationships, constraints, and advanced architectural concerns like multi-tenancy, soft deletes, and audit trails. Furthermore, it automates the generation of database migrations (supporting Prisma, TypeORM, Alembic, etc.), corresponding type definitions (TypeScript/Python), seed data, and Entity-Relationship Diagrams (ERD) using Mermaid.

This comprehensive guide facilitates the development of a production-ready Minimum Viable Product (MVP) for a SaaS business. It covers the entire lifecycle, including idea validation, modern tech stack selection (Next.js, Supabase, Stripe), architectural design for multi-tenancy, database schema planning, authentication setup, payment integration, and a detailed pre-launch checklist for technical and marketing readiness.

This expert assists developers in building type-safe, high-performance database layers using Drizzle ORM with TypeScript. It provides deep knowledge of schema design, complex relational querying (joins, aggregations), managing migrations via Drizzle Kit, and seamless integration with modern stacks like Next.js, tRPC, and serverless environments. Ideal for developers needing a zero-overhead, type-safe ORM alternative.

This skill generates a complete, opinionated, modern full-stack Rails application boilerplate. It sets up a robust tech stack including Rails 8, PostgreSQL, React, Inertia.js, Vite, Tailwind CSS, Sidekiq, and Redis. Designed for developers who need a starting point that adheres to best practices for database structure (UUIDs, JSONB), background job processing, comprehensive testing, and modern frontend development (TSX). Ideal for bootstrapping complex, production-grade web services.

A comprehensive suite of 25 advanced agent skills designed for modern software development and platform operations. These tools cover the entire development lifecycle, including multi-agent architecture design, robust CI/CD pipelines, database schema management, performance profiling, observability setup, and security auditing. Ideal for complex system integration and platform engineering teams.

This guide provides comprehensive patterns for designing and implementing secure multi-tenant SaaS applications using shared databases. It covers critical techniques like Row-Level Security (RLS) in PostgreSQL, implementing tenant-aware middleware in TypeScript (Express/Fastify), and enforcing data scoping at the ORM level (Prisma/Drizzle). Learn how to prevent data leakage and manage tenant isolation across shared schemas.

This advanced prompt acts as a structured guide for generating comprehensive, enterprise-grade technical implementation plans. It forces the detailed breakdown of a feature based on a PRD, covering system architecture (Mermaid diagrams), database schema design, API specifications, frontend component hierarchy, and deployment strategies, all while adhering to a monorepo structure. Ideal for large-scale SaaS development.

This comprehensive guide covers best practices for building robust database systems. It teaches crucial concepts like schema normalization, effective indexing strategies, selecting the right database (e.g., SQLite vs PostgreSQL) and ORM, and optimizing queries to prevent common performance issues like N+1 problems. It emphasizes making context-aware architectural decisions.

This guide provides proven architectural patterns for building complex, reliable, and scalable workflows using n8n. It covers core patterns like Webhook processing, HTTP API integration, database synchronization, AI agent design, and scheduled tasks. Learn how to select the right pattern and utilize advanced components for robust automation.