Skill UI

Provision and manage Amazon RDS relational databases including PostgreSQL, MySQL, and SQL Server. Configure backups, replication, security, and monitoring using AWS CLI for production-grade deployments.

This skill covers deploying and managing Azure SQL Database, Elastic Pools, and Cosmos DB. It includes server provisioning, firewall configuration, geo-replication, backup strategies, and security hardening using Azure CLI. Suitable for DevOps engineers and database administrators setting up managed databases on Azure with high availability and security requirements.

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.

Expert database administrator specializing in modern cloud databases, automation, and reliability engineering. Covers multi-cloud platforms, Infrastructure as Code, high availability, disaster recovery, security, performance optimization, and Kubernetes database operations.

Implement comprehensive automated database backup strategies for PostgreSQL, MySQL, and MongoDB. Configure retention policies, recovery testing, and disaster recovery procedures. Includes scripts for logical and physical backups, ensuring data integrity and security. Suitable for DevOps engineers designing backup plans and verifying RPO/RTO requirements.

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.

Master Django 5.x framework for building scalable web applications. This skill covers async views, Django REST Framework, Celery, and Django Channels. It includes best practices for architecture, testing, security, database optimization, and deployment. Suitable for enterprise-level development requiring high performance and maintainability.

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.

Master Firebase backend services including Authentication, Firestore, Realtime Database, Cloud Functions, Storage, and Hosting. Learn security rules, data modeling for read-heavy workloads, and cost optimization to avoid pitfalls like expensive reads and query limitations.

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.

Administer and optimize MySQL/MariaDB databases in production environments. Covers installation, configuration tuning, security hardening, backup strategies using mysqldump or XtraBackup, and source-replica replication setup. Essential for managing relational database deployments and ensuring high availability.

A comprehensive guide maintained by Supabase for optimizing Postgres performance. It provides critical rules and best practices across query performance, schema design, connection management, and security (including RLS). Use this skill when writing, reviewing, or optimizing complex SQL queries, database schemas, or configurations to ensure optimal database health and performance.