Database
Database management and queries
madai-investigator
by BenjaminG
Investigate MadAI/MadKudu support tickets from Jira or Zendesk. This skill should be used when analyzing ticket context, checking tenant health, querying knowledge bases, and producing structured investigation reports. Triggers on requests like "investigate this ticket", "look into Zendesk/Jira issue", "check tenant health", or "why is tenant X having issues".
nodel-recipes
by scroix
Write Nodel node recipes (script.py) using Jython 2.5 - define actions, events, parameters, TCP/UDP/HTTP protocols, and device control logic. Use when creating or modifying Nodel scripts.
nitro-datastore
by nitrosh
Use when working with JSON data in Python - nested dictionary access, querying collections, bulk transformations, or file-based config management
python-performance-optimization
by alfredang
Profile and optimize Python code using cProfile, memory profilers, and performance best practices. Use when debugging slow Python code, optimizing bottlenecks, or improving application performance.
redash
by jwmossmoz
Query Mozilla's Redash (sql.telemetry.mozilla.org) for telemetry data from BigQuery. Use when querying Firefox user telemetry, OS distribution, architecture breakdown, or running custom SQL against Mozilla's data warehouse. Triggers on "redash", "telemetry query", "sql.telemetry", "BigQuery query", "Firefox data", "client counts", "user population", "DAU", "MAU", "macOS version", "macOS distribution", "Apple Silicon", "aarch64", "x86_64", "architecture distribution", "Windows version", "Windows distribution", "how many users", "what share of users", "what percentage of Firefox users".
woltz-rich-domain
by tarcisioandrade
Guide for @woltz/rich-domain DDD library and ecosystem. Use when building domain models, repositories, or working with Prisma/TypeORM adapters.
legacy-archaeologist
by k1lgor
Use this to understand, document, and plan the refactoring of unknown, messy, or legacy codebases.
backend-development
by zircote
Build robust backend systems with modern technologies (Node.js, Python, Go, Rust), frameworks (NestJS, FastAPI, Django), databases (PostgreSQL, MongoDB, Redis), APIs (REST, GraphQL, gRPC), authentication (OAuth 2.1, JWT), testing strategies, security best practices (OWASP Top 10), performance optimization, scalability patterns (microservices, caching, sharding), DevOps practices (Docker, Kubernetes, CI/CD), and monitoring. Use when designing APIs, implementing authentication, optimizing database queries, setting up CI/CD pipelines, handling security vulnerabilities, building microservices, or developing production-ready backend systems.
supabase-postgres-best-practices
by alfredang
Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.
work-management
by ajshedivy
"Query, monitor, and analyze jobs on IBM i using SQL table functions via ibmi-mcp-server. Use when user asks about: (1) finding jobs by status, user, subsystem, or type, (2) monitoring active job performance (CPU, I/O, memory), (3) detecting long-running SQL statements, (4) analyzing lock contention, (5) checking job queues, (6) replacing WRKACTJOB, WRKUSRJOB, WRKSBSJOB, WRKSBMJOB commands, or (7) any IBM i work management task."
win11-24h2-files
by jwmossmoz
Query Windows 11 version 24H2 cumulative update file information. Search for DLLs, drivers, and system files across all patch levels. Compare file versions between builds, track version history, and identify what changed in each update. Use when: (1) investigating which Windows build introduced a file version, (2) comparing file changes between patches, (3) finding DLL/driver versions for specific builds, (4) debugging Windows update regressions, (5) user asks about Windows 11 24H2 files, KB updates, or build versions.
applying-architecture-patterns
by MrPointer
Implement proven backend architecture patterns including Clean Architecture, Hexagonal Architecture, and Domain-Driven Design. Use when (1) designing new backend systems from scratch, (2) refactoring monolithic applications for better maintainability, (3) establishing architecture standards for a team, (4) migrating from tightly coupled to loosely coupled architectures, (5) implementing domain-driven design principles, (6) creating testable and mockable codebases, or (7) planning microservices decomposition.
task-discovery
by jwmossmoz
Discover Firefox CI tasks by worker pool. Query the Taskcluster task graph to find tasks assigned to specific worker types. Use when planning worker pool migrations, crafting mach try pushes, or auditing which tasks run on a pool. Triggers on "discover tasks", "find tasks", "worker pool tasks", "task discovery", "which tasks run on".
go-testing
by MolcajeteAI
This skill should be used when writing, reviewing, or debugging Go tests. It covers table-driven tests, test organization, assertions, mocking patterns, coverage analysis, benchmarking, integration tests, race detection, and test quality standards.
pgtool
by ThilinaTLM
PostgreSQL database exploration and debugging. Use when user asks to explore database schemas, tables, columns, or run queries. Requires a .pgtool.json file in the project directory.
sequential-thinking
by zircote
Use when complex problems require systematic step-by-step reasoning with ability to revise thoughts, branch into alternative approaches, or dynamically adjust scope. Ideal for multi-stage analysis, design planning, problem decomposition, or tasks with initially unclear scope.
backend-developer
by BenjaminG
Specialist for TypeScript backend development including Node.js servers, NestJS applications, APIs, databases (PostgreSQL, MongoDB, Redis), authentication, testing, deployment, server-side code, microservices, database queries, migrations, controllers, services, repositories, and middleware. Use for ANY work involving .ts backend files, server-side architecture, performance optimization, and backend security.
os-integrations
by jwmossmoz
Run Firefox mach try commands with pre-configured flags for os-integration testing on Windows and Linux alpha worker pools. Use when testing Firefox changes against Windows 10, Windows 11, Ubuntu 24.04, hardware workers, ARM64, or AMD configurations. Triggers on "os-integration", "mach try", "windows testing", "linux testing", "alpha image".
warden-dev
by lbajsarowicz
Manage Docker-based local development environments with Warden. Use when setting up PHP/Node projects (Magento, Laravel, Symfony, WordPress, Drupal), importing databases, running shell commands, debugging with Xdebug, or managing Docker services. Triggers on "warden", "local environment", "docker-compose wrapper", "database import", "shell access".
python-performance-optimization
by spjoshis
Profile and optimize Python code using cProfile, memory profilers, and performance best practices. Use when debugging slow Python code, optimizing bottlenecks, or improving application performance.
async-python-patterns
by spjoshis
Master Python asyncio, concurrent programming, and async/await patterns for high-performance applications. Use when building async APIs, concurrent systems, or I/O-bound applications requiring non-blocking operations.
practical-react-query
by mhdcodes
Comprehensive guide to React Query (TanStack Query) covering data fetching, caching, mutations, error handling, TypeScript, testing, and advanced patterns. Use when working with React Query, TanStack Query, or async state management in React applications.
sql-analysis
by spjoshis
Master SQL for data analysis with complex queries, joins, aggregations, window functions, and query optimization.
deepbook-trading
by RandyPen
Helps Claude Code understand DeepBook V3 SDK usage for order book trading, flash loans, fund management, and market data queries on Sui blockchain. Use when operating DeepBook DEX, executing trading strategies, or querying market data.