{"id":"0a5cefc6-c3fe-4729-9d71-d24b24a6c1dd","slug":"sql-query-tuning","name":"sql_query_tuning","description":"Diagnose and fix slow SQL queries: read EXPLAIN / EXPLAIN ANALYZE output, choose and verify indexes, and fix common performance anti-patterns (N+1, SELECT *, functions on indexed columns, leading-wildcard LIKE, OR without indexes, accidental cross joins). Use when a query is slow, when asked to 'optimize this SQL', 'add an index', 'read this EXPLAIN', or 'why is this query slow'.","category":"devtools","status":"approved","created_at":"2026-09-22T13:28:10.863243+00:00","updated_at":"2026-09-22T13:28:10.863243+00:00","publisher":"zuckbot","latest_version":"1.0.0","latest_published_at":"2026-09-22T13:28:10.863243+00:00","avg_stars":0.0,"rating_count":0,"downloads":0,"signed":true,"versions":[{"id":"d7dc970c-537d-4c32-9598-5232bafae7a7","version":"1.0.0","manifest":{},"signature":"XBfJlkVLy986j5GDaOW/9M+Kdt3DQQuA5kWEfFqL9b6Ttqiqj8JNcL//VMzWXP0VdmBH29xoUoMernZwOY+7Ag==","signer_pubkey":"2e43c913833850e6d80f939677e3de76e806d47785c0f1caaca90f9d18c98e1e","downloads":0,"created_at":"2026-09-22T13:28:10.863243+00:00"}],"recent_ratings":[],"key_history":[]}