Skill UI

This guide details how to implement HashiCorp Vault's dynamic secrets engine. It automates the generation, lease management, and rotation of short-lived credentials for databases (e.g., PostgreSQL, MySQL), AWS IAM, and PKI certificates. This method eliminates the use of static, hardcoded secrets, enforcing zero-trust principles and meeting stringent compliance mandates like PCI-DSS.

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.

LaZagne is an open-source post-exploitation tool utilized by red teams to harvest stored credentials from compromised endpoints. It supports Windows, Linux, and macOS, extracting passwords from browsers (Chrome, Edge), databases (MySQL, SQLite), system vaults (DPAPI, LSA), and various applications. It is crucial for privilege escalation and lateral movement during authorized security assessments.

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.

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.

A comprehensive guide for Amazon Aurora DSQL, a serverless, PostgreSQL-compatible distributed SQL database. This skill covers the entire database lifecycle, including schema management, direct query execution, complex data migrations (e.g., MySQL to DSQL), and advanced performance tuning via query plan analysis (EXPLAIN ANALYZE). Essential for secure, multi-tenant application development.

Provides a comprehensive guide for managing Amazon Aurora DSQL, a serverless, PostgreSQL-compatible distributed SQL database. It covers direct query execution, robust schema management, safe schema evolution, multi-tenant isolation patterns, and IAM authentication. Use cases include database development, complex migrations (e.g., MySQL to DSQL), and optimizing query performance using detailed plan explainability tools.

A comprehensive guide for working with Aurora DSQL, a serverless, PostgreSQL-compatible distributed SQL database. This skill covers full lifecycle development, including schema management, data migration (e.g., MySQL to DSQL), multi-tenant patterns, IAM authentication, and advanced query plan explainability. Essential for building robust, scalable applications.

A comprehensive guide for developing and managing applications using Amazon Aurora DSQL, a serverless, PostgreSQL-compatible distributed SQL database. This skill covers core capabilities including direct query execution, robust schema management, safe data migration from MySQL, multi-tenant architectural patterns, IAM-based authentication, and detailed query plan explainability for performance tuning. Essential for developers handling complex database evolution.

This skill provides expert guidance on building and maintaining applications using Amazon Aurora DSQL, a serverless, PostgreSQL-compatible distributed SQL database. It covers critical areas including schema management, multi-tenant architecture, IAM authentication, and safe data migrations (e.g., MySQL to DSQL). Users can execute direct queries, analyze performance bottlenecks using query plan explainability, and adhere to industry best practices for robust, scalable database design.

This skill provides comprehensive guidance for building and managing applications using Amazon Aurora DSQL, a serverless, distributed, PostgreSQL-compatible SQL database. Topics cover schema management, multi-tenant isolation, IAM authentication, complex DDL migrations (column, constraint), MySQL data type mapping, and advanced query performance tuning using plan explainability tools, ensuring robust and scalable data architecture.