All authors

Claude Skills by ancoleman
github.com/ancoleman76 skills10 installs244 views
- Optimizing SqlProvide tactical guidance for optimizing SQL query performance across PostgreSQL, MySQL, and SQL Server through execution plan analysis, strategic indexing, and query rewriting.Votes: 0GitHub stars: 517
- Performance EngineeringWhen validating system performance under load, identifying bottlenecks through profiling, or optimizing application responsiveness. Covers load testing (k6, Locust), profiling (CPU, memory, I/O), and optimization strategies (caching, query optimization, Core Web Vitals). Use for capacity planning, regression detection, and establishing performance SLOs.Votes: 0GitHub stars: 517
- Planning Disaster RecoveryDesign and implement disaster recovery strategies with RTO/RPO planning, database backups, Kubernetes DR, cross-region replication, and chaos engineering testing. Use when implementing backup systems, configuring point-in-time recovery, setting up multi-region failover, or validating DR procedures.Votes: 0GitHub stars: 517
- Platform EngineeringDesign and implement Internal Developer Platforms (IDPs) with self-service capabilities, golden paths, and developer experience optimization. Covers platform strategy, IDP architecture (Backstage, Port), infrastructure orchestration (Crossplane), GitOps (Argo CD), and adoption patterns. Use when building developer platforms, improving DevEx, or establishing platform teams.Votes: 0GitHub stars: 517
- Prompt EngineeringDesign and optimize prompts for large language models (LLMs) to achieve reliable, high-quality outputs across diverse tasks.Votes: 0GitHub stars: 517
- Providing FeedbackThis skill implements comprehensive feedback and notification systems that enhance all other component skills by providing consistent patterns for communicating system state, displaying messages, and handling user confirmations.Votes: 0GitHub stars: 517
- Resource TaggingApply comprehensive cloud resource tagging strategies to enable cost allocation, ownership tracking, compliance enforcement, and infrastructure automation across multi-cloud environments.Votes: 0GitHub stars: 517
- Secret ManagementSecure storage, rotation, and delivery of secrets (API keys, database credentials, TLS certificates) for applications and infrastructure.Votes: 0GitHub stars: 517
- Securing AuthenticationImplement modern authentication, authorization, and API security across Python, Rust, Go, and TypeScript.Votes: 0GitHub stars: 517
- Security HardeningReduces attack surface across OS, container, cloud, network, and database layers using CIS Benchmarks and zero-trust principles. Use when hardening production infrastructure, meeting compliance requirements, or implementing defense-in-depth security.Votes: 0GitHub stars: 517
- Shell ScriptingWrite robust, portable shell scripts with proper error handling, argument parsing, and testing. Use when automating system tasks, building CI/CD scripts, or creating container entrypoints.Votes: 0GitHub stars: 517
- Siem LoggingConfigure security information and event management (SIEM) systems for threat detection, log aggregation, and compliance. Use when implementing centralized security logging, writing detection rules, or meeting audit requirements across cloud and on-premise infrastructure.Votes: 0GitHub stars: 517
- Streaming DataBuild production-ready event streaming systems and real-time data pipelines using modern message brokers and stream processors.Votes: 0GitHub stars: 517
- Testing StrategiesBuild comprehensive, effective test suites by strategically selecting and implementing the right testing approaches across unit, integration, E2E, and contract testing levels.Votes: 0GitHub stars: 517
- Theming ComponentsComprehensive design token system providing the foundational styling architecture for all component skills, enabling brand customization, theme switching, RTL support, and consistent visual design.Votes: 0GitHub stars: 517
- Transforming DataTransform raw data into analytical assets using modern transformation patterns, frameworks, and orchestration tools.Votes: 0GitHub stars: 517
- Using Document DatabasesGuide NoSQL document database selection and implementation for flexible schema applications across Python, TypeScript, Rust, and Go.Votes: 0GitHub stars: 517
- Using Graph DatabasesGraph database implementation for relationship-heavy data models. Use when building social networks, recommendation engines, knowledge graphs, or fraud detection. Covers Neo4j (primary), ArangoDB, Amazon Neptune, Cypher query patterns, and graph data modeling.Votes: 0GitHub stars: 517
- Using Message QueuesImplement asynchronous communication patterns for event-driven architectures, background job processing, and service decoupling.Votes: 0GitHub stars: 517
- Using Relational DatabasesRelational database implementation across Python, Rust, Go, and TypeScript. Use when building CRUD applications, transactional systems, or structured data storage. Covers PostgreSQL (primary), MySQL, SQLite, ORMs (SQLAlchemy, Prisma, SeaORM, GORM), query builders (Drizzle, sqlc, SQLx), migrations, connection pooling, and serverless databases (Neon, PlanetScale, Turso).Votes: 0GitHub stars: 517
- Using Timeseries DatabasesImplement efficient storage and querying for time-stamped data (metrics, IoT sensors, financial ticks, logs).Votes: 0GitHub stars: 517
- Using Vector DatabasesVector database implementation for AI/ML applications, semantic search, and RAG systems. Use when building chatbots, search engines, recommendation systems, or similarity-based retrieval. Covers Qdrant (primary), Pinecone, Milvus, pgvector, Chroma, embedding generation (OpenAI, Voyage, Cohere), chunking strategies, and hybrid search patterns.Votes: 0GitHub stars: 517
- Visualizing DataSystematic guidance for selecting and implementing effective data visualizations, matching data characteristics with appropriate visualization types, ensuring clarity, accessibility, and impact.Votes: 0GitHub stars: 517
- Writing DockerfilesCreate production-grade Dockerfiles with multi-stage builds, security hardening, and language-specific optimizations.Votes: 0GitHub stars: 517
- Writing Github ActionsCreate GitHub Actions workflows for CI/CD pipelines, automated testing, deployments, and repository automation using YAML-based configuration with native GitHub integration.Votes: 0GitHub stars: 517
- Writing Infrastructure CodeProvision and manage cloud infrastructure using code-based automation tools. This skill covers tool selection, state management, module design, and operational patterns across Terraform/OpenTofu, Pulumi, and AWS CDK.Votes: 0GitHub stars: 517