Learnmore-smart

ALWAYS ACTIVE for any codebase. Use when starting code work, resuming a task, continuing after a session break, or modifying any file. CRITICAL: .ai/ is agent memory — READ mirror docs before coding (especially on resume); write docs so the NEXT agent can continue. Missing .ai/ or file doc → create first. Bug fixes: document plan in .ai/ before code.

Database modeling and schema design best practices for relational and NoSQL databases. Use when designing new database schemas, creating migration files, choosing between database types, normalizing/denormalizing data, defining indexes, or reviewing existing database designs. Triggers on tasks involving table design, ER diagrams, schema migration, indexing strategy, query performance planning, or database architecture decisions.

SQL query optimization expert covering execution plan analysis, indexing strategies, query rewriting patterns, and slow query diagnosis. Use when optimizing slow SQL queries, analyzing EXPLAIN output, designing indexes for performance, debugging database performance issues, or rewriting queries for better performance. Triggers on tasks involving slow queries, EXPLAIN ANALYZE, query tuning, index recommendations, N+1 query problems, or database performance bottlenecks.

Data visualization best practices covering chart selection, color theory, layout design, and accessibility. Use when choosing the right chart type for data, designing dashboards, creating infographics, improving existing visualizations, or building data-driven presentations. Triggers on tasks involving chart type selection, color palette design, dashboard layout, data storytelling, matplotlib/plotly/D3.js visualization code, or visual data communication.

Data pipeline design and implementation guide covering ETL/ELT workflows, data quality validation, scheduling, and orchestration. Use when building data ingestion pipelines, creating ETL jobs, setting up data quality checks, designing stream processing flows, or planning data warehouse integration. Triggers on tasks involving data extraction, transformation, loading, data orchestration (Airflow, Dagster), CDC, or batch/stream processing architecture.

RESTful and GraphQL API design best practices. Use when designing new APIs, creating endpoint specifications, defining request/response schemas, setting up API versioning, or reviewing existing API designs for improvements. Triggers on tasks involving REST API design, GraphQL schema, API documentation, endpoint naming, error handling patterns, authentication/authorization flows, rate limiting, or API gateway configuration.