PostgreSQL Index Advisor
Read your pg_stat_statements, get 3 indexes that fix 80% of slow queries.
Install
npx -y @tbc/pg-index-advisornpx -y @tbc/pg-index-advisornpx -y @tbc/pg-index-advisorAbout
Analyses query patterns and outputs CREATE INDEX statements with rationale + EXPLAIN deltas.
Stacks
Tags
Related skills
Ainative Zerodb
AINative ZeroDB MCP Server - 77 operations for vector search, quantum compression, NoSQL, dedicated PostgreSQL management, files, events, RLHF, and persistent memory for AI agents with enterprise security. All tools annotated with readOnly/destructive/ide
Database
MCP server for database connectivity. Multi-DB (PostgreSQL, MySQL, SQLite), connection management, schema introspection, query execution with token-optimized responses, rollback, history, elicitation for destructive ops, and prepared statements. Zero conf
Infrawise
CLI-first infrastructure intelligence platform — analyzes DynamoDB, PostgreSQL, MySQL, MongoDB, SQS, SNS, SSM, Secrets Manager, Lambda, S3, CloudWatch Logs and exposes findings as an MCP server for Claude Code