sql▌

Universal SQL performance optimization across MySQL, PostgreSQL, SQL Server, Oracle, and other databases. \n \n Covers query analysis, index strategy design, subquery optimization, and JOIN tuning with before/after examples for each technique \n Addresses common anti-patterns including SELECT *, function calls in WHERE clauses, inefficient pagination, and correlated subqueries \n Provides database-agnostic guidance on batch operations, temporary tables, covering indexes, and partial indexes \n I

Write correct, performant SQL across all major data warehouse dialects. \n \n Covers five major dialects: PostgreSQL, Snowflake, BigQuery, Redshift, and Databricks with dialect-specific syntax for date/time, string functions, arrays, and JSON handling \n Includes common analytical patterns: window functions, CTEs, cohort retention, funnel analysis, and deduplication with ready-to-use examples \n Provides performance optimization tips per dialect, such as clustering keys in Snowflake, partition p

Comprehensive SQL security, performance, and quality analysis across MySQL, PostgreSQL, SQL Server, and Oracle databases. \n \n Analyzes SQL injection vulnerabilities, access control issues, and sensitive data exposure with parameterized query examples for each database platform \n Reviews query performance through index strategy, join optimization, and anti-pattern detection (N+1 queries, function misuse in WHERE clauses, overuse of DISTINCT) \n Evaluates code quality including naming conventio

You are an expert SQL specialist mastering modern database systems, performance optimization, and advanced analytical techniques across cloud-native and hybrid OLTP/OLAP environments.

Execute comprehensive SQL injection vulnerability assessments on web applications to identify database security flaws, demonstrate exploitation techniques, and validate input sanitization mechanisms. This skill enables systematic detection and exploitation of SQL injection vulnerabilities across in-band, blind, and out-of-band attack vectors to assess application security posture.

sql-injection-testing

Transform natural language requirements into optimized SQL queries across multiple database platforms. This skill helps product managers, analysts, and engineers generate accurate queries without manual syntax work.

Status: Production Ready Last Updated: 2026-01-24 Dependencies: None Latest Versions: Django@5.1, psycopg2-binary@2.9.9, gunicorn@23.0.0, google-cloud-sql-connector@1.12.0

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.