Skill UI

This SDK provides comprehensive programmatic management capabilities for Azure MySQL Flexible Server deployments using C# and the .NET framework. Developers can automate the entire database lifecycle, including server creation, database provisioning, configuring firewall rules, updating server parameters, and managing Entra ID administrators, all through Azure Resource Manager APIs. Ideal for DevOps pipelines and cloud infrastructure automation.

This skill provides expert guidance for modern, multi-cloud database administration. It covers comprehensive knowledge across AWS, Azure, and GCP platforms, spanning relational, NoSQL, and graph databases. Key areas include Infrastructure as Code (Terraform, Flyway), achieving high availability, disaster recovery, advanced performance optimization, and ensuring strict regulatory compliance (HIPAA, GDPR). It is essential for managing complex, highly reliable cloud data architectures.

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.

Implements robust Role-Based Access Control (RBAC) for Juicebox, an AI-powered platform for recruiting and sales. This system defines granular permissions for various roles (Admin, Recruiter, Analyst, etc.), controlling access to sensitive candidate databases, data enrichment capabilities, outreach functions, and data export. It ensures data governance, maintains compliance (e.g., SOC 2), and segments user access based on job function and need-to-know principles.

This skill provides comprehensive expertise for senior database administrators to optimize and manage PostgreSQL databases at an advanced level. Use it for deep query analysis via EXPLAIN ANALYZE, implementing advanced features like JSONB indexing, configuring streaming or logical replication, and maintaining database health through VACUUM tuning and monitoring pg_stat views. Ideal for building highly available, high-performance, and resilient system architectures.

A comprehensive, multi-phase workflow for developing professional WordPress plugins. Covers foundational architecture, hooks, admin UI, database design, and REST API implementation. Crucially, it incorporates advanced WordPress 7.0 features, including Real-Time Collaboration (RTC) compatibility, AI Connector integration (OpenAI, Claude, etc.), and the Abilities API, ensuring modern, scalable, and secure plugins.

This guide details how to use Shopify Metafields and Metaobjects via the GraphQL Admin API. Metafields allow attaching key-value custom data to existing resources (like products or orders), while Metaobjects enable defining entirely new, structured content types. Together, they provide a powerful way for developers to model complex custom data, often eliminating the need for external databases to extend e-commerce functionality.

Azure Resource Manager SDK for .NET that provisions and manages PostgreSQL Flexible Server deployments, covering databases, firewall rules, server configurations, backups, high availability, and Entra ID administrators.

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.

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.

Administer, optimize, and secure MongoDB NoSQL databases in development and production. Covers installation, user setup, CRUD operations, indexing, aggregation pipelines, replica sets, and backup/restore.

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.