SQL query optimization for PostgreSQL/MySQL with indexing, EXPLAIN analysis. Use for slow queries, N+1 problems, missing indexes, or encountering sequential scans, OFFSET pagination, temp table spills, inefficient JOINs.
Optimizes SQL queries for PostgreSQL/MySQL with indexing advice, EXPLAIN analysis, and solutions for common performance issues.
Why this plugin
Solves database performance problems like slow queries and N+1 issues. Provides expert-level optimization guidance for indexing, joins, and pagination directly within Claude Code.
Prerequisites
Requires access to a PostgreSQL or MySQL database and the ability to run queries. Basic SQL knowledge needed to provide query examples for analysis.
npx claudepluginhub secondsky/claude-skillsUpstash Context7 MCP server for up-to-date documentation lookup. Pull version-specific documentation and code examples directly from source repositories into your LLM context.
Payload Development plugin - covers collections, fields, hooks, access control, plugins, and database adapters.
UI/UX design intelligence. 50 styles, 21 palettes, 50 font pairings, 20 charts, 9 stacks (React, Next.js, Vue, Svelte, SwiftUI, React Native, Flutter, Tailwind, shadcn/ui). Actions: plan, build, create, design, implement, review, fix, improve, optimize, enhance, refactor, check UI/UX code. Projects: website, landing page, dashboard, admin panel, e-commerce, SaaS, portfolio, blog, mobile app, .html, .tsx, .vue, .svelte. Elements: button, modal, navbar, sidebar, card, table, form, chart. Styles: glassmorphism, claymorphism, minimalism, brutalism, neumorphism, bento grid, dark mode, responsive, skeuomorphism, flat design. Topics: color palette, accessibility, animation, layout, typography, font pairing, spacing, hover, shadow, gradient. Integrations: shadcn/ui MCP for component search and examples.
Schema validation, data quality monitoring, streaming validation pipelines, and input validation for backend APIs