SQL Optimization Patterns
Seth Hobson· Community
A comprehensive guide to optimizing SQL database performance through indexing, query plan analysis, and efficient coding patterns.
Skills from Seth Hobson’s repositories that passed our trust, licence and security gates. Each keeps its author’s attribution.
| Repository | Tier | Verdict | Authorship | Checked | Skills |
|---|---|---|---|---|---|
| wshobson/agents | Maintainer | Approved · created 2025-07-24, pushed 2026-11-05, 42281 stars | Community contributions | 2026-11-07 | 387 |
Files are mirrored only where the licence allows redistribution; otherwise we link to the source.
Seth Hobson· Community
A comprehensive guide to optimizing SQL database performance through indexing, query plan analysis, and efficient coding patterns.
Seth Hobson· Community
A framework for managing project context as structured, version-controlled documentation to align AI-assisted development.
Seth Hobson· Community
A systematic approach to refactoring legacy codebases and migrating outdated frameworks using incremental modernization patterns.
Seth Hobson· Community
A specialized security auditor for identifying vulnerabilities in backend code and architecture during feature development.
Seth Hobson· Community
An expert diagnostic tool for analyzing logs, identifying error patterns, and pinpointing root causes across distributed systems.
Seth Hobson· Community
Master memory forensics and incident response using the Volatility framework and industry-standard acquisition tools.
Seth Hobson· Community
Master advanced Git techniques for history management, bug isolation, and recovery.
Seth Hobson· Community
An expert Kubernetes architect specializing in cloud-native infrastructure, GitOps workflows, and container orchestration.
Seth Hobson· Community
Best practices for designing, sizing, and configuring multi-agent teams for complex development tasks.
Seth Hobson· Community
An expert FastAPI developer focused on high-performance, async-first API architecture and production-ready microservices.
Seth Hobson· Community
Align fine-tuned models with human preference data using DPO, ORPO, KTO, or SimPO methods.
Seth Hobson· Community
Master modern responsive design techniques using container queries, fluid typography, and content-driven breakpoints.
Seth Hobson· Community
Master modern UI component architecture, composition patterns, and styling strategies for React, Vue, and Svelte.
Seth Hobson· Community
Optimizes content structure to increase the likelihood of achieving featured snippets and SERP features.
Seth Hobson· Community
An expert Python developer persona focused on modern 3.12+ features, high-performance patterns, and the latest 2024/2025 ecosystem tools.
Seth Hobson· Community
An expert backend architect for designing scalable, resilient, and maintainable microservices and API-driven systems.
Seth Hobson· Community
An independent gatekeeper for LLM fine-tuning that manages evaluation harnesses, baselines, and checkpoint promotion decisions.
Seth Hobson· Community
A structured audit and repair framework for validating PPTX files for geometry, accessibility, and OOXML integrity.
Seth Hobson· Community
A comprehensive framework for conducting effective, constructive, and collaborative code reviews that improve software quality and team culture.
Seth Hobson· Community
A comprehensive guide and template library for implementing mutual TLS (mTLS) to secure service-to-service communication in zero-trust environments.
Seth Hobson· Community
An expert backend architect for designing scalable, resilient, and maintainable API-driven systems and microservices.
Seth Hobson· Community
An expert startup business analyst providing data-driven strategic guidance for early-stage founders.
Seth Hobson· Community
An expert security auditor providing comprehensive DevSecOps, compliance, and cybersecurity guidance.
Seth Hobson· Community
An expert data scientist persona for advanced analytics, machine learning, and statistical modeling.