Claude Skills by luokai0

Expert-level event-driven architecture. Use when designing event-driven systems, working with Kafka, RabbitMQ, AWS SQS/SNS, event sourcing, CQRS, pub/sub patterns, event schema design, or async workflows. Also use when the user mentions 'event-driven', 'Kafka', 'message queue', 'event sourcing', 'outbox pattern', 'pub/sub', 'consumer group', 'dead letter queue', or 'async workflow'.

Expert-level serverless. Use when building Lambda, Vercel Functions, Cloudflare Workers, edge computing, cold start optimization, or serverless frameworks.

Expert-level Node.js backend. Use when building Node.js servers, working with Express, Fastify, streams, worker threads, or Node.js performance.

Expert-level Django. Use when building Django apps, working with ORM queries, migrations, DRF, signals, middleware, or Django admin.

Expert-level Apache Kafka. Use when working with producers/consumers, partitions, Kafka Streams, Schema Registry, exactly-once semantics, or Kafka Connect.

Expert-level WebSockets and real-time. Use when implementing WebSockets, Socket.IO, Server-Sent Events, pub/sub systems, or live collaboration features.

Reconcile the project's FPF state with recent repository changes

Provision instant temporary Postgres databases via Claimable Postgres by Neon (neon.new) with no login, signup, or credit card. Supports REST API, CLI, and SDK. Use when users ask for a quick Postgres environment, a throwaway DATABASE_URL for prototyping/tests, or "just give me a DB now". Triggers include: "quick postgres", "temporary postgres", "no signup database", "no credit card database", "instant DATABASE_URL", "npx neon-new", "neon.new", "neon.new API", "claimable postgres API".

Expert database schema design and architecture. Use when designing relational or document schemas, normalization, ER diagrams, choosing between SQL and NoSQL, handling many-to-many relations, or optimizing data models. Also use when the user mentions 'schema design', 'normalization', 'ER diagram', 'foreign key', 'many-to-many', 'data model', 'database architecture', 'table design', or 'NoSQL vs SQL'.

Expert-level MySQL/MariaDB. Use when writing MySQL queries, designing schemas, indexes, stored procedures, replication, or MySQL performance optimization.

Diagnose and fix excessive Postgres egress (network data transfer) in a codebase. Use when a user mentions high database bills, unexpected data transfer costs, network transfer charges, egress spikes, "why is my Neon bill so high", "database costs jumped", SELECT * optimization, query overfetching, reduce Neon costs, optimize database usage, or wants to reduce data sent from their database to their application. Also use when reviewing query patterns for cost efficiency, even if the user doesn...

Guides and best practices for working with Neon Serverless Postgres. Covers getting started, local development with Neon, choosing a connection method, Neon features, authentication (@neondatabase/auth), PostgREST-style data API (@neondatabase/neon-js), Neon CLI, and Neon's Platform API/SDKs. Use for any Neon-related questions.

Expert guidance on using PostgreSQL with Swift. Use when developers mention: (1) PostgreSQL or Postgres in Swift, (2) postgres-nio library, (3) SQL queries in Swift, (4) PostgreSQL connection pooling, (5) prepared statements, (6) type-safe database access, (7) bulk loading or COPY FROM, (8) PostgresClient or PostgresConnection.

Expert-level PostgreSQL. Use when writing complex SQL queries, designing schemas, working with indexes, CTEs, window functions, JSONB, full-text search, stored procedures, performance tuning, or pg extensions. Also use when the user mentions 'slow query', 'EXPLAIN', 'index', 'migration', 'schema design', 'normalization', 'JOIN', 'window function', 'CTE', or 'JSONB'.

Expert-level SQL for analytics and business intelligence. Use when writing complex analytical SQL, window functions, CTEs, cohort analysis, funnel queries, time-series analysis, or working with BI tools (Looker, Metabase, Superset). Also use when the user mentions 'window function', 'cohort analysis', 'funnel query', 'ROLLUP', 'CUBE', 'retention', 'analytics SQL', 'time series', or 'sessionization'.

Expert-level SQLite. Use when working with SQLite, WAL mode, FTS5 full-text search, JSON functions, virtual tables, or embedding SQLite in apps.

Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.

Expert-level MongoDB. Use when designing document schemas, aggregation pipelines, indexes, change streams, Atlas Search, or Mongoose ODM.

Expert-level Redis. Use when implementing caching, working with Redis data structures, pub/sub, Lua scripting, Redis Streams, or clustering.

MUST USE when reviewing ClickHouse schemas, queries, or configurations. Contains 28 rules that MUST be checked before providing recommendations. Always read relevant rule files and cite specific rules in responses.

MUST USE when reviewing ClickHouse schemas, queries, or configurations. Contains 28 rules that MUST be checked before providing recommendations. Always read relevant rule files and cite specific rules in responses.

Expert-level Elasticsearch. Use when designing indexes, writing search queries, aggregations, relevance tuning, mappings, or working with Kibana.

Expert-level vector database development. Use when working with Pinecone, Weaviate, Qdrant, pgvector, Chroma, FAISS, implementing semantic search, hybrid search, ANN algorithms, or embedding storage and retrieval. Also use when the user mentions 'vector database', 'pgvector', 'Pinecone', 'semantic search', 'embedding storage', 'HNSW', 'ANN', 'similarity search', 'RAG retrieval', or 'nearest neighbor'.

Expert-level Prisma ORM. Use when working with Prisma schema, migrations, relations, raw queries, Prisma Client, or integrating with Next.js.

Expert-level Supabase. Use when building with Supabase, Row Level Security, Auth, Realtime, Edge Functions, Storage, or integrating with Next.js.

Next.js with Supabase and Drizzle ORM

Express/Hono with Supabase and Drizzle ORM

FastAPI with Supabase and SQLAlchemy/SQLModel

Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.

Core Supabase CLI, migrations, RLS, Edge Functions

Expert-level Stripe. Use when integrating payments, Payment Intents, subscriptions, webhooks, Stripe Connect, billing portal, or handling payment edge cases.

Build Amazon Machine Images (AMIs) with Packer using the amazon-ebs builder. Use when creating custom AMIs for EC2 instances.

AWS Aurora Serverless v2, RDS Proxy, Data API, connection pooling

AWS DynamoDB single-table design, GSI patterns, SDK v3 TypeScript/Python

Expert-level AWS cloud development. Use when working with EC2, S3, Lambda, RDS, DynamoDB, ECS, API Gateway, CloudFront, SQS, SNS, IAM, CDK, or CloudFormation. Also use when the user mentions 'Lambda', 'S3 bucket', 'IAM role', 'CDK', 'CloudFormation', 'DynamoDB', 'ECS', 'VPC', 'API Gateway', 'cost optimization', or any AWS service name.

AWS Bedrock AgentCore comprehensive expert for deploying and managing all AgentCore services. Use when working with Gateway, Runtime, Memory, Identity, or any AgentCore component. Covers MCP target deployment, credential management, schema optimization, runtime configuration, memory management, and identity services.

AWS Cloud Development Kit (CDK) expert for building cloud infrastructure with TypeScript/Python. Use when creating CDK stacks, defining CDK constructs, implementing infrastructure as code, or when the user mentions CDK, CloudFormation, IaC, cdk synth, cdk deploy, or wants to define AWS infrastructure programmatically. Covers CDK app structure, construct patterns, stack composition, and deployment workflows.

AWS cost optimization, monitoring, and operational excellence expert. Use when analyzing AWS bills, estimating costs, setting up CloudWatch alarms, querying logs, auditing CloudTrail activity, or assessing security posture. Essential when user mentions AWS costs, spending, billing, budget, pricing, CloudWatch, observability, monitoring, alerting, CloudTrail, audit, or wants to optimize AWS infrastructure costs and operational efficiency.

Configure AWS MCP servers for documentation search and API access. Use when setting up AWS MCP, configuring AWS documentation tools, troubleshooting MCP connectivity, or when user mentions aws-mcp, awsdocs, uvx setup, or MCP server configuration. Covers both Full AWS MCP Server (with uvx + credentials) and lightweight Documentation MCP (no auth required).

AWS serverless and event-driven architecture expert based on Well-Architected Framework. Use when building serverless APIs, Lambda functions, REST APIs, microservices, or async workflows. Covers Lambda with TypeScript/Python, API Gateway (REST/HTTP), DynamoDB, Step Functions, EventBridge, SQS, SNS, and serverless patterns. Essential when user mentions serverless, Lambda, API Gateway, event-driven, async processing, queues, pub/sub, or wants to build scalable serverless applications with AWS b...

Deploy production LangGraph agents on AWS.

AWS ECS production health monitoring with CloudWatch.

Chat-based AWS infrastructure assistance using AWS CLI and console.

Scan AWS accounts for security.

Design AWS architectures for startups.

Manage AWS Lightsail and EC2 instances using AWS CLI.

Azure Cosmos DB partition keys, consistency levels, change feed, SDK patterns

Expert-level Azure. Use when working with App Service, AKS, Azure Functions, Cosmos DB, Azure SQL, Service Bus, or designing Azure architectures.

Build Azure managed images and Azure Compute Gallery images with Packer. Use when creating custom images for Azure VMs.

Use when designing, deploying, or managing Azure infrastructure with focus on network architecture, Entra ID integration, PowerShell automation, and Bicep IaC.