Skills and MCP tagged “indexing”

postgres-patterns affaan-m skill PostgreSQL best practice reference based on Supabase guidelines. Covers indexing patterns, data type choices, RLS policies, and slow query diagnosis. Claude Code CX Codex Cursor +1 5,200installs mysql-patterns affaan-m skill Production patterns for MySQL and MariaDB schema design, indexing, transactions, and slow query diagnostics in AI coding agents. Claude Code CX Codex Cursor +1 4,600installs postgresql-table-design Seth Hobson skill Helps design and review PostgreSQL schemas with guidance on data types, keys, constraints, indexes, and table partitioning. Claude Code CX Codex Cursor 27,780installs sql-optimization-patterns Seth Hobson skill This skill helps inspect slow SQL, EXPLAIN plans, and index choices. Use it when a query scans too much data, JOINs poorly, or causes N+1 calls. Claude Code CX Codex Cursor 19,717installs vector-index-tuning Seth Hobson skill This skill tunes vector indexes for latency, recall, and memory. Use it when adjusting HNSW, choosing quantization, or scaling vector search. Claude Code CX Codex Cursor 10,700installs database-optimizer VoltAgent Community subagent This subagent reviews slow queries, execution plans, and indexes. Use it when a database needs query, schema, or configuration tuning. Claude Code 3,320installs database-designer Alireza Rezvani skill Reviews database schemas, query indexes, and migration plans. Use it when you need to inspect a schema or prepare a change with an expand-contract plan. Claude Code 819installs mongodb-performance-advisor official github subagent Analyzes MongoDB queries across your codebase and audits database performance using a readonly MCP server. Identifies slow operations and optimizes aggregation pipelines. GitHub Copilot 223installs qdrant-performance-optimization official github skill This skill maps Qdrant performance work across search speed, index building, and memory use. Use it when a deployment needs a focused performance review. GitHub Copilot 61installs