jeremylongshore

Automates the review of pull requests for coding standards, security, and test coverage, providing structured feedback and approval.

Audits Node.js npm dependencies for known CVEs, standardizing findings for security assessments and compliance checks.

Audits Python project dependencies for known vulnerabilities using pip-audit, ensuring security compliance and risk management.

Audits project dependencies for license compliance, flagging issues before production to prevent legal complications.

Generates a comprehensive markdown vulnerability report by deduplicating findings and organizing them by severity for security assessments.

Ensures penetration tests have proper authorization by validating ROE files, preventing unauthorized access and legal issues.

This skill parses pentest scope definitions to create a validated target list and IP allowlist for security assessments.

Generates concise executive summaries from security findings, providing risk scores and remediation priorities for C-level audiences.

Annotates pentest findings with OWASP Top 10 categories, enhancing reports for compliance and structured assessments.

Packages pentest findings into a secure, timestamped archive with cryptographic proof, ensuring evidence integrity and chain of custody.

Analyzes project dependencies to trace vulnerabilities and recommend direct dependency upgrades for effective remediation.

Checks data quality and pipeline health, ensuring freshness, schema integrity, and identifying issues in data pipelines.

Facilitates zero-downtime database migrations with executable SQL for forward and rollback changes, ensuring safe schema modifications.

Flux optimizes slow database queries by analyzing execution plans, suggesting indexes, and rewriting queries for better performance.

Conducts comprehensive database reconnaissance to assess schema, migrations, data health, and operational efficiency.

Designs and builds comprehensive database schemas, including tables, relationships, and constraints, tailored to specific domain requirements.

Facilitates multi-level code reviews for quality, security, and performance, offering actionable feedback and fixes.

Provides a CRUD interface for managing hyperflow memory entries, allowing users to view, search, and manipulate memory data efficiently.

Facilitates deployment by running pre-push checks and managing commits, releases, and pushes with explicit user confirmation.

Facilitates task dispatching and parallel processing in multi-agent systems, ensuring efficient execution and review of workflows.