Databases

Python backend developer for FastAPI, Django, Flask APIs with SQLAlchemy, Django ORM, Pydantic validation. Implements REST APIs, async operations, database integration, authentication, data processing with pandas/numpy, machine learning integration, background tasks with Celery, API documentation with OpenAPI/Swagger. Activates for Python, Python backend, FastAPI, Django, Flask, SQLAlchemy, Django ORM, Pydantic, async Python, asyncio, uvicorn, REST API Python, authentication Python, pandas, numpy, data processing, machine learning, ML API, Celery, Redis Python, PostgreSQL Python, MongoDB Python, type hints, Python typing.

Build production-ready FastAPI backends with async/await, SQLAlchemy, JWT authentication, Pydantic validation, and Celery background tasks. Use when creating REST APIs, implementing CRUD endpoints, setting up authentication, managing database sessions, or building backend services with FastAPI.

Reconcile worklog database with documentation - promotes learnings to docs with proper frontmatter and validates after sync

Sync GameGen SceneLayout from DynamoDB to Godot .tscn files. Exports current layout without AI parsing.

Modern Rust backend with Axum, SQLx, tokio + CI/CD automation. Use when: building Rust APIs, high-performance services, or needing build/test/lint/audit automation. Triggers: "axum", "rust backend", "rust api", "sqlx", "tokio", "cargo build", "cargo test", "clippy", "rustfmt", "cargo-audit", "cross-compile", "rust ci", "release build", "rust security", "shuttle", "actix".

Query the Read the Docs Search API to find documentation across projects and repositories. Use when searching documentation, finding related docs, finding API documentation, or gathering information about projects on Read the Docs.

Complete full-stack development with Next.js 13+, React, Firebase, Tailwind CSS, and payment integration (Stripe, JazzCash, EasyPaisa). Build production-ready e-commerce platforms, SaaS applications, and scalable web applications. Comprehensive coverage of frontend architecture, backend API routes, database design, authentication systems, payment processing, form handling, error management, and optimization. Generate complete project structures, pages, components, API routes, database schemas, security rules, and deployment configurations using TypeScript.

SQL best practices with pgTAP, sqlfluff 3.2, query optimization, and migration management.

Design and implement RESTful API endpoints following REST principles, consistent naming conventions, versioning strategies, and proper HTTP methods. Use this skill when creating or modifying API route handlers in files like routes.js, routes.ts, api.py, routes.rb, controllers/*.js, controllers/*.ts, api/*.js, or any backend files that define HTTP endpoints and handle requests/responses. Use this when implementing CRUD operations with appropriate HTTP methods (GET for retrieving data, POST for creating new resources, PUT/PATCH for updating existing resources, DELETE for removing resources), designing RESTful URL structures with plural resource nouns like /users, /products, or /orders that follow REST conventions, setting up API versioning in URL paths like /v1/users or /api/v2/products or via headers for backward compatibility, defining query parameters for filtering collections (?status=active), sorting data (?sort=createdAt:desc), pagination (?page=2&limit=20), and search functionality (?q=search+term), conf

This skill provides comprehensive knowledge for integrating Vercel KV (Redis-compatible key-value storage powered by Upstash) into Vercel applications. It should be used when setting up Vercel KV for Next.js applications, implementing caching patterns, managing sessions, or handling rate limiting in edge and serverless functions. Use this skill when: - Setting up Vercel KV for Next.js applications - Implementing caching strategies (page cache, API cache, data cache) - Managing user sessions or authentication tokens in serverless environments - Building rate limiting for APIs or features - Storing temporary data with TTL (time-to-live) - Migrating from Cloudflare KV to Vercel KV - Encountering errors like "KV_REST_API_URL not set", "rate limit exceeded", or "JSON serialization errors" - Need Redis-compatible API with strong consistency (vs eventual consistency) Keywords: vercel kv, @vercel/kv, vercel redis, upstash vercel, kv vercel, redis vercel edge, key-value vercel, vercel cache, vercel sessions, vercel rate limit, redis upstash, kv storage, edge kv, serverless redis, vercel ttl, vercel expire, kv typescript, next.js kv, server actions kv, edge runtime kv

Troubleshoot GCP services using tool-first access (via MCP when available), falling back to the CLI only when necessary. Focus on Firestore, Cloud Run, networking, load balancers, IAM, Pub/Sub, Cloud SQL, and Storage.

Execute Gemini CLI commands for AI-powered coding assistance, file analysis, and complex development tasks. Use when user wants to run gemini commands, query Gemini models, or leverage Gemini's agentic capabilities.

Comprehensive Supabase expert with access to 2,616 official documentation files covering PostgreSQL database, authentication, real-time subscriptions, storage, edge functions, vector embeddings, and all platform features. Invoke when user mentions Supabase, PostgreSQL, database, auth, real-time, storage, edge functions, backend-as-a-service, or pgvector.

Write safe, reversible database migrations that support zero-downtime deployments. Use this skill when creating or modifying database migration files. When working on files in migrations/, alembic/, or any database schema change files. When adding new tables, columns, indexes, or constraints. When writing rollback/down methods for migrations. When considering deployment order for schema changes in high-availability systems.

Apply Anthropic's production multi-agent research patterns for complex research tasks. Use when research involves multiple independent dimensions, requires synthesis across many sources, or needs parallelization for speed. Includes query complexity assessment, parallel execution, progressive search refinement, thinking strategies, and findings compression.

Implement runtime validation and type safety using Zod schemas for Content Collections, API inputs, form data, and environment variables. Use this skill when validating user input, API requests, content schemas, or ensuring data integrity. When working on Content Collections schema definitions in src/content/config.ts, API route input validation with Zod, form validation (server-side and client-side), environment variable validation, component prop validation with runtime checks, URL and query parameter validation, request body and form data sanitization, TypeScript runtime type validation, or custom Zod refinements and transformations.

Install and wire @tanstack/react-query in Expo/React Native apps (providers, query client, fetch patterns, and screen usage). Use when adding React Query to a project or extending data fetching patterns.

Master Supabase patterns for migrations, RLS policies, pgvector, and authentication. Use when creating database schemas, writing migrations, implementing row-level security, setting up auth, or debugging Supabase issues. Triggers on "supabase migration", "RLS policy", "row level security", "pgvector", "supabase auth", "magic link".

Process bulk RNA-seq datasets for VEuPathDB resources

High-availability architecture patterns for home lab infrastructure including multi-master Kubernetes, etcd clustering, HAProxy load balancing, database replication, network redundancy, and failover mechanisms. Use when designing HA systems, implementing cluster quorum, optimizing for 99.9% uptime, or building resilient infrastructure with automatic failover.