Writing efficient SQL queries requires knowing common patterns and anti-patterns. This skill provides ready-to-use examples for CTEs, window functions, joins, and indexing strategies.

Learn patterns for SQLite databases in Python projects. Includes connection management, async operations, migrations, and common schema designs for state, cache, and event logging.

Web applications face constant security threats from injection attacks, authentication bypasses, and data breaches. This skill provides actionable security patterns and OWASP Top 10 guidance to help you write secure code and identify vulnerabilities before they become exploits.

Designing RESTful APIs correctly requires understanding HTTP methods, status codes, caching strategies, and rate limiting. This skill provides quick reference patterns so you can build standards-compliant APIs from the start.

Python type hints improve code quality and catch bugs at development time. This skill provides patterns and examples for using type annotations, generics, protocols, and type checkers like mypy and pyright.

Writing maintainable tests is challenging without guidance. This skill provides proven pytest patterns for fixtures, parametrization, mocking, async testing, and coverage to help you build reliable test suites.

Python applications often lack clear logging, metrics, and tracing, making debugging difficult in production. This skill provides ready-to-use patterns for structlog, Prometheus metrics, and OpenTelemetry distributed tracing.

FastAPI is a modern Python web framework for building APIs. This skill provides ready-to-use patterns for dependency injection, validation, middleware, and background tasks. Developers can quickly implement production-ready APIs without searching through documentation.

Creating and managing Python virtual environments requires learning multiple tools and flags. This skill provides instant access to uv patterns for fast environment setup, package installation, and dependency management.

Writing database code is complex and error-prone. This skill provides battle-tested SQLAlchemy 2.0 patterns for models, queries, async sessions, transactions, and migrations.

Creating command-line interfaces in Python requires understanding argument parsing, output formatting, and configuration management. This skill provides ready-to-use patterns for building professional CLI tools with Typer and Rich libraries.

Writing concurrent Python code requires understanding specific patterns and avoiding common pitfalls. This skill provides production-ready asyncio patterns for building high-performance applications with proper error handling, graceful shutdown, and optimized resource management.

Project plans often become outdated as work progresses. This skill monitors docs/PLAN.md and alerts you when plans are stale compared to git activity, suggesting appropriate commands to sync or update your documentation.

Creating MCP servers requires understanding Model Context Protocol patterns. This skill provides ready-to-use code examples and best practices for tools, resources, authentication, and state management so you can build integrations faster.

Git workflows can be complex and hard to remember. This skill provides quick reference guides for lazygit, GitHub CLI, and delta to streamline staging, commits, PRs, rebasing, and more.

Perform find-and-replace operations across multiple files using the sd CLI tool. The tool simplifies text replacement with regex support and safer defaults than traditional sed.

Finding files and searching code can be slow with standard tools. This skill provides quick reference for fd, ripgrep, and fzf to search and filter files instantly. Use these tools to locate code, navigate projects, and filter search results with minimal effort.

Teams waste time searching for project conventions and agent instructions scattered across multiple files. This skill automatically finds all AI assistant documentation (CLAUDE.md, AGENTS.md, COPILOT.md, and 20+ formats) and creates a unified reference guide.

Developers need to extract, filter, and transform data from configuration files and API responses. This skill provides ready-to-use patterns for jq and yq so you can quickly query and modify structured data without memorizing syntax.

Creating container deployments requires understanding Docker best practices, Kubernetes manifests, and Helm charts. This skill provides production-ready patterns and templates for containerized applications.