Loading...
Loading...
Found 161 Skills
Use when the user asks to write SQL queries, optimize database performance, generate migrations, explore database schemas, or work with ORMs like Prisma, Drizzle, TypeORM, or SQLAlchemy.
Design schemas, plan migrations, and optimize queries. Six modes from modeling to evolution. Use for database architecture. NOT for DBA ops, backups, or deployment (devops-engineer).
Use when designing schema, writing migrations, writing transactions/concurrent code, optimizing queries, reviewing SQL or ORM code, or seeding/testing data for SQLite, MySQL, or PostgreSQL. Covers safety guards for destructive operations (DROP/TRUNCATE/ALTER), schema/data-type mapping across the three dialects, transaction and locking correctness, migration rollback safety, indexing/EXPLAIN-based query optimization, and evidence-based code review. Trigger this whenever a task touches a database connection, schema, SQL statement, or ORM query for any of these three engines.
Audit and optimize application performance, including bundle size, rendering, database queries, and Core Web Vitals.
Writes and audits data loading in a TanStack Start and TanStack Query app, removing request waterfalls and wasted requests from route loaders, suspense queries, mutations and server functions. Use when writing or reviewing a loader, useSuspenseQuery, useMutation or createServerFn, when a TanStack route loads slowly, fetches the same data twice or a save stays pending, or when the user says "audit data loading", "find waterfalls". Not for bundle size, HTTP caching, or apps without TanStack Query.
Master JPA/Hibernate - entity design, queries, transactions, performance optimization
Expert SurrealDB developer specializing in multi-model database design, graph relations, document storage, SurrealQL queries, row-level security, and real-time subscriptions. Use when building SurrealDB applications, designing graph schemas, implementing secure data access patterns, or optimizing query performance.
Prisma ORM patterns including Prisma Client usage, queries, mutations, relations, transactions, and schema management. Use when working with Prisma database operations or schema definitions.
Use when active Record patterns including models, associations, queries, validations, and callbacks.
Guide for code refactoring, use this skill to guide you when user asked to refactor a components or functions and when an implementation of a plan requiring a code refactoring.
Database operations: migrations, queries, transactions, and performance. Use when: - Writing database migrations - Optimizing queries or adding indexes - Managing transactions and connections - Setting up connection pooling - Designing audit logging Keywords: database, migration, SQL, query optimization, index, transaction, connection pool, N+1, ORM, audit log
ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.