/add-index

Add database indexes to improve query performance with migration safety.

Boost this command

rohitg00@rohitg00

GitHub

From plugin

rohitg00-claude-code-toolkit

2.6k199 skills138 agents199 commands

Install

$ npx -y skills add rohitg00/awesome-claude-code-toolkit --agent claude-code

How it fires

How this command gets triggered: by you, by Claude, or both.

Fires itselfClaude auto-loads it when your prompt matches the work.
You can call itInvoke it directly when you want it.
Slash command/add-index

Context preview

What this command does when you run it.

Add database indexes to improve query performance with migration safety.

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).

Read it on GitHub ↗

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.

Get the whole plugin

Stats

Python JavaScript React CSS Kubernetes

+7 tags

AWS Git GitHub CI/CD Anthropic MCP Flutter

2,608

Stars

939

Forks

Maintained

Maintenance

JavaScript