資料庫
SQL、NoSQL 和資料庫管理技能
4429 skills in this category
Subcategories
bulk-operations-patterns
Bulk data operations with Excel import/export, batch processing, and validation for ABP Framework. Use when: (1) implementing bulk import/update from Excel/CSV, (2) batch processing with progress tracking, (3) file upload with validation, (4) bulk database operations with InsertManyAsync/UpdateManyAsync.
fastapi-code-review
Comprehensive code review skill for FastAPI projects. Analyzes codebase against industry best practices covering async patterns, project structure, Pydantic usage, dependency injection, database patterns, testing, and performance. Generates detailed refactor plans with prioritized recommendations. Use when reviewing FastAPI projects, auditing code quality, planning refactors, or ensuring adherence to FastAPI/async best practices.
db-e-report
提供v3_e-report数据库的SQL查询模板,包括数据分析告警配置等表的查询。查询分析告警配置时使用。使用 exec_sql 工具执行查询。
bloodbank-event-publisher
Complete guide for creating, publishing, and consuming events in the DeLoNET home network's 33GOD agentic developer pipeline. Built on RabbitMQ with strict type safety via Pydantic, async Python (aio-pika), FastAPI, and Redis-backed correlation tracking. This skill is REQUIRED for any work involving the home network event bus.
temporal-ai-skill
Interface for managing the Temporal Database and AI system (ReDB + GGUF embeddings).
health-check
Validate MSA development environment and tool availability. Use when (1) new MSA developer onboarding, (2) checking required tools (gh CLI, Git, Node, pnpm, Prisma, gRPC), (3) verifying GitHub auth and repo access, (4) orchestrator auto-runs at work start.
mcp-leann
Lightweight vector database providing semantic code search with 97% storage savings. Uses graph-based selective recomputation for efficient RAG on codebases, documents, and any text content. Provides build, search, and ask commands via MCP integration.
drizzle-db
Query the project's database using Drizzle ORM. Use when the user asks about database contents, schema inspection, or data queries. Supports read-only mode for safety.
redis-cache
Auditar a camada de cache Redis reativa (lettuce), garantindo binding de secrets, TTLs e métricas consistentes no Swarm.
noop-architecture
Guide for implementing code following the noop function-first, layered architecture. Use when writing handlers, services, database operations, or middleware. Automatically invoked when working on noop-based projects.
zod-docs
Query and manage local Zod documentation mirror (59 docs). Search Zod topics for TypeScript-first schema validation, parsing, type inference, refinements, and transformations. Use when implementing validation or answering Zod-related questions. (user)
taiga-api
Query the hosted Taiga API at taiga.ant.dev for job results, passrates, transcripts, and run evaluations. Use when user asks about Taiga jobs, problem scores, eval results, or needs to submit/check jobs.
data-pipeline
Implement Scrapy pipeline patterns for data processing, validation, cleaning, and storage when processing scraped items. Automatically creates pipelines for common data workflows including CSV, JSON, database export, and data transformation.
dashboard
Create interactive analytics dashboards with React components from drizzle-cube/client. Use when building dashboards, configuring portlets, setting up grid layouts, or creating analytics UIs with drizzle-cube React components.
system-architect
Designs and validates system architecture, database schemas, and technical approaches
owasp-security-review
Security review and implementation support based on OWASP Cheat Sheet Series. Use for code review requests, security-related implementation/research, and vulnerability checks. Covers security topics such as XSS, SQL Injection, CSRF, and authentication/authorization.
video-processor
Comprehensive video processing toolkit for content analysis, transcription, frame extraction, and documentation generation. Use when working with video files (.mp4, .avi, .mov, .mkv) or YouTube URLs for transcribing video content and generating subtitles, extracting and analyzing frames at intervals or timestamps, creating summaries and reports from video content, extracting metadata and technical information, processing video from filesystem, YouTube, or database sources, or generating documentation from training videos or tutorials. Supports automatic YouTube URL detection and downloading with extended metadata (channel, views, likes, tags).
migration-patterns
Guide developers through database migration best practices including versioning, rollbacks, and zero-downtime strategies
backend
Universal Python/Node.js backend expert. Handles API routes, database operations, business logic, configuration management, anti-duplication checks. Auto-activates on keywords "backend", "API", "database", "server", "endpoint", "Python", "FastAPI" or paths api/**, services/**, models/**.
backend-python
Modern Python backend stack: FastAPI, SQLAlchemy 2.0, Pydantic v2, uv, ruff.Use when: building Python APIs, async services, or working with Python backend code.Triggers: "fastapi", "python backend", "sqlalchemy", "pydantic", "uv", "ruff","python api", "async python".