資料庫
SQL、NoSQL 和資料庫管理技能
4429 skills in this category
Subcategories
sqlite-integration-for-beginners
Add SQLite database to Flask or Sinatra app with beginner-friendly code examples and teaching comments
mongodb-find-queries
Master MongoDB find queries with filters, projections, sorting, and pagination. Learn query operators, comparison, logical operators, and real-world query patterns. Use when retrieving data from MongoDB collections.
mongodb-authentication
Master MongoDB authentication methods including SCRAM, X.509 certificates, LDAP, and Kerberos. Learn user creation, role assignment, and securing MongoDB deployments.
testing
Writes tests using Vitest and Testing Library. Use when creating unit tests, API tests, component tests, or mocking Firebase/external services. Includes test patterns, assertions, and coverage targets.
databases
Work with MongoDB (document database, BSON documents, aggregation pipelines, Atlas cloud) and PostgreSQL (relational database, SQL queries, psql CLI, pgAdmin). Use when designing database schemas, writing queries and aggregations, optimizing indexes for performance, performing database migrations, configuring replication and sharding, implementing backup and restore strategies, managing database users and permissions, analyzing query performance, or administering production databases.
jelly-metabase-skill
Interact with Metabase analytics and BI platform for querying dashboards, retrieving card results, and exporting data. Activated when users mention "Metabase", "대시보드", ask about analytics dashboards, or need BI data exports.
transaction-expert
Transaction 경계 전문가. TransactionManager(단일 Port persist), ReadManager(단일 Query Port findBy/get),CommandFacade(2+ Manager persist* 조합), QueryFacade(2+ ReadManager fetch* 조합).@Transactional 메서드 단위 필수. @Component 사용. @Service 금지.
planz
Manage hierarchical project plans in SQLite. Tree-based structure with phases and tasks. Multiple output formats (text, JSON, XML, markdown).
evaluator
Skill evaluation and telemetry framework. Collects anonymous usage data and feedback via GitHub Issues and Projects. Privacy-first, opt-in, transparent. Helps improve ClaudeShack skills based on real-world usage. Integrates with oracle and guardian.
better-chatbot
This skill provides project-specific coding conventions, architectural principles, repository structure standards, testing patterns, and contribution guidelines for the better-chatbot project (https://github.com/cgoinglove/better-chatbot). Use this skill when contributing to or working with better-chatbot to understand the design philosophy and ensure code follows established patterns.Includes: API architecture deep-dive, three-tier tool system (MCP/Workflow/Default), component design patterns, database repository patterns, architectural principles (progressive enhancement, defensive programming, streaming-first), practical templates for adding features (tools, routes, repositories).Use when: working in better-chatbot repository, contributing features/fixes, understanding architectural decisions, following server action validators, implementing tools/workflows, setting up Playwright tests, adding API routes, designing database queries, building UI components, handling multi-AI provider integrationKeywor
duckdb-lakehouse
DuckDB data lakehouse development with Dagster orchestration and Apache Iceberg integrationfor floe-platform. Use when: (1) Building data pipelines with DuckDB as compute engine,(2) Configuring dbt-duckdb with Polaris plugin, (3) Reading/writing Iceberg tables viaPolaris catalog, (4) Creating Dagster assets with DuckDB, (5) Designing catalog-firstlakehouse architecture, (6) Connecting to REST catalogs with inline credentials.
tenant-db-ops
マルチテナント(顧客別DB分離)のDB運用・マイグレーション・調査に使う。
database-replication-setup
Эксперт DB replication. Используй для настройки репликации MySQL, PostgreSQL, MongoDB, failover и high availability.
protondb
Analyze ProtonDB game compatibility and provide optimized Linux gaming configurations. Use when checking if games work on Linux, optimizing launch options, or troubleshooting gaming issues on AMD GPU + Wayland + Arch Linux.
database-ops
Manages Prisma schema operations, database migrations, and data relationships for the digital marketplace. Use when working with database schema changes, product data models, or subscription management tables.
parallel-session-orchestration
Run multiple agent tasks in parallel cloud sandboxes with real-time progress monitoring, achieving 2x throughput vs sequential execution. Use for multi-repo tasks, independent bug fixes, concurrent feature development, or team workflows requiring parallel workstreams. Supports session management, result aggregation, and local teleport. Triggers on "parallel tasks", "multiple repos", "concurrent work", "parallel sessions", "multi-repo".
docker-compose-config
Docker Compose configuration template and validation logic for MetaSaver monorepos. Includes 4 required standards (PostgreSQL service with project-prefixed env vars like RUGBYCRM_POSTGRES_USER or METASAVER_SILVER_POSTGRES_USER for multi-db, project-specific naming for containers and networks, volumes section, service health checks). Use when creating or auditing docker-compose.yml files.
style-master
Expert CSS and frontend styling specialist that analyzes codebases, maintains style guides, suggests improvements, and stays current with modern design patterns. Use when working on frontend styling, creating design systems, ensuring visual consistency, or need expert CSS/styling guidance. Integrates with oracle, summoner, and wizard.
commit-staged
Creates git commits for already-staged changes following conventional commit format. ALWAYS check git diff --cached FIRST to verify staged changes. Use when user asks to commit staged changes, create a commit, or mentions commit-staged. Generates concise one-liner messages or overview with bullet points. Never stages files - only commits what user already staged.
sqlalchemy-orm
SQLAlchemy Python SQL toolkit and ORM with powerful query builder, relationship mapping, and database migrations via Alembic