Database skills

This skill maintains persistent project memory across sessions by loading context, logging decisions, and tracking progress to prevent AI amnesia.

This skill performs a comprehensive ClickHouse diagnostic by orchestrating expert modules to reveal performance bottlenecks and actionable improvements.

This skill helps you perform exploratory data analysis and advanced SQL analytics to derive business insights from complex datasets.

This skill helps you create records in Bknd using SDK or REST, including relations, responses, errors, and bulk operations.

This skill designs functional architectures and detailed PHP/CakePHP specifications from requirements to guide development and ensure consistent, scalable

This skill helps you master BI fundamentals including metric definitions, KPI calculations, dimensional modeling, and dashboard optimization for rapid data

This skill helps you create new entities in Bknd, offering UI and code-mode workflows with type-safe definitions.

This skill helps you design data warehouses using star schemas and slowly changing dimensions to improve query performance and accuracy.

This skill designs and configures scalable CRM architectures with object modeling, pipelines, and data mapping to support automation and analytics.

This skill securely queries PostgreSQL databases via pglr, lists tables, and describes schemas without exposing credentials.

This skill helps you implement ACID transactions, manage isolation levels, and handle concurrency in SQL backed applications.

This skill helps you master SQL fundamentals, enabling efficient data queries, updates, and design patterns across databases.

This skill helps you manage database schema changes safely with version control, migration tools, and zero-downtime deployment strategies.

This skill helps you query and retrieve data from Bknd entities using readOne, readMany, and readOneBy with filtering, sorting, and relation loading.

This skill helps you leverage Redis data structures and commands for high-performance caching and real-time application capabilities.

This skill helps you add fields to Bknd entities via UI or code, ensuring type safety, validation, and consistent schema evolution.

This skill helps you administer and optimize MySQL databases, enabling efficient query tuning, replication setup, and reliable backups.

This skill helps you design schemas, optimize queries, and manage migrations for MongoDB and PostgreSQL with practical, production-ready guidance.

This skill streamlines updating Bknd records via SDK or REST, supporting single, bulk, and relational updates with safe, structured responses.

This skill identifies performance bottlenecks in code and suggests senior level optimizations to significantly speed up critical paths.

This skill helps you configure fine-grained permissions for roles in Bknd, including simple strings, extended formats, policies, and entity-specific rules.