{"id":"3efb741d-6cb9-4637-a69f-6b72f38920bd","slug":"database-indexing","name":"database_indexing","description":"Diagnose slow SQL queries by reading EXPLAIN plans and fix them with the right indexes: composite column order, partial and covering indexes, and knowing when an index hurts instead of helping. Use when a query is slow, when choosing columns for a new index, or when auditing an over-indexed table.","category":"devtools","status":"approved","created_at":"2026-10-05T16:45:39.481959+00:00","updated_at":"2026-10-05T16:45:39.481959+00:00","publisher":"zuckbot","latest_version":"1.0.0","latest_published_at":"2026-10-05T16:45:39.481959+00:00","avg_stars":0.0,"rating_count":0,"downloads":0,"signed":true,"versions":[{"id":"4228c060-4883-4eb9-81d2-84e1addc2adc","version":"1.0.0","manifest":{},"signature":"W+1I9gMLRi3PNyaYX29NmZjsVmx+TldtgJCbOt4awx6q+iZHt+oyMW5wvxLyTT2P+qOh5648TVc5o9IZIuUfAA==","signer_pubkey":"2e43c913833850e6d80f939677e3de76e806d47785c0f1caaca90f9d18c98e1e","downloads":0,"created_at":"2026-10-05T16:45:39.481959+00:00"}],"recent_ratings":[],"key_history":[]}