Databases
SQL, NoSQL, and database management skills
4429 skills in this category
Subcategories
agentuity-cli-cloud-db-delete
Delete a database resource. Requires authentication. Use for Agentuity cloud platform operations
Backend API
Design and implement NestJS REST API endpoints following the project's layered architecture (Controllers, Use Cases, Repositories). Use this skill when creating or modifying controller files (*.controller.ts), defining API routes, implementing HTTP handlers, setting up Swagger documentation, configuring route guards and decorators, working with request/response DTOs, or structuring API endpoints. This includes files in features/{feature}/controller/, auth/controller/, and any file with @Controller() decorator. Apply when working with API_ENDPOINTS constants, @Get/@Post/@Put/@Patch/@Delete decorators, @ApiTags/@ApiProperty swagger decorators, @Public/@MemberRoles custom decorators, HttpCode/HttpStatus configurations, or Query/Param/Body parameter decorators.
querying-logseq-data
Expert in building Datalog queries for Logseq DB graphs. Auto-invokes when users need help writing Logseq queries, understanding Datalog syntax, optimizing query performance, or working with the Datascript query engine. Covers advanced query patterns, pull syntax, aggregations, and DB-specific query techniques.
vsa-ui-enhancer
Vertical Slice Architecture (VSA) 向け UI 強化スキル。 Phase 1(spec-kit + カタログ)で生成されたプレーンな .razor ファイルを、 Phase 2 で MudBlazor ベースのリッチな UI に変換する。 アーキテクチャには一切手を触れず、UI だけを強化する。
nestjs
Provides NestJS framework development standards and architectural patterns. Ensures domain-centric architecture, proper dependency injection, and decorator pattern utilization. Specializes in modular design, providers and services, middleware and guards, interceptors and pipes, custom decorators, and microservices architecture.Use when: developing NestJS applications, designing module structure (@Module), creating controllers (@Controller) and services (@Injectable), implementing REST or GraphQL APIs, configuring dependency injection, building middleware and guards, creating custom decorators, implementing authentication/authorization, designing microservices with NestJS, or integrating with TypeORM/Prisma for database access.
code-reuse-enforcement
CRITICAL guardrail for preventing code duplication and magic strings in the AIDB codebase. Enforces discovery of existing constants, enums, and utilities BEFORE writing new code.
supabase-operations
This skill should be used when the user asks to "list posters", "get poster info", "fetch context document", "get latest poster", "check poster count", "show poster details", "get context for poster", "show enrichment quality", "diagnose enrichment", "show pulse script", "get all poster data", "check what data we have", or mentions Supabase, posters, context documents, enrichment, or database queries. Provides commands and scripts for querying Local Pulse poster data from Supabase.
observability
Use when diagnosing operation failures, stuck or slow operations, querying Jaeger traces, working with Grafana dashboards, debugging distributed system issues, or investigating worker selection and service communication problems.
wordpress-plugin-core
Build secure WordPress plugins with core patterns for hooks, database interactions, Settings API, custom post types, REST API, and AJAX. Covers three architecture patterns (Simple, OOP, PSR-4) and the Security Trinity. Use when creating plugins, implementing nonces/sanitization/escaping, working with $wpdb prepared statements, or troubleshooting SQL injection, XSS, CSRF vulnerabilities, or plugin activation errors.
code-review
This skill should be used when reviewing code or preparing code for review. It provides guidelines for what to look for in reviews, how to write constructive feedback, and standards for review comments.
create-repository
Create repository interface for data access abstraction. Use when adding a new resource that needs database operations, defining CRUD interface, or setting up repository pattern. Triggers on "new repository", "repository interface", "data access layer", "create repository".
aws-rds-setup
Deploy and configure RDS/Aurora databases with HA and security
aidb-architecture
Comprehensive architectural reference for AIDB core and MCP integration. Covers 6-layer architecture (MCP, Service, Session, Adapter, DAP Client, Protocol), component organization, data flow patterns, and design decisions. Use when explaining overall system design or understanding how layers interact.
architecture-validator
Validates architecture documentation completeness by checking for technology stack, API specifications, database schema, security architecture, and alignment with feature specification. Ensures plan.md is complete before implementation.
Global Tech Stack
Understand and utilize the project's technology stack including NestJS, Next.js, Prisma, PostgreSQL, and TypeScript. Use this skill when making technology decisions, when choosing libraries or packages, when understanding framework-specific patterns, or when configuring development tools. This includes NestJS with feature-based modular architecture, Next.js 15 with App Router, Prisma ORM for database access, PostgreSQL, TypeScript with strict mode, pnpm for package management, Turborepo for monorepo orchestration, and shared workspace packages. Apply when setting up new features, choosing dependencies, or understanding the overall system architecture.
watch-uat-azdo-pr
Watch an Azure DevOps UAT PR for maintainer feedback or approval by polling threads and reviewer votes until approved/passed.
agentuity-cli-cloud-redis-show
Show Redis connection URL. Requires authentication. Use for Agentuity cloud platform operations
agentuity-cli-cloud-db-get
Show details about a specific database. Requires authentication. Use for Agentuity cloud platform operations
debugging
Production-grade skill for C++ debugging. Covers GDB, LLDB, sanitizers, memory debugging, crash analysis, and systematic bug investigation techniques.
supabase-automation
Master Supabase CLI automation, auth configuration, edge functions, secrets management, MCP integration, and Management API for production deployments