askill
ancoleman

ancoleman

Publisher on askill

4.7k total stars
Skills22
Updated 12/11/2025
GitHub
using-timeseries-databases
using-timeseries-databases
ancoleman12/11/2025

Time-series database implementation for metrics, IoT, financial data, and observability backends. Use when building dashboards, monitoring systems, IoT platforms, or financial applications. Covers Tim...

320
AI 87
optimizing-sql
optimizing-sql
ancoleman12/11/2025

Optimize SQL query performance through EXPLAIN analysis, indexing strategies, and query rewriting for PostgreSQL, MySQL, and SQL Server. Use when debugging slow queries, analyzing execution plans, or...

282
AI 94
displaying-timelines
displaying-timelines
ancoleman12/11/2025

Displays chronological events and activity through timelines, activity feeds, Gantt charts, and calendar interfaces. Use when showing historical events, project schedules, social feeds, notifications,...

282
AI 93
using-message-queues
using-message-queues
ancoleman12/11/2025

Async communication patterns using message brokers and task queues. Use when building event-driven systems, background job processing, or service decoupling. Covers Kafka (event streaming), RabbitMQ (...

282
AI 92
managing-secrets
managing-secrets
ancoleman12/11/2025

Managing secrets (API keys, database credentials, certificates) with Vault, cloud providers, and Kubernetes. Use when storing sensitive data, rotating credentials, syncing secrets to Kubernetes, imple...

282
AI 88
platform-engineering
platform-engineering
ancoleman12/11/2025

Design and implement Internal Developer Platforms (IDPs) with self-service capabilities, golden paths, and developer experience optimization. Covers platform strategy, IDP architecture (Backstage, Por...

282
AI 87
managing-vulnerabilities
managing-vulnerabilities
ancoleman12/11/2025

Implementing multi-layer security scanning (container, SAST, DAST, SCA, secrets), SBOM generation, and risk-based vulnerability prioritization in CI/CD pipelines. Use when building DevSecOps workflows...

282
AI 70
implementing-realtime-sync
implementing-realtime-sync
ancoleman12/11/2025

Real-time communication patterns for live updates, collaboration, and presence. Use when building chat applications, collaborative tools, live dashboards, or streaming interfaces (LLM responses, metri...

282
implementing-api-patterns
implementing-api-patterns
ancoleman12/11/2025

API design and implementation across REST, GraphQL, gRPC, and tRPC patterns. Use when building backend services, public APIs, or service-to-service communication. Covers REST frameworks (FastAPI, Axum...

282
visualizing-data
visualizing-data
ancoleman12/11/2025

Builds dashboards, reports, and data-driven interfaces requiring charts, graphs, or visual analytics. Provides systematic framework for selecting appropriate visualizations based on data characteristi...

163
AI 95
performance-engineering
performance-engineering
ancoleman12/11/2025

When validating system performance under load, identifying bottlenecks through profiling, or optimizing application responsiveness. Covers load testing (k6, Locust), profiling (CPU, memory, I/O), and...

163
AI 92
managing-configuration
managing-configuration
ancoleman12/11/2025

Guide users through creating, managing, and testing server configuration automation using Ansible. When automating server configurations, deploying applications with Ansible playbooks, managing dynami...

163
AI 89
embedding-optimization
embedding-optimization
ancoleman12/11/2025

Optimizing vector embeddings for RAG systems through model selection, chunking strategies, caching, and performance tuning. Use when building semantic search, RAG pipelines, or document retrieval syst...

163
AI 83
ingesting-data
ingesting-data
ancoleman12/11/2025

Data ingestion patterns for loading data from cloud storage, APIs, files, and streaming sources into databases. Use when importing CSV/JSON/Parquet files, pulling from S3/GCS buckets, consuming API fe...

163
AI 82
writing-infrastructure-code
writing-infrastructure-code
ancoleman12/11/2025

Managing cloud infrastructure using declarative and imperative IaC tools. Use when provisioning cloud resources (Terraform/OpenTofu for multi-cloud, Pulumi for developer-centric workflows, AWS CDK for...

159
AI 94
implementing-service-mesh
implementing-service-mesh
ancoleman12/11/2025

Implement production-ready service mesh deployments with Istio, Linkerd, or Cilium. Configure mTLS, authorization policies, traffic routing, and progressive delivery patterns for secure, observable mi...

159
AI 87
testing-strategies
testing-strategies
ancoleman12/11/2025

Strategic guidance for choosing and implementing testing approaches across the test pyramid. Use when building comprehensive test suites that balance unit, integration, E2E, and contract testing for o...

159
AI 85
implementing-navigation
implementing-navigation
ancoleman12/11/2025

Implements navigation patterns and routing for both frontend (React/TS) and backend (Python) including menus, tabs, breadcrumbs, client-side routing, and server-side route configuration. Use when buil...

158
AI 95

Showing 18 of 22