aj-geddes
- 191 skills
- 0 followers
- 1 week ago last updated
- ▌ Database Schema Documentation · aj-geddes-useful-ai-prompts bundleDocument database schemas, ERD diagrams, table relationships, indexes, and constraints. Use when documenting database schema, creating ERD diagrams, or writing table documentation.
- ▌ Database Performance Debugging · aj-geddes-useful-ai-prompts bundleDebug database performance issues through query analysis, index optimization, and execution plan review. Identify and fix slow queries.
- ▌ Design Patterns Implementation · aj-geddes-useful-ai-prompts bundleApply appropriate design patterns (Singleton, Factory, Observer, Strategy, etc.) to solve architectural problems. Use when refactoring code architecture, implementing extensible systems, or following SOLID principles.
- ▌ Security Headers Configuration · aj-geddes-useful-ai-prompts bundleConfigure HTTP security headers including CSP, HSTS, X-Frame-Options, and XSS protection. Use when hardening web applications against common attacks.
- ▌ Infrastructure Cost Optimization · aj-geddes-useful-ai-prompts bundleOptimize cloud infrastructure costs through resource rightsizing, reserved instances, spot instances, and waste reduction strategies.
- ▌ Performance Regression Debugging · aj-geddes-useful-ai-prompts bundleIdentify and debug performance regressions from code changes. Use comparison and profiling to locate what degraded performance and restore baseline metrics.
- ▌ Xss Prevention · aj-geddes-useful-ai-prompts bundlePrevent Cross-Site Scripting (XSS) attacks through input sanitization, output encoding, and Content Security Policy. Use when handling user-generated content in web applications.
- ▌ Azure Functions · aj-geddes-useful-ai-prompts bundleCreate serverless functions on Azure with triggers, bindings, authentication, and monitoring. Use for event-driven computing without managing infrastructure.
- ▌ Csrf Protection · aj-geddes-useful-ai-prompts bundleImplement Cross-Site Request Forgery (CSRF) protection using tokens, SameSite cookies, and origin validation. Use when building forms and state-changing operations.
- ▌ Data Encryption · aj-geddes-useful-ai-prompts bundleImplement strong encryption using AES, RSA, TLS, and proper key management. Use when securing data at rest, in transit, or implementing end-to-end encryption.
- ▌ Form Validation · aj-geddes-useful-ai-prompts bundleImplement form validation using React Hook Form, Formik, Vee-Validate, and custom validators. Use when building robust form handling with real-time validation.
- ▌ Git Hooks Setup · aj-geddes-useful-ai-prompts bundleImplement Git hooks using Husky, pre-commit, and custom scripts. Enforce code quality, linting, and testing before commits and pushes.
- ▌ Log Aggregation · aj-geddes-useful-ai-prompts bundleImplement centralized logging with ELK Stack, Loki, or Splunk for log collection, parsing, storage, and analysis across infrastructure.
- ▌ Process Mapping · aj-geddes-useful-ai-prompts bundleVisualize and document current and future business processes. Identify inefficiencies, dependencies, and improvement opportunities through detailed process mapping and analysis.
- ▌ Risk Assessment · aj-geddes-useful-ai-prompts bundleIdentify, analyze, and prioritize project risks using qualitative and quantitative methods. Develop mitigation strategies to minimize impact and maximize project success probability.
- ▌ AWS Rds Database · aj-geddes-useful-ai-prompts bundleDeploy and manage relational databases using RDS with Multi-AZ, read replicas, backups, and encryption. Use for PostgreSQL, MySQL, MariaDB, and Oracle.
- ▌ Caching Strategy · aj-geddes-useful-ai-prompts bundleImplement efficient caching strategies using Redis, Memcached, CDN, and cache invalidation patterns. Use when optimizing application performance, reducing database load, or improving response times.
- ▌ Frontend Routing · aj-geddes-useful-ai-prompts bundleImplement client-side routing using React Router, Vue Router, and Angular Router. Use when building multi-page applications with navigation and route protection.
- ▌ Frontend Testing · aj-geddes-useful-ai-prompts bundleImplement comprehensive frontend testing using Jest, Vitest, React Testing Library, and Cypress. Use when building robust test suites for UI and integration tests.
- ▌ Mocking Stubbing · aj-geddes-useful-ai-prompts bundleCreate and manage mocks, stubs, spies, and test doubles for isolating unit tests from external dependencies. Use for mock, stub, spy, test double, Mockito, Jest mocks, and dependency isolation.
- ▌ Mutation Testing · aj-geddes-useful-ai-prompts bundleEvaluate test suite quality by introducing code mutations and verifying tests catch them. Use for mutation testing, test quality, mutant detection, Stryker, PITest, and test effectiveness analysis.
- ▌ React Native App · aj-geddes-useful-ai-prompts bundleBuild cross-platform mobile apps with React Native. Covers navigation with React Navigation, state management with Redux/Context API, API integration, and platform-specific features.
- ▌ Release Planning · aj-geddes-useful-ai-prompts bundlePlan, coordinate, and execute software releases across environments. Manage versioning, rollout strategies, rollback procedures, and stakeholder communication for smooth deployments.
- ▌ Runbook Creation · aj-geddes-useful-ai-prompts bundleCreate operational runbooks, playbooks, standard operating procedures (SOPs), and incident response guides. Use when documenting operational procedures, on-call guides, or incident response processes.
- ▌ Secrets Rotation · aj-geddes-useful-ai-prompts bundleImplement automated secrets rotation for API keys, credentials, certificates, and encryption keys. Use when managing secrets lifecycle, compliance requirements, or security hardening.
- ▌ Security Testing · aj-geddes-useful-ai-prompts bundleIdentify security vulnerabilities through SAST, DAST, penetration testing, and dependency scanning. Use for security test, vulnerability scanning, OWASP, SQL injection, XSS, CSRF, and penetration testing.
- ▌ AWS S3 Management · aj-geddes-useful-ai-prompts bundleManage S3 buckets with versioning, encryption, access control, lifecycle policies, and replication. Use for object storage, static sites, and data lakes.
- ▌ Azure App Service · aj-geddes-useful-ai-prompts bundleDeploy and manage web apps using Azure App Service with auto-scaling, deployment slots, SSL/TLS, and monitoring. Use for hosting web applications on Azure.
- ▌ Browser Debugging · aj-geddes-useful-ai-prompts bundleDebug client-side issues using browser developer tools. Identify JavaScript errors, styling issues, and performance problems in the browser.
- ▌ Canary Deployment · aj-geddes-useful-ai-prompts bundleImplement canary deployment strategies to gradually roll out new versions to subset of users with automatic rollback based on metrics.
- ▌ Capacity Planning · aj-geddes-useful-ai-prompts bundleAnalyze team capacity, plan resource allocation, and balance workload across projects. Forecast staffing needs and optimize team utilization while maintaining sustainable pace.
- ▌ Database Sharding · aj-geddes-useful-ai-prompts bundleImplement database sharding for horizontal scalability. Use when scaling large databases, distributing data across multiple servers, or designing sharded architectures.
- ▌ Graceful Shutdown · aj-geddes-useful-ai-prompts bundleImplement graceful shutdown procedures to handle SIGTERM signals, drain connections, complete in-flight requests, and clean up resources properly. Use when deploying containerized applications, handling server restarts, or ensuring zero-downtime deployments.
- ▌ Grafana Dashboard · aj-geddes-useful-ai-prompts bundleCreate professional Grafana dashboards with visualizations, templating, and alerts. Use when building monitoring dashboards, creating data visualizations, or setting up operational insights.
- ▌ Ml Model Training · aj-geddes-useful-ai-prompts bundleBuild and train machine learning models using scikit-learn, PyTorch, and TensorFlow for classification, regression, and clustering tasks
- ▌ Network Debugging · aj-geddes-useful-ai-prompts bundleDebug network issues using browser tools and network analysis. Diagnose connection problems, latency, and data transmission issues.
- ▌ Stored Procedures · aj-geddes-useful-ai-prompts bundleImplement stored procedures and functions for database logic. Use when creating reusable database routines, complex queries, or server-side calculations.
- ▌ Uptime Monitoring · aj-geddes-useful-ai-prompts bundleImplement uptime monitoring and status page systems for tracking service availability. Use when monitoring application uptime, creating status pages, or implementing health checks.
- ▌ AWS Cloudfront Cdn · aj-geddes-useful-ai-prompts bundleDistribute content globally using CloudFront with caching, security headers, WAF integration, and origin configuration. Use for low-latency content delivery.
- ▌ Code Documentation · aj-geddes-useful-ai-prompts bundleWrite comprehensive code documentation including JSDoc, Python docstrings, inline comments, function documentation, and API comments. Use when documenting code, writing docstrings, or creating inline documentation.
- ▌ Continuous Testing · aj-geddes-useful-ai-prompts bundleIntegrate automated testing into CI/CD pipelines for continuous quality feedback. Use for continuous testing, CI testing, automated testing pipelines, test orchestration, and DevOps quality practices.
- ▌ Django Application · aj-geddes-useful-ai-prompts bundleDevelop production-grade Django applications with models, views, ORM queries, authentication, and admin interfaces. Use when building web applications, managing databases with Django ORM, and implementing authentication systems.
- ▌ Image Optimization · aj-geddes-useful-ai-prompts bundleOptimize images for web to reduce file size without sacrificing quality. Use compression, modern formats, and responsive techniques for faster loading.
- ▌ Interaction Design · aj-geddes-useful-ai-prompts bundleDesign meaningful interactions and microinteractions. Create delightful user experiences through thoughtful animation, feedback, and responsive interface design.
- ▌ Project Estimation · aj-geddes-useful-ai-prompts bundleEstimate project scope, timeline, and resource requirements using multiple estimation techniques including bottom-up, top-down, and analogous estimation methods for accurate project planning.
- ▌ Real Time Features · aj-geddes-useful-ai-prompts bundleImplement real-time functionality using WebSockets, Server-Sent Events (SSE), or long polling. Use when building chat applications, live dashboards, collaborative editing, notifications, or any feature requiring instant updates.
- ▌ Secrets Management · aj-geddes-useful-ai-prompts bundleImplement secrets management with HashiCorp Vault, AWS Secrets Manager, or Kubernetes Secrets for secure credential storage and rotation.
- ▌ Session Management · aj-geddes-useful-ai-prompts bundleImplement secure session management systems with JWT tokens, session storage, token refresh, logout handling, and CSRF protection. Use when managing user authentication state, handling token lifecycle, and securing sessions.
- ▌ User Story Writing · aj-geddes-useful-ai-prompts bundleWrite effective user stories that capture requirements from the user's perspective. Create clear stories with detailed acceptance criteria to guide development and define done.
- ▌ Application Logging · aj-geddes-useful-ai-prompts bundleImplement structured logging across applications with log aggregation and centralized analysis. Use when setting up application logging, implementing ELK stack, or analyzing application behavior.
- ▌ Artifact Management · aj-geddes-useful-ai-prompts bundleManage build artifacts, Docker images, and package registries. Configure artifact repositories, versioning, and distribution strategies.
- ▌ Cicd Pipeline Setup · aj-geddes-useful-ai-prompts bundleDesign and implement CI/CD pipelines with GitHub Actions, GitLab CI, Jenkins, or CircleCI. Use for automated testing, building, and deployment workflows.
- ▌ Color Accessibility · aj-geddes-useful-ai-prompts bundleDesign color palettes that are accessible to all users including those with color blindness. Ensure sufficient contrast, meaningful use of color, and inclusive design.
- ▌ Competitor Analysis · aj-geddes-useful-ai-prompts bundleAnalyze competitive landscape to identify strengths, weaknesses, opportunities, and threats. Inform product strategy and positioning based on market insights.
- ▌ Container Debugging · aj-geddes-useful-ai-prompts bundleDebug Docker containers and containerized applications. Diagnose deployment issues, container lifecycle problems, and resource constraints.
- ▌ Correlation Tracing · aj-geddes-useful-ai-prompts bundleImplement distributed tracing with correlation IDs, trace propagation, and span tracking across microservices. Use when debugging distributed systems, monitoring request flows, or implementing observability.
- ▌ Database Monitoring · aj-geddes-useful-ai-prompts bundleMonitor database performance and health. Use when setting up monitoring, analyzing metrics, or troubleshooting database issues.
- ▌ Dependency Tracking · aj-geddes-useful-ai-prompts bundleMap, track, and manage project dependencies across teams, systems, and organizations. Identify critical path items and prevent blocking issues through proactive dependency management.
- ▌ Distributed Tracing · aj-geddes-useful-ai-prompts bundleImplement distributed tracing with Jaeger and Zipkin for tracking requests across microservices. Use when debugging distributed systems, tracking request flows, or analyzing service performance.
- ▌ Fastapi Development · aj-geddes-useful-ai-prompts bundleBuild high-performance FastAPI applications with async routes, validation, dependency injection, security, and automatic API documentation. Use when developing modern Python APIs with async support, automatic OpenAPI documentation, and high performance requirements.
- ▌ Feature Flag System · aj-geddes-useful-ai-prompts bundleImplement feature flags (toggles) for controlled feature rollouts, A/B testing, canary deployments, and kill switches. Use when deploying new features gradually, testing in production, or managing feature lifecycles.
- ▌ Flutter Development · aj-geddes-useful-ai-prompts bundleBuild beautiful cross-platform mobile apps with Flutter and Dart. Covers widgets, state management with Provider/BLoC, navigation, API integration, and material design.
- ▌ GCP Cloud Functions · aj-geddes-useful-ai-prompts bundleDeploy serverless functions on Google Cloud Platform with triggers, IAM roles, environment variables, and monitoring. Use for event-driven computing on GCP.
- ▌ Integration Testing · aj-geddes-useful-ai-prompts bundleDesign and implement integration tests that verify component interactions, API endpoints, database operations, and external service communication. Use for integration test, API test, end-to-end component testing, and service layer validation.
- ▌ Load Balancer Setup · aj-geddes-useful-ai-prompts bundleConfigure and deploy load balancers (HAProxy, AWS ELB/ALB/NLB) for distributing traffic, session management, and high availability.
- ▌ Memory Optimization · aj-geddes-useful-ai-prompts bundleProfile and optimize application memory usage. Identify memory leaks, reduce memory footprint, and improve efficiency for better performance and reliability.
- ▌ Monorepo Management · aj-geddes-useful-ai-prompts bundleManage monorepo architectures using Lerna, Turborepo, and Nx. Configure workspaces, dependency versioning, and cross-package testing.
- ▌ Performance Testing · aj-geddes-useful-ai-prompts bundleDesign and execute performance tests to measure response times, throughput, and resource utilization. Use for performance test, load test, JMeter, k6, benchmark, latency testing, and scalability analysis.
- ▌ Progressive Web App · aj-geddes-useful-ai-prompts bundleBuild progressive web apps using service workers, web manifest, offline support, and installability. Use when creating app-like web experiences.
- ▌ Root Cause Analysis · aj-geddes-useful-ai-prompts bundleConduct systematic root cause analysis to identify underlying problems. Use structured methodologies to prevent recurring issues and drive improvements.
- ▌ Semantic Versioning · aj-geddes-useful-ai-prompts bundleImplement semantic versioning (SemVer) with automated release management. Use conventional commits, semantic-release, and version bumping strategies.
- ▌ User Guide Creation · aj-geddes-useful-ai-prompts bundleCreate comprehensive user guides, tutorials, how-to documentation, and step-by-step instructions with screenshots and examples. Use when writing user documentation, tutorials, or getting started guides.
- ▌ Webhook Development · aj-geddes-useful-ai-prompts bundleImplement webhook systems for event-driven integration with retry logic, signature verification, and delivery guarantees. Use when creating event notification systems, integrating with external services, or building event-driven architectures.
- ▌ Webhook Integration · aj-geddes-useful-ai-prompts bundleImplement secure webhook systems for event-driven integrations, including signature verification, retry logic, and delivery guarantees. Use when building third-party integrations, event notifications, or real-time data synchronization.
- ▌ App Store Deployment · aj-geddes-useful-ai-prompts bundleDeploy iOS and Android apps to App Store and Google Play. Covers signing, versioning, build configuration, submission process, and release management.
- ▌ AWS Lambda Functions · aj-geddes-useful-ai-prompts bundleCreate and deploy serverless functions using AWS Lambda with event sources, permissions, layers, and environment configuration. Use for event-driven computing without managing servers.
- ▌ Concurrency Patterns · aj-geddes-useful-ai-prompts bundleImplement thread-safe code, mutexes, semaphores, async/await patterns, and concurrent data structures. Use when handling parallel operations, race conditions, or building high-performance concurrent systems.
- ▌ Developer Onboarding · aj-geddes-useful-ai-prompts bundleCreate comprehensive developer onboarding documentation including setup guides, README files, contributing guidelines, and getting started tutorials. Use when onboarding new developers or creating setup documentation.
- ▌ File Upload Handling · aj-geddes-useful-ai-prompts bundleImplement secure file upload handling with validation, virus scanning, storage management, and serving files efficiently. Use when building file upload features, managing file storage, and implementing file download systems.
- ▌ Gitlab Cicd Pipeline · aj-geddes-useful-ai-prompts bundleDesign and implement GitLab CI/CD pipelines with stages, jobs, artifacts, and caching. Configure runners, Docker integration, and deployment strategies.
- ▌ Idempotency Handling · aj-geddes-useful-ai-prompts bundleImplement idempotency keys and handling to ensure operations can be safely retried without duplicate effects. Use when building payment systems, APIs with retries, or distributed transactions.
- ▌ Kpi Dashboard Design · aj-geddes-useful-ai-prompts bundleDesign and build dashboards that track key performance indicators. Select relevant metrics, visualize data effectively, and communicate insights to stakeholders.
- ▌ Mobile App Debugging · aj-geddes-useful-ai-prompts bundleDebug issues specific to mobile applications including platform-specific problems, device constraints, and connectivity issues.
- ▌ Multi Cloud Strategy · aj-geddes-useful-ai-prompts bundleDesign and implement multi-cloud strategies spanning AWS, Azure, and GCP with vendor lock-in avoidance, hybrid deployments, and federation.
- ▌ OAUTH Implementation · aj-geddes-useful-ai-prompts bundleImplement secure OAuth 2.0, OpenID Connect (OIDC), JWT authentication, and SSO integration. Use when building secure authentication systems for web and mobile applications.
- ▌ Polyglot Integration · aj-geddes-useful-ai-prompts bundleIntegrate multiple programming languages using FFI, native bindings, gRPC, or language bridges. Use when combining strengths of different languages or integrating legacy systems.
- ▌ Reactive Programming · aj-geddes-useful-ai-prompts bundleImplement reactive programming patterns using RxJS, streams, observables, and backpressure handling. Use when building event-driven UIs, handling async data streams, or managing complex data flows.
- ▌ Refactor Legacy Code · aj-geddes-useful-ai-prompts bundleModernize 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.
- ▌ Synthetic Monitoring · aj-geddes-useful-ai-prompts bundleImplement synthetic monitoring and automated testing to simulate user behavior and detect issues before users. Use when creating end-to-end test scenarios, monitoring API flows, or validating user workflows.
- ▌ Test Data Generation · aj-geddes-useful-ai-prompts bundleGenerate realistic, consistent test data using factories, fixtures, and fake data libraries. Use for test data, fixtures, mock data, faker, test builders, and seed data generation.
- ▌ Batch Processing Jobs · aj-geddes-useful-ai-prompts bundleImplement robust batch processing systems with job queues, schedulers, background tasks, and distributed workers. Use when processing large datasets, scheduled tasks, async operations, or resource-intensive computations.
- ▌ Blue Green Deployment · aj-geddes-useful-ai-prompts bundleImplement blue-green deployment strategies for zero-downtime releases with instant rollback capability and traffic switching between environments.
- ▌ Changelog Maintenance · aj-geddes-useful-ai-prompts bundleMaintain comprehensive changelogs and release notes following Keep a Changelog format. Use when documenting version history, release notes, or tracking changes across versions.
- ▌ Cloud Cost Management · aj-geddes-useful-ai-prompts bundleOptimize and manage cloud costs across AWS, Azure, and GCP using reserved instances, spot pricing, and cost monitoring tools.
- ▌ Code Metrics Analysis · aj-geddes-useful-ai-prompts bundleAnalyze code complexity, cyclomatic complexity, maintainability index, and code churn using metrics tools. Use when assessing code quality, identifying refactoring candidates, or monitoring technical debt.
- ▌ Dependency Management · aj-geddes-useful-ai-prompts bundleManage project dependencies across languages including npm install, package versioning, dependency conflicts, security scanning, and lock files. Use when dealing with dependencies, version pinning, semantic versioning, or resolving conflicts.
- ▌ Deployment Automation · aj-geddes-useful-ai-prompts bundleAutomate deployments across environments using Helm, Terraform, and ArgoCD. Implement blue-green deployments, canary releases, and rollback strategies.
- ▌ Kubernetes Deployment · aj-geddes-useful-ai-prompts bundleDeploy, manage, and scale containerized applications on Kubernetes clusters with best practices for production workloads, resource management, and rolling updates.
- ▌ Memory Leak Detection · aj-geddes-useful-ai-prompts bundleDetect and fix memory leaks using heap snapshots, memory profiling, and leak detection tools. Use when investigating memory growth, OOM errors, or optimizing memory usage.
- ▌ Nosql Database Design · aj-geddes-useful-ai-prompts bundleDesign NoSQL database schemas for MongoDB and DynamoDB. Use when modeling document structures, designing collections, or planning NoSQL data architectures.