review-database-access

Audit PHP code for direct mysqli and low-level database access violations.

30|9|Updated Mar 9, 2019
One-click install
npx skills add https://github.com/ktolonen/ultiorganizer --skill review-database-access
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: review-database-access
Source: https://github.com/ktolonen/ultiorganizer/tree/main/docs/ai/review-database-access
Command: npx skills add https://github.com/ktolonen/ultiorganizer --skill review-database-access

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps developers review database access code to prevent violations of access boundaries, ensuring security and maintainability.

Core Features & Use Cases

  • Code Review: Analyze PHP files for direct mysqli calls, low-level SQL usage outside lib/, and legacy cursor APIs.
  • Scope: Applicable after database-related code changes to verify adherence to access policies.
  • Use Case: A developer runs this Skill after modifying database logic to confirm no direct mysqli calls or unsafe SQL are introduced.

Quick Start

Run the review skill on the changed PHP files to identify potential database access boundary violations.

Frequently Asked Questions about review-database-access

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I check PHP code for direct mysqli calls during a code review?

To check PHP code for direct mysqli calls during a code review, scan the modified files for direct database access methods. This Skill audits the code to identify low-level query calls and ensures database interactions adhere to established security boundaries.

What are common database access boundary violations in PHP SQL code?

Common database access boundary violations in PHP SQL code include direct mysqli usage, low-level SQL queries executed outside designated library directories, and the use of deprecated cursor APIs. Scanning for these legacy patterns ensures secure database interaction implementations.

How do I scan PHP files for unsafe SQL and legacy database patterns?

To scan PHP files for unsafe SQL and legacy database patterns, run an automated audit on the changed code. This process detects direct mysqli usage and deprecated cursor APIs, verifying that all database access follows best practices and security boundaries.

When should I audit my PHP code for database access violations?

You should audit your PHP code for database access violations after making database-related code changes. Running an audit on the modified files confirms no direct mysqli calls or unsafe SQL were introduced, ensuring adherence to access policies.

Does this code review tool check for SQL queries outside the lib directory?

Yes, this code review tool checks for low-level SQL queries outside the lib directory. Scanning for database access outside designated library paths prevents security violations and enforces proper architectural boundaries.

Can I use this to find deprecated cursor APIs in PHP database logic?

Yes, you can use this to find deprecated cursor APIs in PHP database logic. The audit specifically targets these legacy patterns alongside direct mysqli calls to ensure all database interactions maintain security and maintainability standards.