Skill UI

This module provides comprehensive connection methods for Azure Database for PostgreSQL Flexible Server using Node.js and TypeScript with the pg package. It supports both traditional password authentication and modern, recommended Microsoft Entra ID (passwordless) authentication. The guide demonstrates best practices, including connection pooling, parameterized queries to prevent SQL injection, and robust transaction management (BEGIN/COMMIT/ROLLBACK).

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 the Azure Resource Manager SDK for .NET, enabling developers to programmatically manage PostgreSQL Flexible Server deployments on Azure. It covers core cloud automation workflows such as creating the server, setting up databases, configuring firewall rules, and updating server parameters using C# code. Ideal for cloud infrastructure management and CI/CD pipelines.

This SDK provides the management plane interface for provisioning and managing Azure SQL resources (like servers, databases, elastic pools, and firewall rules) within the Azure Resource Manager framework. Built for .NET developers, it allows users to programmatically handle infrastructure setup and configuration, making it ideal for DevOps automation and infrastructure-as-code workflows.

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.

Generates production-ready stored procedures, functions, and triggers for PostgreSQL, MySQL, or SQL Server by analyzing requirements, using the stored-procedure-generator plugin, and returning optimized SQL code for complex logic, integrity, and transaction safety.

This skill provides comprehensive guidance for building scalable, maintainable, and production-ready backend applications using Node.js. It covers modern architectural patterns, best practices, and implementation details for REST APIs, GraphQL servers, microservices, authentication, real-time WebSockets, and complex database integrations (SQL/NoSQL).

A powerful operational companion for database developers. This skill assists with the daily lifecycle of database interactions, including translating natural language requirements into optimized SQL queries, generating database migrations, performing comprehensive schema introspection across multiple dialects (PostgreSQL, MySQL, SQLite, SQL Server), and identifying performance bottlenecks through detailed query optimization and index recommendations. It also supports ORM patterns like Prisma and SQLAlchemy.

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 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.