skills.rest
samChang72
samChang72COMMUNITY
Explore all skills by this author →
GitHub

database-specialist

Analyze and optimize SQL database queries with EXPLAIN ANALYZE and indexing strategies.

1|Updated Feb 2, 2026
Search Tags:#indexing#schema design#database performance#database optimization#SQL query analysis
One-click install
npx skills add https://github.com/samChang72/custom-skills --skill database-specialist-samchang72
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-specialist
Source: https://github.com/samChang72/custom-skills/tree/main/gemini/skills/database-specialist
Command: npx skills add https://github.com/samChang72/custom-skills --skill database-specialist-samchang72

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill resolves the challenge of optimizing database performance, specifically targeting slow query elimination and efficient indexing and schema design.

Core Features & Use Cases

  • Query Optimization: Utilize EXPLAIN ANALYZE for in-depth query analysis and performance tuning.
  • Index Strategy: Implement B-Tree, GIN, Composite Index, and Partial Index effectively.
  • Performance Enhancements: Apply strategies like JOIN optimization and avoiding SELECT * to enhance performance.
  • Use Case: For a developer or DBA, if you're experiencing slow database performance or need to enhance the efficiency of a database schema, this skill provides the tools and guidance to optimize your database queries and structure.

Quick Start

Run the 'db_optimize' command to optimize the slow queries in your database.

Frequently Asked Questions about database-specialist

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I eliminate slow SQL queries and optimize database performance?▼

To eliminate slow SQL queries and optimize database performance, this Skill uses EXPLAIN ANALYZE for query analysis and applies indexing strategies to enhance execution speed.

What is the best way to design an efficient database indexing strategy?▼

The best way to design an efficient database indexing strategy is by implementing B-Tree, GIN, Composite Index, and Partial Index structures based on your specific query patterns and schema design requirements.

How do I analyze SQL query performance using EXPLAIN ANALYZE?▼

You can analyze SQL query performance by running the db_optimize command, which utilizes EXPLAIN ANALYZE to provide in-depth query analysis and guide performance tuning for slow queries.

Can I use this to optimize JOIN operations and avoid SELECT * in my schema?▼

Yes, you can use this Skill to apply performance enhancements like JOIN optimization and avoiding SELECT * to improve query efficiency and refine your database schema design.

When do I need to redesign my database schema for better query performance?▼

You need to redesign your database schema for better query performance when experiencing slow database performance, requiring SQL query optimization skills and efficient indexing strategies to resolve execution bottlenecks.

Related Skills

Explore More Software Engineering Skills→
gaebalaigaebalai
2

db-index-suggest

Analyzes SQL queries, slow query logs, and execution plans to suggest database index improvements.

Community
Advanced
interflownexinterflownex
2

cloud-sql-sqlserver-monitor

Analyze Google Cloud SQL for SQL Server performance metrics via PromQL queries.

Community
Intermediate
irizqiirizqi

laravel-database-optimization

Optimize Laravel 13 database queries with eager loading and indexing strategies.

Community
Advanced
spqwspqw

observable-framework-data-loaders

Generate static data snapshots with polyglot data loaders in Observable Framework.

Community
Advanced