Skill UI

This comprehensive scaffold sets up a complete, modern Power Apps Code App project structure using Vite, React, and TypeScript. It guides developers through initializing the project with PAC CLI, configuring SDK integration, and setting up best practices for connecting to 1,500+ Power Platform connectors (e.g., Office 365, SharePoint, SQL Server). Ideal for building complex, code-first enterprise applications within the Power Platform ecosystem.

A universal assistant for conducting deep code reviews across major SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). It rigorously analyzes SQL code for critical vulnerabilities (like SQL injection), performance bottlenecks, maintainability issues, and adherence to industry best practices. Features include security audits, index optimization recommendations, query structure analysis, and schema design validation, ensuring robust and secure database development.

Cross-database SQL performance optimization assistant offering query tuning, indexing strategies, pagination, batch operations, and monitoring guidance for MySQL, PostgreSQL, SQL Server, Oracle, and other relational systems.

This guide details how to configure and manage resource constraints in ClickHouse, addressing server-side limits, user quotas, and connection management. Use it when encountering "too many simultaneous queries," optimizing resource usage, or implementing robust rate limiting strategies in applications connecting to ClickHouse. Covers SQL quota setup and client-side pooling techniques.

A comprehensive, step-by-step runbook designed for diagnosing and resolving critical operational issues in ClickHouse databases. Covers tiered severity levels (P1-P3) for scenarios ranging from server outages and OOM kills to performance degradation and stuck queries. Provides essential system tables queries and commands for service recovery and system health checks.

This tool outlines the complete end-to-end migration process from an Oracle database environment to SQL Server. It automates schema conversion, data migration, and generates necessary assessment reports by simulating SSMA console operations. Ideal for database architects and developers planning heterogeneous database migrations.

This powerful tool compares identical tables across two SQL Server instances (e.g., Production vs. Staging). It efficiently detects missing rows, extra columns, schema drifts, and data mismatches. Leveraging Python and Apache Arrow for fast columnar data transfer, it provides a comprehensive reconciliation report, making it essential for data migration validation and ETL verification.

This skill provides an active penetration testing toolchain covering information gathering, port scanning, vulnerability scanning, web attacks (SQL injection, XSS), directory brute-forcing, and password cracking. It exposes 20+ security tools to AI agents via MCP servers for authorized security assessments.

Provision and manage Amazon RDS relational databases including PostgreSQL, MySQL, and SQL Server. Configure backups, replication, security, and monitoring using AWS CLI. Ideal for deploying production-grade managed databases with high availability and performance tuning.

Connect to Azure Database for PostgreSQL Flexible Server from Node.js/TypeScript using the pg (node-postgres) package, supporting password and Microsoft Entra ID authentication, connection pooling, parameterized queries, and transactions.

Manage Azure MySQL Flexible Server deployments with the .NET Resource Manager SDK: create servers, databases, firewall rules, tune configurations, and set up Entra ID admins.

Manage Azure Database for PostgreSQL Flexible Server using the .NET Resource Manager SDK. Create servers and databases, configure firewall rules, settings, backups, and Entra ID administrators.