sql-injection-prevention

Prevent SQL injection attacks using prepared statements, parameterized queries, and input validation. Use when building database-driven applications securely.

By aj-geddes · 507 installs

npx skills add aj-geddes/useful-ai-prompts --skill sql-injection-prevention

Source repository · Upstream listing

SQL Injection Prevention Table of Contents [Overview]( overview) [When to Use]( when to use) [Quick Start]( quick start) [Reference Guides]( reference guides) [Best Practices]( best practices) Overview Implement comprehensive SQL injection prevention using prepared statements, parameterized queries, ORM best practices, and input validation. When to Use Database query development Legacy code security review Security audit remediation API endpoint development User input handling Dynamic query generation Quick Start Minimal working example: Reference Guides Detailed implementations in the references/ directory: Guide Contents [Node.js with PostgreSQL](references/nodejs with postgresql.md) Node.js with PostgreSQL [Python with SQLAlchemy ORM](references/python with sqlalchemy orm.md) Python with SQLAlchemy ORM [Java JDBC with Prepared Statements](references/java jdbc with prepared statements.md) Java JDBC with Prepared Statements [Input Validation & Sanitization](references/input validation sanitization.md) Input Validation & Sanitization Best Practices ✅ DO Use prepared statements ALWAYS Use ORM frameworks properly Validate all user inputs Whitelist dynamic values Use least privilege DB accounts Enable query logging Regular security audits Use parameterized queries ❌ DON'T Concatenate user input Trust client side validation Use string formatting for queries Allow dynamic table/column names Grant excessive DB permissions Skip input validation