Loading...
Loading...
Found 16 Skills
SQLite expert for WAL mode, query optimization, embedded patterns, and advanced features
Diagnoses and optimises slow SQL queries using EXPLAIN ANALYZE. Covers identifying bottlenecks (sequential scans, bad estimates, heap fetches), index strategy, query rewrites, and verification. Invoked when the user asks to optimize a query, fix a slow database query, or improve database performance.
PostgreSQL expert for query optimization, indexing, extensions, and database administration
Advanced database performance tuning including query optimization, indexing strategies, partitioning, and scaling patterns