
from claude-skill-registry431
Production-ready async SQLAlchemy 2.0+ patterns for FastAPI: session management, connection pooling, Alembic migrations, relationship loading strategies, and qu
Provides a compact, opinionated collection of patterns and templates to implement production-ready async SQLAlchemy (2.0+) in FastAPI projects. It codifies engine and async session setup, dependency patterns for DB sessions, base model mixins (timestamps, soft delete), relationship loading strategies to avoid N+1 queries, transaction and nested transaction patterns, bulk operations, streaming large query results, and Alembic migration templates. The package includes scripts and templates to bootstrap migrations and common examples to illustrate correct usage.
Use this skill when building or migrating a FastAPI application to async SQLAlchemy 2.0+, when you need reliable session management, when tuning connection pools for production, when generating and reviewing Alembic migrations, or when addressing performance issues like N+1 queries or heavy bulk operations. It is also useful during onboarding for teams that want standard DB patterns.
Best suited for coding assistants that can read and apply repository patterns (Claude Code, Copilot-like coding tools) and for maintainers working with Python/SQLAlchemy stacks.
This skill has not been reviewed by our automated audit pipeline yet.
Uloop: Execute Dynamic Code
Run small C# snippets in the Unity Editor via the uloop CLI for editor automation tasks like prefab wiring, AddComponent flows, and scene edits—without writing
Bookmarklet Creation
Generates browser-executable JavaScript bookmarklets with strict formatting (IIFE wrapper, block comments) and provides ready-to-install links or installer inst
Overnight — Autonomous Long-Running Coding
Orchestrates long-running coding goals: decomposes objectives into atomic tasks, dispatches isolated worktree workers, verifies acceptance criteria, and merges
Bexio API (Swiss CRM & Invoicing)
Integrate and manage Bexio contacts, quotes, invoices, orders and products via the Bexio API. Useful for CRM and Swiss business document workflows.
Content Research Writer
A writing-partner skill that helps research, outline, draft, cite, and iteratively improve articles, tutorials, and thought pieces.
Agent Hierarchy Diagram
Generate visual hierarchy diagrams (ASCII, Mermaid, GraphML) that show agent roles, levels, and delegation for documentation and onboarding.
Review Pull Request
Automated, structured PR reviewer: gathers metadata, diffs, CI results, dependency changes and provides a concise verdict with testing and documentation recomme
Agent Ops — Testing Workflow
Guidance for designing, running, and analyzing test suites for agents: test isolation, execution patterns, and coverage-based enforcement.
libagent
Agent orchestration library for conversational AI — coordinates LLM completions, memory, tool execution, and multi-turn flows; useful for building chat agents a
Raindrop.io API
Manage Raindrop.io bookmarks, collections, tags and highlights via the Raindrop REST API with helper scripts and examples.