iClaude
TBC Skillpacks· verified

PostgreSQL Index Advisor

Read your pg_stat_statements, get 3 indexes that fix 80% of slow queries.

Install

bash
npx -y @tbc/pg-index-advisor
claude
npx -y @tbc/pg-index-advisor
cursor
npx -y @tbc/pg-index-advisor

About

Analyses query patterns and outputs CREATE INDEX statements with rationale + EXPLAIN deltas.

Publisher
TBC
License
Proprietary
Format
npx
Price
Free

Stacks

claudecursorbash

Tags

postgresperformancedba
source ↗ https://iclaude.io/skills/tbc-postgresql-index-advisor

Related skills

Postgres

MCP Registry

PostgreSQL MCP server with connection pooling, tool filtering, and full extension support

MCP Registry · ★ 5.0free

Db

MCP Registry

MCP server for databases — structured PostgreSQL, MySQL, Redis, and MongoDB output for AI agents

MCP Registry · ★ 5.0free

Infrawise

MCP Registry

CLI-first infrastructure intelligence platform — analyzes DynamoDB, PostgreSQL, MySQL, MongoDB, SQS, SNS, SSM, Secrets Manager, Lambda, CloudWatch Logs and exposes findings as an MCP server for Claude Code

MCP Registry · ★ 5.0free