Databases

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

Design robust, scalable backend architectures that complement Design OS frontend components. Use this skill when planning APIs, database schemas, and server-side logic for products designed in Design OS.

Discover all resources in your Amplify sandbox (DynamoDB tables, Lambda functions, data models, auth config) by reading amplify_outputs.json and querying AppSync.

Use this skill to query your Google NotebookLM notebooks directly from Claude Code for source-grounded, citation-backed answers from Gemini. Browser automation, library management, persistent auth. Drastically reduced hallucinations through document-only responses. This is a test.

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.

Enrich a Github [DB] entry with GitHub API metadata (description, stars, language, cover image). Use when user wants to populate a GitHub repo entry with live metadata, enhance github entry, or add github info.

Master backend development, API design, server architecture, database integration, authentication, microservices, and production patterns. Includes Node.js, GraphQL, Spring Boot, ASP.NET Core, and PHP frameworks.

Detect N+1 query patterns in the codebase. Finds loops that contain database or API calls that should be batched. Works across all languages. Use when user asks to find performance issues or N+1 patterns.

React/TypeScript development guidelines. Suspense, lazy loading, useSuspenseQuery, features directory, MUI v7, TanStack Router, performance optimization. USE WHEN creating components, pages, features, data fetching, styling, routing, or frontend work.

[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.

Use for code review and quality feedback from both Codex and Gemini. Triggers on "council review code", "council code review", "have council review this", "get council feedback on code".

Datadog CLI for searching logs, querying metrics, tracing requests, and managing dashboards. Use this when debugging production issues or working with Datadog observability.

Analyze git diff to identify code changes requiring documentation updates. Categorizes changes (database/schema, API endpoints, components, configuration, authentication) and suggests relevant documentation files to review. Use when: (1) After making code changes, (2) Before committing significant changes, (3) When adding new features or modifying APIs, (4) During PR preparation, (5) When working with database schemas, API routes, components, or configuration files, (6) To ensure documentation stays synchronized with code changes, (7) For documentation sync and maintenance, or (8) For pre-commit documentation checks. Triggers: check docs, docs check, documentation check, update docs, sync documentation, what docs need updating, check if docs are up to date, after code changes, before committing.

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.

AI-powered Telemetry Validator Agent that verifies instrumentation works in sandbox environments. Use when: (1) Validating OTel spans are emitted correctly, (2) Verifying correlation headers in Kafka messages, (3) Confirming OpenLineage events for data pipelines, (4) Generating validation evidence for merge approval. Triggers: "validate telemetry", "verify instrumentation", "check OTel spans", "validate correlation headers".