Databases

Guide developers through PostgreSQL setup, connection configuration, query patterns, and best practices

Build MCP (Model Context Protocol) servers to extend Claude's capabilities with database access, API integrations, or custom tools.

Track and nurture knowledge maturation. Use when user mentions "incubate", "mature", "grow knowledge", "promotion", "level up learning". Auto-trigger at end of sessions or when pattern is repeated multiple times.

TanStack Start full-stack React framework. Use for: server functions with createServerFn, TanStack Router file-based routing, TanStack Query SSR integration, Cloudflare Workers deployment.

TMDB API integration specialist for fetching movies, TV shows, and managing TMDB data

DB管理プロンプトの作成/更新（versioning、variables、レンダリング確認、出力マーカー準拠）に使う。

Use when project needs C3 adoption (no .c3/) or auditing existing C3 docs.Triggers: "adopt C3", "onboard", "scaffold", "audit", "validate", "check C3", "init".NOT for navigation (use c3-query) or changes (use c3-alter).

All-purpose Gemini 3 Pro client with Thinking enabled. Query, analyze files (MP4, PDF, images), YouTube videos, generate/edit images. Uses browser cookies - no API key required.

Comprehensive performance analysis and optimization for Next.js applications using Neon Postgres. Identifies bottlenecks across frontend, backend, and database layers.

Master MongoDB index creation and types. Learn single-field, compound, unique, text, geospatial, and TTL indexes. Optimize query performance dramatically with proper indexing.

Emit and query WSC chronicle events. Use when recording world events, checking event history, tracing causality chains, or finding events by type, location, or participants.

Optimize caching strategies for performance. Use when analyzing cache effectiveness, implementing multi-layer caching, optimizing Redis/memory caches, or troubleshooting slow response times.

Conduct comprehensive, systematic literature reviews using multiple databases (PubMed, bioRxiv, Semantic Scholar, OpenAlex). Creates documented searches, synthesizes findings thematically, verifies citations, and generates professional markdown reports with multiple citation styles (APA, Nature, Vancouver). Use when the user needs thorough literature research or types /deep_research.

Application security best practices and vulnerability prevention. Use when reviewing code for security issues, implementing authentication, or discussing OWASP vulnerabilities. Triggers on mentions of security, authentication, authorization, XSS, SQL injection, CSRF, OWASP, encryption, secrets.

Redis cache inspection and management. Provides GET, SET, DEL, SCAN pattern searching, and TTL operations for Redis databases. Activated when users mention "redis", "cache", "key-value", or need cache operations.

Python full-stack with FastAPI, React, PostgreSQL, and Docker.

Work with ArcGIS Knowledge graphs for storing and querying connected data. Use for graph databases, relationship visualization, and openCypher queries.

Write secure, performant, and optimized database queries using parameterized queries, eager loading, proper indexing, and transaction management. Use this skill when writing database queries in controllers, repositories, services, or model methods, when using query builders or ORM methods, when implementing filtering/sorting/pagination logic, when optimizing N+1 query problems with eager loading, when working with joins and complex queries, when implementing query caching, or when wrapping related operations in database transactions.

Generate comprehensive async pytest tests for Quart endpoints, database operations, and WebSocket connections. Activates when writing tests or ensuring code coverage.

Comprehensive Flow Nexus platform management - authentication, sandboxes, app deployment, payments, and challenges