Tag: database-optimization
skill
★ 50
Backend Architecture Patterns for Scalable Node.js APIs
Provides comprehensive architectural patterns and best practices for developing scalable server-side applications using Node.js, Express, and Next.js. It covers API design, database optimization (e.g., N+1 prevention, transactions), and imp…
skill
★ 27,411
ClickHouse Schema, Query, and Data Best Practices Review
This skill provides comprehensive, rule-based guidance for optimizing ClickHouse database interactions. It enforces best practices across schema design, query writing, and data ingestion, ensuring all recommendations are cited against speci…
skill
★ 23
PostgreSQL Performance Baseline Generation
Automates the creation of comprehensive PostgreSQL performance baseline reports for comparing database states before and after configuration or schema changes. It captures health metrics, query workloads, table statistics, and index utilisa…