backend-queries
Write efficient and secure database queries using parameterized queries, eager loading to prevent N+1 problems, selective column fetching, strategic indexing, transactions for related changes, query timeouts, a...
Discover Testing & security skills, compare source repositories and read the instructions for each workflow.
Write efficient and secure database queries using parameterized queries, eager loading to prevent N+1 problems, selective column fetching, strategic indexing, transactions for related changes, query timeouts, a...
SQLite best practices, optimization, and common patterns for Go applications
Define database models and ORM classes with proper data types, relationships, constraints, and validation logic following framework conventions. Use this skill when working with model definitions, schema classe...
RDBMS access patterns for DuckDB, MySQL (keycloak), PostgreSQL (dw, x3rocs), SQL Server (sage1000, x3), and DBISAM (Exportmaster) using ODBC and native drivers
Implement PostgreSQL transactions for atomic operations in Supabase. Triggers when user needs atomic updates, batch operations, or mentions transactions, rollbacks, or data consistency.
Database access layer guidelines for Quantum Skincare's Prisma-based data-access library. Covers Prisma schema design, DAO patterns, UUID primary keys, PostgreSQL role-based access control (RBAC), migration wor...
Create database seed scripts with realistic test data for development and testing. Use when setting up development environment or creating demo data.
Create database migrations following Laravel best practices with reversible up/down methods, focused single-purpose changes, proper index management, and clear naming conventions. Use this skill when creating n...
Safe database migration creation and management for Supabase PostgreSQL
Design relational database schemas, create tables, and manage migrations for scalable applications.
Guide for creating Sea-ORM database migrations in the Open Guard bot
Creates and runs data migrations for schema changes, ensuring data integrity.
Data consistency review guidance. Use when reviewing database changes, migrations, schema modifications, or data integrity concerns.
Process use when you need to automate database backup processes with scheduling and encryption. This skill creates backup scripts for PostgreSQL, MySQL, MongoDB, and SQLite with compression. Trigger with phrase...
Create, validate, and apply Supabase migrations with idempotent SQL, RLS checks, and types regeneration. Use when the user mentions migrations, db diff, schema changes, or type generation.
Create and manage Alembic database migrations for SQLAlchemy models. Use when adding/modifying database tables or columns.
Data migration guidelines
Prisma ORM expert for schema design, migrations, query optimization, relations modeling, and database operations. Use PROACTIVELY for Prisma schema issues, migration problems, query performance, relation design...
Standards for Firestore schemas, migrations, and data integrity. Use when modifying database structures.
Manage ArangoDB operations including backups with automatic retention, health checks, embedding gap detection, duplicate detection, and integrity verification. Works with local or containerized ArangoDB.
used for preparing hypothetical indexes to be run in higher environments
Transient vector store service for fast similarity search (FAISS)
Deploy Firebase Firestore security rules and indexes automatically. Use when Firestore query errors mention "requires an index", when firestore.rules or firestore.indexes.json are modified, or when user request...
Manages PostgreSQL, MongoDB, DuckDB, and Redis operations for knowledge base content storage, retrieval, and analytics. Handles schema management, data migrations, and cross-database synchronization with natura...
The default order uses GitHub repository stars from our indexed data. Stars belong to the source repository and may be shared by multiple skills. They indicate repository interest, not skill installs or an independent quality score.