Database Indexing Strategy
Design indexing strategies for slow queries by analyzing access patterns, choosing composite and partial indexes, and balancing read speed with write overhead and storage cost.
npx skills add https://github.com/aj-geddes/useful-ai-prompts --skill database-indexing-strategy| Installs | 388 |
|---|---|
| Repository | aj-geddes/useful-ai-prompts ↗ |
Related skills
Lark BaseOperate Feishu Base (Bitable): schema, records, views, formulas, lookups, sharing, dashboards, workflows, and guided data analysis via lark-cli.246k
Supabase Postgres Best PracticesGive your coding agent Supabase-backed Postgres rules so schemas, queries, RLS, and pooling stay fast and production-safe.238k2.2k
Convex Migration HelperPlan and execute Convex schema and data migrations without breaking live readers or writers.67.9k31
Neon PostgresSet up Neon serverless Postgres, connection strings, branching, pooling, auth, and tooling (CLI, MCP, SDKs) with answers grounded in official Neon docs.42.2k68
Firebase Firestore StandardProvision Firestore Standard Edition, write security rules, and integrate the Firestore SDK with correct indexes and query patterns.36.7k345
Postgresql Table DesignDesign or review a PostgreSQL schema with correct types, keys, indexes, and normalization before migrations ship.19.8k36.5k