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.

A comprehensive guide to setting up a minimal working example on Databricks. This skill covers creating a development cluster, uploading and executing notebooks (Python SDK), running tasks as jobs, and setting up a Serverless SQL Warehouse. It is ideal for new users or initializing a basic data engineering project.

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

This tool provides a comprehensive framework for analyzing web server logs (Apache/Nginx) to detect various security threats. It uses advanced regex matching against OWASP attack signatures to identify SQL injection, Local File Inclusion, and Directory Traversal attempts, alongside behavioral analysis for brute-force attacks and web scanner fingerprints. The system also enriches data using GeoIP for source attribution, generating a prioritized report for SOC analysts.

This skill details the deployment of Privileged Access Management (PAM) for critical database systems, including Oracle, SQL Server, PostgreSQL, and MySQL. It covers essential security controls such as session proxy configuration, credential vaulting, query auditing, and enforcing least-privilege access, helping organizations meet stringent compliance and security standards.

Nikto is a powerful, open-source web server and web application scanner designed for comprehensive vulnerability assessment. It tests over 7,000 potentially dangerous files and checks for critical issues like XSS, SQL injection, outdated versions, and misconfigurations across modern web applications. Ideal for security audit, penetration testing, and validating web server security controls.

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.