Database skills

This skill helps validate ClickHouse connections and prepare MCP or client queries for diagnostics and analysis.

This skill enables modular Maven builds for Spring projects by toggling components like Redis, Kafka, and RabbitMQ via profiles and properties.

This skill runs a quick overview of ClickHouse server health, analyzes metrics and logs, and routes findings to relevant expert modules.

This skill helps diagnose and track ClickHouse mutations such as ALTER UPDATE and ALTER DELETE to reduce stalls and improve mutation performance.

This skill analyzes ClickHouse system.part_log to diagnose issues from high part churn, mutations, and slow merges, guiding targeted remediation.

This skill analyzes ClickHouse index usage and suggests ORDER BY and projection improvements to align with query patterns and reduce scans.

This skill helps design and optimize Redis architectures for sub-millisecond caching, high availability, and scalable data structures across clusters.

This skill diagnoses ClickHouse merge performance and part backlog, generating a decision-ready report for remediation and ongoing monitoring.

This skill lets you manage GitHub, Linear, and JIRA issues offline with instant local reads and git worktrees.

This skill helps you design and query DynamoDB single-table schemas with dynamodb-toolbox v2 in TypeScript, boosting type safety and performance.

This skill helps you implement robust Python database access with SQLAlchemy ORM patterns, including models, sessions, queries, upserts, and JSON columns.

This skill helps you manage Lovable.dev projects by guiding backend deployments, migrations, and edge functions through Lovable prompts.

This skill helps you write Laravel tests with PHPUnit and Dusk, ensuring reliable feature, unit, and browser tests with robust assertions.

This skill optimizes OceanBase SQL by guiding query writing, index design, and plan analysis for MySQL and Oracle modes.

This skill helps you document OceanBase SQL syntax clearly separating structure from executable examples, improving accuracy and consistency.

This skill analyzes and optimizes database queries across PostgreSQL, MySQL, and MongoDB by interpreting EXPLAIN plans and suggesting indexes.

This skill generates Arc-compatible architecture diagrams as JSON from user input, enabling quick visualization of systems in React apps.

This skill helps you design and query SQL with Drizzle ORM in TypeScript, enabling type-safe schemas, relations, migrations, and multi-database support.

This skill helps you design efficient OceanBase schemas for MySQL and Oracle modes, covering tables, partitions, indexes, and table groups to boost performance.

This skill optimizes Laravel infrastructure by coordinating Horizon, Octane, Reverb, Redis, and PostgreSQL to improve queues, caching, and real-time

This skill analyzes AI-generated code to identify and explain injection vulnerabilities such as SQL injection, command injection, and XSS, with secure