Skill UI

A comprehensive guide covering best practices for database migrations. It addresses schema changes, data migrations, and rollbacks for major databases (PostgreSQL, MySQL) and modern ORMs (Prisma, Drizzle, etc.). Learn how to implement safe, reversible, and zero-downtime schema updates for production environments.

Specializes in generating production-grade SQL database migrations with zero-downtime strategies for PostgreSQL, MySQL, and SQL Server. Provides comprehensive plans covering data integrity, detailed rollback procedures, performance optimization, and validation checks for critical schema changes.

Actionable guidance for analyzing plans, indexing, connection pooling, partitioning, and detecting N+1 queries to keep PostgreSQL and MySQL workloads fast and reliable.

A specialized skill for optimizing database performance and scalability across PostgreSQL and MySQL. It guides users through analyzing slow queries, interpreting execution plans (EXPLAIN ANALYZE), designing optimal indexing strategies, tuning configuration parameters, and resolving bottlenecks like lock contention. Essential for DevOps engineers, database administrators, and backend developers.

This skill provides comprehensive observability for the Databricks platform. It enables users to monitor job run histories, track cluster utilization and associated costs (DBU), detect slow SQL queries, and audit access logs. Use it for setting up robust monitoring dashboards, ensuring pipeline health, and optimizing resource consumption across the entire data stack.

Detect SQL injection weaknesses by running the sql-injection-detector plugin against codebases, identifying risky queries, and providing remediation guidance to secure applications.

Provides Django security best practices covering production settings, authentication, authorization, CSRF and SQL injection protection, plus deployment hardening to keep live apps safe.

Comprehensive guide for setting up a complete local development stack for Documenso integrations. It covers project structure, environment variable configuration, running self-hosted services using Docker (PostgreSQL, MailHog), and implementing utility scripts for connection verification and test data cleanup.

Guide for designing, implementing, and scaling event stores in event-sourced systems, covering requirements, technology comparisons, PostgreSQL schemas, and Python persistence patterns.

This skill details best practices for handling and structuring Evernote data. It covers designing local database schemas (SQL), advanced ENML content processing (to Markdown/HTML), managing attachments, and implementing reliable incremental synchronization using Update Sequence Numbers (USN). Ideal for developers building robust applications requiring deep, local data access and integrity checks for Evernote content.

Manages FairDB PostgreSQL backups via pgBackRest and Wasabi S3, automating scheduling, integrity verification, PITR restores, monitoring, and compliance reporting for resilient disaster recovery.

This comprehensive skill covers the full scope of Firebase services, including Authentication, Firestore, Cloud Functions, and Hosting. It goes beyond basic implementation, focusing on critical architectural principles: adopting a query-first, denormalized NoSQL mindset. Key insights include mandatory security rule design, optimal data modeling for performance, and correctly utilizing modular SDKs to build scalable and secure backends.