Skip to content
Development
Command

/add-index

Add database indexes to improve query performance with migration safety.

From plugin
rohitg00-claude-code-toolkit
2.8k199 skills138 agents199 commands
$ npx -y skills add rohitg00/awesome-claude-code-toolkit --agent claude-code

Command definition

add-index.md

Add database indexes to improve query performance with migration safety.

Steps

1. Identify the query patterns that need indexing: 2. Choose the index type: 3. Design the index: 4. Create the migration: 5. Estimate the impact: 6. Deploy safely:

Format

Table: <table name>
Index: <index name>
Columns: <column list>
Type: <B-tree|Hash|GIN|GiST>

Rules

  • Always use CONCURRENTLY for production index creation.
  • Name indexes descriptively: idx_table_column1_column2.
  • Do not create redundant indexes (check existing indexes first).
@rohitg00
Ships withrohitg00-claude-code-toolkit

The most comprehensive toolkit for Claude Code -- 135 agents, 35 curated skills (+400,000 via SkillKit), 42 commands, 176+ plugins, 20 hooks, 15 rules, 7 templates, 15 MCP configs, 26 companion apps, 53 ecosystem entries, and more.

2.8k40 skills138 agents
Get the whole plugin

Stars on GitHub

Momentum

stars in total
2.8k
Star history of rohitg00/awesome-claude-code-toolkit on GitHub, a chart by star-history.com

Other commands on rohitg00-claude-code-toolkit.

More commands from other plugins.

build
Auto-invoked

build

Command

Implement tasks incrementally — build, test, verify, commit. Add "auto" to run the whole plan in one approved pass.

@addyosmani@addyosmaniInstall Command