database-operations
Instructions on how to write database queries with SQLAlchemy.
Discover Research skills, compare source repositories and read the instructions for each workflow.
Instructions on how to write database queries with SQLAlchemy.
SQLAlchemy and database patterns for Python. Triggers on: sqlalchemy, database, orm, migration, alembic, async database, connection pool, repository pattern, unit of work.
Quick reference for common SQL patterns, CTEs, window functions, and indexing strategies. Triggers on: sql patterns, cte example, window functions, sql join, index strategy, pagination sql.
Create interactive examples for human validation. Use when code is implemented and ready for human testing. Provides procedures for creating demos, documentation, and test scenarios.
Generate comprehensive test cases from technical design before implementation. Follows TDD approach - write tests first, then implement. Queries feature board, reads technical design, creates all test files. Us...
Dig to fundamental truths and real causes behind problems. Use when user asks "why does this happen", "what's the real problem", "root cause", "first principles", "jobs to be done", "JTBD", "five whys", "fundam...
Create or update the user manual (README.md) with instructions on how to install, configure, and run the application. Use when minimum features are implemented or when specifically asked to document how to run...
Senior Technical Writer & Docs Architect. Expert in AI-driven documentation synchronization, style guide enforcement, and 2026 Markdown standards.
Converts high-level architecture into detailed, human-readable Technical Specifications. The bridge between Architect and Developers.
Generates architecture diagrams from code, infrastructure, or descriptions. Use when user asks to visualize, diagram, or document system architecture.
Sentry issue triage and investigation with automatic cross-linking. Handles issue investigation, AI analysis via Seer, and integration with Linear for tracking fixes. Use when triaging Sentry errors, investigat...
WHEN to auto-invoke: Debugging issues, fixing bugs, investigating errors, "not working" problems, unexpected behavior, stack traces, error messages, troubleshooting, "why is this happening". WHEN NOT to invoke:...
WHEN to auto-invoke: Debugging issues where root-cause-analysis already identified the problem, implementing fixes for diagnosed bugs, applying systematic debugging methodology, stuck on a bug after initial inv...
Systematic debugging methodology with root cause analysis. Phases: investigate, hypothesize, validate, verify. Capabilities: backward call stack tracing, multi-layer validation, verification protocols, symptom...
Analyze Claude Code session logs - extract thinking blocks, tool usage stats, error patterns, debug trajectories. Triggers on: introspect, session logs, trajectory, analyze sessions, what went wrong, tool usage...
Deep explanation of complex code, files, or concepts. Routes to expert agents, uses structural search, generates mermaid diagrams. Triggers on: explain, deep dive, how does X work, architecture, data flow.
Your project awareness buddy. Knows current state, reads docs, analyzes code, answers "where are we?" questions. Activate with "bro" or "project-bro".
Diagnose MCP validation dependencies (Brave Search, Chrome DevTools) and output exact setup snippets.
Senior WebGPU & 3D Graphics Architect for 2026. Specialized in Three.js v172+, WebGPU-first rendering, TSL (Three Shader Language), and high-performance React 19 integration via `@react-three/fiber` and `@react...
Research-driven critique and enhancement of Amelia architecture or ideas docs. Use with GPT-5.2 when given a design/architecture doc to analyze concepts, find sources, and propose improvements plus OSS candidat...
Debug and improve the Bifrost vibe coding experience. Use this skill when working on Bifrost platform development in Claude Code where you have access to Bifrost source code. Helps identify system bugs vs docum...
Contains MANDATORY BullMQ and async patterns for Tzurot v3. MUST be consulted before working with jobs, Discord deferrals, or retry logic. Covers queue architecture, idempotency, and error handling.
Use when creating types, constants, Zod schemas, or working with data validation. Covers common-types package organization, runtime validation, and type guards across microservices.
Best practices for using the Council MCP server in Tzurot v3 development - When to consult external AI, how to structure prompts, model selection, and multi-turn conversations. Use when planning major changes o...
The default order uses GitHub repository stars from our indexed data. Stars belong to the source repository and may be shared by multiple skills. They indicate repository interest, not skill installs or an independent quality score.