testing-patterns
ChiQuang98React and Next.js testing patterns and best practices. Use when writing tests, setting up testing infrastructure, or implementing test strategies.
data-cleaning
ChiQuang98Python data cleaning patterns and best practices using Pandas. Use when cleaning messy data, handling missing values, or standardizing datasets.
git-conventions
ChiQuang98Git best practices, commit message guidelines, and workflow patterns. Use when working with git or need guidance on git workflows.
redshift-sort-keys
ChiQuang98Amazon Redshift sort key design and optimization strategies. Use when designing tables or optimizing query performance through sorting.
review-code
ChiQuang98Guide Claude to conduct thorough code reviews. Use when reviewing pull requests, code changes, or providing feedback on code quality.
express-patterns
ChiQuang98Express.js best practices and common patterns. Use when working with Express applications.
component-patterns
ChiQuang98React component design patterns and best practices. Use when designing components, structuring component hierarchy, or implementing reusable components.
redshift-spectrum
ChiQuang98Amazon Redshift Spectrum for querying S3 data. Use when designing data lake queries or integrating external data with Redshift.
ccmesh-clean
ChiQuang98Clean AI-generated temporary files, analysis files, and drafts from the project. Use to tidy up after AI sessions.
redshift-dist-styles
ChiQuang98Amazon Redshift distribution style selection and optimization. Use when designing tables or optimizing data distribution across nodes.
bigquery-partitioning
ChiQuang98Google BigQuery partition design and optimization strategies. Use when designing partition schemes or optimizing partition performance.
jupyter-patterns
ChiQuang98Jupyter notebook best practices and patterns. Use when working with notebooks, organizing analysis, or improving notebook workflows.
securify
ChiQuang98Security analysis and hardening guide. Scan code for vulnerabilities and suggest fixes.
query-patterns
ChiQuang98SQL query patterns and anti-patterns. Use when writing, refactoring, or optimizing SQL queries.
api-security
ChiQuang98API security best practices and patterns. Use when implementing security, preventing vulnerabilities, or securing APIs.
performance-tuning
ChiQuang98Database performance tuning and optimization techniques. Use when diagnosing performance issues or optimizing database operations.
nextjs-patterns
ChiQuang98Next.js framework patterns and best practices. Use when building Next.js applications with App Router, Server Components, or implementing Next.js-specific features.
ccmesh-docs
ChiQuang98Generate or update documentation for the current project. Creates README, API docs, and usage examples.
nestjs-patterns
ChiQuang98NestJS architecture and patterns. Use when working with NestJS applications, modules, decorators, or dependency injection.
index-strategies
ChiQuang98Database indexing strategies and patterns. Use when designing indexes, optimizing query performance, or planning database schema.
athena-partitioning
ChiQuang98AWS Athena partition design and optimization strategies. Use when designing partition schemes or optimizing partition performance.
dbt
ChiQuang98dbt (data build tool) transformations and SQL workflows. Use when building data transformations, data models, or orchestrating SQL workflows.
ccmesh-status
ChiQuang98Check project health, installed domains, and identify potential issues. Quick project overview.
python-conventions
ChiQuang98Python coding best practices including naming conventions, clean code, code reuse, and PEP 8 standards. Use when writing Python code to ensure high-quality, maintainable code.
bigquery-schema-design
ChiQuang98Google BigQuery schema design patterns and best practices. Use when designing tables, choosing data types, or working with nested/repeated fields.
styling-patterns
ChiQuang98React and Next.js styling patterns including CSS-in-JS, Tailwind CSS, CSS Modules, and modern styling approaches.
ccmesh-fix
ChiQuang98Auto-fix common issues like linting errors, formatting, and simple code problems. Quick cleanup.
visualization
ChiQuang98Python data visualization patterns using Matplotlib, Seaborn, and Plotly. Use when creating charts, graphs, or visual data representations.
ccmesh-optimize
ChiQuang98Analyze and optimize code for performance, bundle size, and best practices. Suggests improvements.
bigquery-cost-optimization
ChiQuang98Google BigQuery cost optimization techniques and strategies. Use when trying to reduce BigQuery query costs or analyze spending.
athena-cost-optimization
ChiQuang98AWS Athena cost optimization techniques and strategies. Use when trying to reduce Athena query costs or analyze spending.
athena-file-formats
ChiQuang98AWS Athena file format selection and optimization. Use when choosing between Parquet, ORC, Avro, or converting file formats.
oltp-olap
ChiQuang98OLTP vs OLAP database design patterns. Use when designing transactional or analytical databases, or planning data architecture.
airflow
ChiQuang98Apache Airflow workflows and DAGs. Use when designing data pipelines, scheduling ETL jobs, or orchestrating data workflows.
conflict-resolution
ChiQuang98Merge conflict resolution strategies and patterns. Use when dealing with merge conflicts or need guidance on conflict resolution.
error-handling
ChiQuang98Error handling patterns for Node.js APIs. Use when implementing error handling, creating custom errors, or managing exceptions.