Skill UI

This skill covers provisioning and managing Azure SQL Database and Cosmos DB instances. It includes configuring security settings, setting up backups, and implementing geo-replication strategies. Users will learn to create servers, databases, and elastic pools using Azure CLI commands. It also addresses firewall rules, network security, failover groups, and performance tuning for production environments. Ideal for DevOps engineers and cloud administrators deploying managed databases on Azure.

This skill empowers you to implement secure backend coding practices, focusing on input validation, authentication, and API security. It covers vulnerability prevention, defensive programming, and secure architecture implementation. Ideal for building security-first applications that resist common attack vectors like SQL injection, XSS, and CSRF. Includes expertise in database protection, secret management, and HTTP security headers.

This skill provides comprehensive guidance on using LibreOffice Base for full-cycle database management. Users can create ODB databases, define schemas, manage tables, and establish relationships. It supports connecting to various external databases (MySQL, PostgreSQL, etc.), performing complex data operations, and automating professional reports and forms using SQL and Python scripting (UNO). Ideal for building data-driven applications.

This skill ensures code adheres to security best practices and identifies vulnerabilities. It is used for authentication, authorization, input validation, file uploads, and API development. It covers secrets management, SQL injection prevention, XSS protection, and secure session handling.

This comprehensive workflow guides the entire database lifecycle, from initial architecture design (covering both SQL and NoSQL) to advanced implementation, optimization, and maintenance. It covers crucial stages like schema design, implementing migrations, optimizing query performance, developing robust data pipelines (using tools like Airflow and dbt), and managing data quality and operations. Ideal for engineers building complex, production-grade data systems.

Implement comprehensive automated database backup strategies for PostgreSQL, MySQL, and MongoDB. Configure retention policies, schedule backups using cron or systemd, and upload to S3-compatible storage. Includes scripts for logical and physical backups, point-in-time recovery, and disaster recovery testing. Essential for DevOps and database administration roles to ensure data safety and business continuity.

This skill provides expert guidance on SQL database migrations for PostgreSQL, MySQL, and SQL Server. It focuses on zero-downtime deployment strategies, ensuring data integrity and providing comprehensive rollback plans. You will receive migration scripts, validation checks, and performance optimization recommendations suitable for production environments.

Authorized security assessment of PostgreSQL, MySQL, MSSQL, MongoDB, and Redis: exposure and TLS review, account role and grantee analysis, dangerous configuration checks (file_priv, xp_cmdshell, COPY PROGRAM, UDF), NoSQL injection, and audit log posture.

This skill helps diagnose, repair, and prevent complex Drizzle Kit database migration conflicts. It addresses issues arising from merging branches, rebasing, or PR updates involving generated SQL, snapshots, and journals. Use it to ensure stable schema evolution in multi-developer teams and harden CI/CD workflows.

This skill guides you in designing and implementing event stores for event-sourced systems. It covers architecture patterns, technology selection (like PostgreSQL, Kafka, EventStoreDB), and implementation best practices. Use it when building event sourcing infrastructure, optimizing storage retrieval, or setting up schemas. Includes templates for SQL and Python implementations to ensure append-only, ordered, and versioned event persistence.

Master building high-performance asynchronous APIs using FastAPI, SQLAlchemy 2.0, and Pydantic V2. Covers microservices, WebSockets, security, testing, and deployment strategies for production-ready Python backend systems. Includes async patterns, database optimization, and observability.

Provision and manage fully managed relational databases on Google Cloud Platform, including PostgreSQL, MySQL, and SQL Server. Configure high availability, automated backups, security settings, and private IP connections. Suitable for production workloads requiring ACID transactions and regional failover. Includes Terraform configuration examples for infrastructure as code deployment.