database-optimizer
This skill is for Data & Analytics and helps you optimize slow database queries, analyze query execution plans, and design database indexes.
Optimizes database queries and improves performance across PostgreSQL and MySQL systems. Use when investigating slow queries, analyzing execution plans, or optimizing database performance. Invoke for index design, query rewrites, configuration tuning, partitioning strategies, lock contention resolution.
Helps you
- Optimize slow database queries
- Analyze query execution plans
- Design database indexes
- Tune database configuration
- Resolve lock contention issues
- Implement partitioning strategies
Install
Plugin marketplace/plugin marketplace add Jeffallan/claude-skills
/plugin install database-optimizerWhat it can use
The author didn’t declare which tools this skill uses. Read the SKILL.md before installing it.
postgresqlMysqlperformanceindexingQuery OptimizationDatabase Tuning
Also in Jeffallan/claude-skills
View the repoGenerates Angular 17+ standalone components, configures advanced routing with lazy loading and guards, implements NgRx state management, app...
Use when designing REST or GraphQL APIs, creating OpenAPI specifications, or planning API architecture. Invoke for resource modeling, versio...
Use when designing new high-level system architecture, reviewing existing designs, or making architectural decisions. Invoke to create archi...
Integrates with Atlassian products to manage project tracking and documentation via MCP protocol. Use when querying Jira issues with JQL fil...
Designs chaos experiments, creates failure injection frameworks, and facilitates game day exercises for distributed systems — producing runb...
Use when building CLI tools, implementing argument parsing, or adding interactive prompts. Invoke for parsing flags and subcommands, display...
Designs cloud architectures, creates migration plans, generates cost optimization recommendations, and produces disaster recovery strategies...
Generates, formats, and validates technical documentation — including docstrings, OpenAPI/Swagger specs, JSDoc annotations, doc portals, and...
Analyzes code diffs and files to identify bugs, security vulnerabilities (SQL injection, XSS, insecure deserialization), code smells, N+1 qu...
Writes, optimizes, and debugs C++ applications using modern C++20/23 features, template metaprogramming, and high-performance systems techni...
Use when building C# applications with .NET 8+, ASP.NET Core APIs, or Blazor web apps. Builds REST APIs using minimal or controller-based ro...
Parses error messages, traces execution flow through stack traces, correlates log entries to identify failure points, and applies systematic...
Other Data & Analytics skills
An engineering runbook — service overview, alerts table, dashboards links, common procedures with copy-pasteable commands, on-call rotation,...
Professional trading analysis dashboard template (single-file HTML) with light/dark theme switch, dense market panels, chart interactions, d...
A consumer-feeling dating / matchmaking dashboard — left rail navigation, ticker bar of community signals, headline KPIs, a 30-day mutual-ma...
Teaches the agent to produce D3 charts and interactive data visualizations. A comprehensive D3.js skill with examples across chart types and...
Notion-style team dashboard rendered as a Live Artifact. A single-page, self-contained HTML dashboard with KPIs, a 7-day sparkline, a real-t...
Admin / analytics dashboard in a single HTML file. Fixed left sidebar, top bar with user/search, main grid of KPI cards and one or two chart...