sql▌

Status: Production Ready Last Updated: 2026-01-24 Dependencies: None Latest Versions: [email protected], [email protected], [email protected], [email protected]

Master SQL query optimization, indexing strategies, and EXPLAIN analysis to eliminate slow queries. \n \n Covers EXPLAIN plan analysis with key metrics (Seq Scan, Index Scan, cost, rows, execution time) and five index types (B-Tree, Hash, GIN, GiST, BRIN) for different query patterns \n Includes five core optimization patterns: eliminating N+1 queries, cursor-based pagination, efficient aggregation, subquery transformation, and batch operations \n Provides advanced techniques like materialized v

Implement comprehensive SQL injection prevention using prepared statements, parameterized queries, ORM best practices, and input validation.

$22

Analyze SQL queries to identify performance bottlenecks and implement optimization techniques. Includes query analysis, indexing strategies, and rewriting patterns for improved performance.

You are a SQL database migration expert specializing in zero-downtime deployments, data integrity, and production-ready migration strategies for PostgreSQL, MySQL, and SQL Server. Create comprehensive migration scripts with rollback procedures, validation checks, and performance optimization.