Backend Queries
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.
7
0
2025年10月29日 14:48
maxritter
maxritter/claude-code-pro下载技能文件
下载包含 SKILL.md 和所有相关文件的完整技能目录
相关技能
Backend Migrations
maxritter
Create and manage database migrations with reversible changes, proper naming conventions, and zero-downtime deployment strategies. Use this skill when creating database migration files, modifying schema, adding or removing tables/columns, managing indexes, or handling data migrations. Apply when working with migration files (e.g., db/migrate/, migrations/, alembic/, sequelize migrations), schema changes, database versioning, rollback implementations, or when you need to ensure backwards compatibility during deployments. Use for any task involving database structure changes, index creation, constraint modifications, or data transformation scripts.
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