Sql skills

This skill monitors real-time ClickHouse metrics and events, analyzes queries, memory, and load to help prevent saturation and optimize performance.

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 you implement robust Python database access with SQLAlchemy ORM patterns, including models, sessions, queries, upserts, and JSON columns.

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

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 optimizes OceanBase SQL by guiding query writing, index design, and plan analysis for MySQL and Oracle modes.

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

This skill helps you write and format OceanBase SQL statement documentation according to official style guidelines, ensuring clear structure and accurate

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

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

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 helps you optimize Autonomous Databases on OCI by troubleshooting connections, managing PDBs, cloning, and cost-aware operations.

This skill helps you implement load lifecycle patterns, billing workflows, and TONU handling with clear transitions and financial calculations.

This skill helps you design efficient database schemas, write optimized SQL, and manage data operations following best practices.

This skill provides expert Oracle Autonomous Database guidance for performance, security, HA/DR, and OCI automation to optimize DBA tasks.

This skill helps you design Prisma schemas, migrations, and SQLite with LiteFS for Epic Stack, focusing on efficient queries and multi-region readiness.

This skill helps you write safe PostgreSQL migrations that avoid blocking reads and writes by applying vetted, non disruptive patterns.

This skill helps you implement and manage caching with cachified, SQLite and LRU caches to boost Epic Stack performance.

This skill applies caching, database optimization, and algorithm improvements to systematically boost application performance.