Databases
SQL, NoSQL, and database management skills
4429 skills in this category
Subcategories
toast-notification-system
This skill creates toast/snackbar notification systems with animations and auto-dismiss.Supports React (react-hot-toast, Sonner), Vue 3 (vue-toastification), with success/error/warning/info types, positions, animations.Generates toast provider, toast functions, custom toast components, animations, accessibility (ARIA live regions).Activate when user says "toast notification", "show message", "success notification", "error toast", or needs feedback messages.Output: Complete toast system with provider, toast functions, animations, accessibility, and custom styles.
database-architecture
MANDATORY when designing schemas, writing migrations, creating indexes, or making architectural database decisions - enforces PostgreSQL 18 best practices including AIO, UUIDv7, temporal constraints, and modern indexing strategies
codex-review
MANDATORY quality gate. Run this skill BEFORE: (1) asking user "Is this okay?", (2) git commit, (3) creating PR, (4) presenting any implementation or design to user. Codex reviews in read-only sandbox, iterates until ok:true. NEVER skip this step.
hackage-read-docs
Retrieve documentation from Hackage. Use this Skill when you need a reference for Haskell packages, classes, or want to query package versions. (project)
database-query-helper
Helps query and analyze PostgreSQL databases. Use when the user asks about database queries, schema inspection, table relationships, or data analysis tasks. Can connect to local or remote PostgreSQL instances and execute safe, parameterized queries. Supports schema exploration, query optimization suggestions, and data export.
TanStack Table
Build headless data tables with TanStack Table v8. Provides server-side pagination, filtering, sorting, and virtualization patterns for Cloudflare Workers + D1 databases. Use when building tables with large datasets, coordinating with TanStack Query, or troubleshooting state management issues, pagination coordination errors, or performance bottlenecks.
managing-cache-and-optimization
Use when managing Shannon CLI performance and costs - check cache statistics, clear stale entries, set budgets, understand automatic model selection and cost optimization
redux-state-management
Master Redux Toolkit for production state management including slices, async thunks, RTK Query, and error handling
data-querying
Write and verify SQL queries with BigQuery. Use when executing bq commands, writing SQL queries, or including query results in documents. Trigger on "bq", "BigQuery", "query".
background-job-scheduler
This skill builds background job processing systems with queues, retries, and scheduling.Supports Python (Celery, RQ, Dramatiq), Node.js/Bun (Bull, BullMQ), with Redis/RabbitMQ backends.Creates async tasks, scheduled jobs (cron), retry logic, error handling, and monitoring.Activate when user says "background jobs", "async tasks", "queue system", "scheduled tasks", "process emails".Output: Complete job system with workers, queues, retries, monitoring, and deployment config.
using-next-devtools
Provides Next.js development integration tools. Primary tool for Next.js projects. Offers diagnostics, upgrades, Cache Components optimization, and automatic error fixes.
aiwf:backend-dev-guidelines
Comprehensive backend development guide for Node.js/Express/TypeScript microservices. Use when creating routes, controllers, services, repositories, middleware, or working with Express APIs, Prisma database access, Sentry error tracking, Zod validation, unifiedConfig, dependency injection, or async patterns. Covers layered architecture (routes → controllers → services → repositories), BaseController pattern, error handling, performance monitoring, testing strategies, and migration from legacy patterns.
aiwf:error-tracking
Add Sentry v8 error tracking and performance monitoring to your project services. Use this skill when adding error handling, creating new controllers, instrumenting cron jobs, or tracking database performance. ALL ERRORS MUST BE CAPTURED TO SENTRY - no exceptions.
typescript-write
Write TypeScript/React code following Semicolon team standards with DDD architecture,Supabase integration, and TDD approach. Use when developing Next.js features.
Sidekiq & Async Patterns
Complete guide to background job processing with Sidekiq in Ruby on Rails. Use this skill when: (1) Creating background jobs, (2) Configuring queues and workers, (3) Implementing retry logic and error handling, (4) Designing idempotent jobs, (5) Setting up scheduled/recurring jobs, (6) Optimizing job performance. Trigger keywords: background jobs, async, Sidekiq, workers, queues, ActiveJob, cron, scheduling, Redis, concurrency
redis-performance
Master Redis performance - memory optimization, slow log analysis, benchmarking, monitoring, and tuning strategies
pydantic-model-scaffolder
Scaffolds Pydantic models for request/response validation. Use when creating data models for API endpoints or database schemas.
subquery-patterns-and-union
Use OPAL subquery syntax (@labels) and union operations to combine multiple datasets or time periods. Essential for period-over-period comparisons, multi-dataset analysis, and complex data transformations. Covers @label <- @ syntax, timeshift for temporal shifts, union for combining results, and any_not_null() for collapsing grouped data.
resume-manager
This skill should be used whenever users need help with resume creation, updating professional profiles, tracking career experiences, managing projects portfolio, or generating tailored resumes for job applications. On first use, extracts data from user's existing resume and maintains a structured database of experiences, projects, education, and skills. Generates professionally styled one-page PDF resumes customized for specific job roles by selecting only the most relevant information from the database.
database-standard
Database design standards defining primary keys, foreign keys, audit fields, soft delete, junction tables. PostgreSQL style preferred, SQL lowercase without comments.