Loading...
Loading...
Found 46 Skills
Prevent N+1 queries by eager loading; enable lazy-loading protection in non-production; choose selective fields
Apply Convex database best practices for cost optimization, performance, security, and architecture. Use when: building Convex backends, optimizing queries, handling embeddings/vector search, reviewing Convex code, designing schemas, planning migrations, or discussing Convex architecture. Keywords: Convex, real-time database, queries, mutations, actions, indexes, pagination, vector search, embeddings, schema, migrations, ctx.auth, convex-helpers, bandwidth.
Provides comprehensive guidance for MySQL database including SQL syntax, data types, indexes, transactions, stored procedures, and optimization. Use when the user asks about MySQL, needs to write SQL queries, design database schemas, optimize MySQL performance, or work with MySQL features.
Guide on Prisma, SQLite, and LiteFS for Epic Stack
SQL database queries, joins, aggregations, subqueries, and optimization. Use for .sql files and database operations.
Social feed with batch queries, cursor pagination, trending algorithms, and engagement tracking. Efficient database queries for infinite scroll feeds.
Database specialist covering PostgreSQL, MongoDB, Redis, and advanced data patterns for modern applications
Process use when you need to work with connection management. This skill provides connection pooling and management with comprehensive guidance and automation. Trigger with phrases like "manage connections", "configure pooling", or "optimize connection usage".
Backend architecture patterns, API design, database optimization, and server-side best practices for Node.js, Express, and Next.js API routes.
Managing legacy MySQL/MariaDB schemas in LAMP stacks.