Backend Migrations

Backend Queries

maxritter

Write secure, optimized database queries using parameterized queries, eager loading to prevent N+1 problems, and strategic indexing for performance. Use this skill when writing SQL queries, ORM queries, database interactions, or optimizing data fetching logic. Apply when working with query files, repository patterns, data access layers, SQL statements, ORM methods (ActiveRecord, Sequelize, Prisma queries), JOIN operations, WHERE clauses, preventing SQL injection, implementing eager loading or includes, adding query timeouts, wrapping operations in transactions, or caching expensive queries. Use for any task involving database reads, writes, complex queries, query optimization, or data fetching performance.

Backend Models

maxritter

Define database models with clear naming, appropriate data types, constraints, relationships, and validation at multiple layers. Use this skill when creating or modifying database model files, ORM classes, schema definitions, or data model relationships. Apply when working with model files (e.g., models.py, models/, ActiveRecord classes, Prisma schema, Sequelize models), defining table structures, setting up foreign keys and relationships, configuring cascade behaviors, implementing model validations, adding timestamps, or working with database constraints (NOT NULL, UNIQUE, foreign keys). Use for any task involving data integrity enforcement, relationship definitions, or model-level data validation.

migration-generator

CuriousLearner

Create database migrations from model changes, schema diffs, and migration best practices.

query-optimizer

CuriousLearner

Analyze and optimize SQL queries for better performance and efficiency.

query-builder

CuriousLearner

Interactive database query builder for generating optimized SQL and NoSQL queries.

aws-rds-aurora-spring-data-jpa-configuration

giuseppe-trisciuoglio

Focused guide for configuring AWS RDS Aurora (MySQL/PostgreSQL) with Spring Data JPA. Use when setting up Aurora database connections, configuring datasources, connection pooling, and production-ready settings.

apache-spark-data-processing

manutej

Complete guide for Apache Spark data processing including RDDs, DataFrames, Spark SQL, streaming, MLlib, and production deployment

postgresql-database-engineering

manutej

Comprehensive PostgreSQL database engineering skill covering indexing strategies, query optimization, performance tuning, partitioning, replication, backup and recovery, high availability, and production database management. Master advanced PostgreSQL features including MVCC, VACUUM operations, connection pooling, monitoring, and scalability patterns.

PostgreSQL Database Administration

manutej

Comprehensive PostgreSQL database administration skill for customer support tech enablement, covering database design, optimization, performance tuning, backup/recovery, and advanced query techniques

SQLAlchemy ORM Expert

manutej

Comprehensive SQLAlchemy skill for customer support tech enablement, covering ORM patterns, session management, query optimization, async operations, and PostgreSQL integration

database-management-patterns

manutej

Comprehensive guide for database management patterns covering PostgreSQL and MongoDB including schema design, indexing, transactions, replication, and performance tuning

psycopg

manutej

PostgreSQL adapter for Python - customer support tech enablement for database operations, query optimization, and data management