database-indexing-strategy
io.github.aj-geddes/useful-ai-prompts/database-indexing-strategy
Design and implement database indexing strategies. Use when creating indexes, choosing index types, or optimizing index performance in PostgreSQL and MySQL.
6,144 resources
io.github.aj-geddes/useful-ai-prompts/database-indexing-strategy
Design and implement database indexing strategies. Use when creating indexes, choosing index types, or optimizing index performance in PostgreSQL and MySQL.
io.github.aj-geddes/useful-ai-prompts/database-sharding
Implement database sharding for horizontal scalability. Use when scaling large databases, distributing data across multiple servers, or designing sharded architectures.
io.github.aj-geddes/useful-ai-prompts/database-schema-documentation
Document database schemas, ERD diagrams, table relationships, indexes, and constraints. Use when documenting database schema, creating ERD diagrams, or writing table documentation.
io.github.aj-geddes/useful-ai-prompts/database-schema-design
Design database schemas with normalization, relationships, and constraints. Use when creating new database schemas, designing tables, or planning data models for PostgreSQL and MySQL.
io.github.aj-geddes/useful-ai-prompts/refactor-legacy-code
Modernize and improve legacy codebases while maintaining functionality. Use when you need to refactor old code, reduce technical debt, modernize deprecated patterns, or improve code maintainability without breaking existing behavior.
io.github.aj-geddes/useful-ai-prompts/css-architecture
Organize CSS using BEM, SMACSS, and CSS-in-JS patterns. Use when building scalable, maintainable styling systems with proper naming conventions.
io.github.aj-geddes/useful-ai-prompts/mobile-first-design
Design for mobile devices first, then scale up to larger screens. Create responsive interfaces that work seamlessly across all device sizes.
io.github.aj-geddes/useful-ai-prompts/mobile-app-testing
Comprehensive mobile app testing strategies for iOS and Android. Covers unit tests, UI tests, integration tests, performance testing, and test automation with Detox, Appium, and XCTest.
io.github.aj-geddes/useful-ai-prompts/mobile-app-debugging
Debug issues specific to mobile applications including platform-specific problems, device constraints, and connectivity issues.
io.github.aj-geddes/useful-ai-prompts/mobile-offline-support
Implement offline-first mobile apps with local storage, sync strategies, and conflict resolution. Covers AsyncStorage, Realm, SQLite, and background sync patterns.
io.github.aj-geddes/useful-ai-prompts/kubernetes-deployment
Deploy, manage, and scale containerized applications on Kubernetes clusters with best practices for production workloads, resource management, and rolling updates.
io.github.aj-geddes/useful-ai-prompts/docker-containerization
Create optimized Docker containers with multi-stage builds, security best practices, and minimal image sizes. Use when containerizing applications, creating Dockerfiles, optimizing container images, or setting up Docker Compose services.
io.github.elastic/kibana/codeql
Work with CodeQL in Kibana — write, test, and debug custom queries locally, fetch scan results from GitHub, and validate inline suppression comments. Use when writing or debugging CodeQL queries, running CodeQL unit tests, analyzing SARIF results, fetching scan results, or checking codeql suppression justifications.
io.github.elastic/kibana/api-authz
Kibana API route authorization patterns. Use when configuring route security, working with requiredPrivileges, using authzResult for privilege-based branching, opting out of authorization, or naming custom privileges.
io.github.affaan-m/ECC/postgres-patterns
PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.
io.github.affaan-m/ECC/postgres-patterns
PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.
io.github.affaan-m/ECC/cpp-testing
C++ テストの作成/更新/修正、GoogleTest/CTest の設定、失敗またはフレーキーなテストの診断、カバレッジ/サニタイザーの追加時にのみ使用します。
io.github.atopile/atopile/frontend
Frontend standards for atopile extension webviews: architecture, contracts, design system, and testing workflow.
io.github.akin-ozer/cc-devops-skills/dockerfile-generator
Create, generate, or write Dockerfiles and multi-stage Docker images. Containerize apps.
io.github.akin-ozer/cc-devops-skills/dockerfile-validator
Validate, lint, audit, or scan a Dockerfile for security and best practices.
io.github.foryourhealth111-pixel/Vibe-Skills/pdf
PDF manipulation toolkit. Extract text/tables, create PDFs, merge/split, fill forms, for programmatic document processing and analysis.
io.github.erp-mafia/accounted/docker-patterns
Docker and Docker Compose patterns for local development, container security, networking, volume strategies, and multi-service orchestration.
io.github.christophacham/agent-skills-library/kubernetes-deployment
Kubernetes deployment workflow for container orchestration, Helm charts, service mesh, and production-ready K8s configurations.
io.github.phuryn/pm-skills/dummy-dataset
Generate realistic dummy datasets for testing with customizable columns, constraints, and output formats (CSV, JSON, SQL, Python script). Use when creating test data, building mock datasets, or generating sample data for development and demos.