Dados e Análise

Fornece padrões de otimização SQL para desempenho de consultas, estratégias de indexação, design de esquema e ajuste de banco de dados. Use ao otimizar consultas lentas, projetar índices ou ajustar o desempenho do banco de dados.

Reviews database schemas, queries, and migrations for correctness, performance, security, and best practices. Use when reviewing SQL migration files or when the user mentions database review, schema review, or query audit.

Provides Drizzle ORM schema design, query patterns, migrations, and TypeScript integration for SQL databases. Use when working with Drizzle files (schema.ts, drizzle.config.ts) or when the user mentions Drizzle ORM or drizzle-kit.

Fornece padrões PostgreSQL para otimização de consultas, design de esquema, estratégias de indexação, RLS e segurança. Use ao trabalhar com arquivos SQL PostgreSQL ou quando o usuário mencionar PostgreSQL, Postgres, pgvector, Supabase ou otimização de banco de dados.

Designs scalable backend architectures covering microservices, event-driven systems, API gateways, and data stores. Use when designing a backend system or when the user mentions backend architecture, scalability, or distributed systems.

Fornece padrões NoSQL distribuídos para Cassandra e DynamoDB, cobrindo modelagem query-first, design de tabela única e estratégias de chave de partição. Use ao projetar esquemas NoSQL ou quando o usuário mencionar Cassandra, DynamoDB ou modelagem NoSQL.

Run multi-indicator technical analysis on crypto or market OHLCV data. Use for deterministic trend, momentum, volume, and divergence analysis.

Provides Retrieval-Augmented Generation patterns covering embedding models, vector databases, chunking strategies, and retrieval optimization. Use when building RAG systems or when the user mentions RAG, vector search, embeddings, or retrieval-augmented generation.

Fornece padrões de arquitetura Spring Boot para APIs REST, serviços em camadas, acesso a dados JPA, cache, processamento assíncrono e logging. Utilize ao trabalhar com arquivos Java Spring Boot (*.java, pom.xml) ou quando o usuário mencionar Spring Boot, Spring Framework ou backend Java.

Production FastAPI patterns — async endpoints, SQLAlchemy 2.0 async, Pydantic V2, dependency injection, JWT auth, testing. Use for Python 3.11+ FastAPI backends. NOT for Django (→ `django-patterns`) or Node.js (→ `backend-patterns`).

Provides vector database and semantic search patterns for Pinecone, Weaviate, Qdrant, Milvus, and pgvector in RAG and recommendation systems. Use when implementing vector search or when the user mentions vector database, semantic search, embeddings, or similarity search.

Orchestrates the backend team of technical-director, backend-developer, data-engineer, and security-engineer to design, implement, and review a backend system end-to-end. Use when a backend feature needs coordinated multi-specialist delivery.