SQL

Expert-level Vercel AI SDK v5 patterns for production chatbots. Use for: (1) Chat persistence with Drizzle/PostgreSQL, (2) Generative UI with typed tool parts, (3) Human-in-the-loop tool confirmations, (4) Custom data streaming with reconciliation, (5) Anthropic provider with extended thinking/reasoning, (6) Type-safe message metadata with token tracking. Covers advanced patterns only - assumes basic AI SDK knowledge. NOT for AI SDK v6.

Use when working with embeddings, semantic similarity, vector search, or the <-> <#> <=> operators. Load for pgvector queries, HNSW index creation, embedding storage, or similarity calculations. Covers distance operators, index strategies, and common pitfalls with 384-dimensional vectors.

Generates comprehensive role-based permission matrices in markdown or SQL format for pages, components, and data access patterns. This skill should be used when designing authorization systems, documenting permissions, creating RBAC tables, or planning access control. Use for RBAC, role permissions, access control, authorization matrix, permission mapping, or security policies.

Works with PostgreSQL including queries, migrations, indexes, and performance tuning. Use when designing database schemas, writing SQL queries, optimizing performance, or managing PostgreSQL databases.

Database design, SQL queries, migrations, and optimization. Activate for PostgreSQL, MySQL, SQLite, schema design, queries, indexes, and data modeling.

Build the FastAPI-based RAG service using OpenAI Agents/ChatKit, Neon Postgres, and Qdrant for the textbook. Use when creating ingestion pipelines, query endpoints, or configuring vector storage for book content.

Go backend development assistant for building production-ready services with modern 2025 best practices. Supports project initialization, framework selection (Gin/Chi/Echo/Fiber), database layer (pgx/sqlc/GORM), and API development. Activated when users mention "Go", "Golang", "고랭", "백엔드", or need Go service development help.

Comprehensive Bun runtime expertise covering all major features.Use when working with Bun projects, migrating from Node.js, or leveraging Bun-specific APIs.Activates for: Bun.serve, Bun.file, bun:test, bun:sqlite, bun install, bun build,bunfig.toml, TypeScript in Bun, package manager operations, bundler configuration,and Node.js compatibility questions.

Automatically designs, initializes, implements, validates, and packages new skills from a single high-level request. Use when the user gives a short, possibly vague description like "社内Redshift向けのSQLヘルパースキル作って" and wants a complete, production-ready .skill file generated with minimal manual intervention.

SQL expert for Rice Data Portal queries using DuckDB SQL. ALWAYS use this skill when data is requested from the Rice stock market database (tickers, prices, fundamentals, insider trades, valuation metrics, etc.). When users request monthly/weekly returns OR momentum, this skill automatically calculates BOTH metrics from end-of-month or end-of-week prices. Returns are expressed as decimals (not percentages). This ensures proper SQL generation, filename prompting, and multi-format file saving. Do NOT use this skill for analyzing local CSV/Parquet files that are already saved.

[Extends backend-developer] Python FastAPI specialist. Use for FastAPI apps, async endpoints, Pydantic v2, SQLAlchemy async, dependency injection. Invoke alongside backend-developer for Python API projects.

Add SQLite database to Flask or Sinatra app with beginner-friendly code examples and teaching comments

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.

Manage hierarchical project plans in SQLite. Tree-based structure with phases and tasks. Multiple output formats (text, JSON, XML, markdown).

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.

Эксперт DB replication. Используй для настройки репликации MySQL, PostgreSQL, MongoDB, failover и high availability.

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.

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.

SQL for data analysis with exploratory analysis, advanced aggregations, statistical functions, outlier detection, and business insights. 50+ real-world analytics queries.

Go database integration patterns using sqlx, pgx, and migration tools like golang-migrate