skills.rest
htlin222
htlin222COMMUNITY
Explore all skills by this author →
Website𝕏@htlin222GitHub

database

Analyze SQL queries and create indexes for PostgreSQL and MySQL databases.

77|4|Updated Jun 20, 2022
Search Tags:#schema design#database#migrations#optimization#sql#performance tuning#administration
One-click install
npx skills add https://github.com/htlin222/dotfiles --skill database-htlin222
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database
Source: https://github.com/htlin222/dotfiles/tree/main/claude.symlink/skills/database
Command: npx skills add https://github.com/htlin222/dotfiles --skill database-htlin222

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill addresses challenges related to database performance, schema management, and operational efficiency, helping users resolve slow queries, design robust schemas, and maintain database health.

Core Features & Use Cases

  • Query Optimization: Analyze and improve the performance of SQL queries.
  • Schema Design & Migrations: Guide users through best practices for creating and evolving database schemas safely.
  • Database Administration: Provide commands for health checks, maintenance, and monitoring.
  • Caching Strategies: Offer examples for implementing caching to reduce database load.
  • Use Case: A user is experiencing slow load times on their e-commerce site. They can use this Skill to analyze their orders table queries, identify missing indexes, and implement them to speed up data retrieval.

Quick Start

Use the database skill to analyze a slow SQL query.

Frequently Asked Questions about database

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

FAQPage Schema
How do I optimize slow SQL queries in PostgreSQL and MySQL?▼

To optimize slow SQL queries, you analyze the execution plan to identify bottlenecks and missing indexes. This skill assists by analyzing your SQL queries and recommending index creation to significantly speed up data retrieval in PostgreSQL and MySQL.

What is the best way to design efficient database schemas and manage migrations?▼

Efficient database schema design structures tables to minimize redundancy and ensure data integrity. This skill guides you through schema design best practices and safe migration strategies to evolve your database structure without disrupting operations.

How do I perform database health checks and routine maintenance for administration?▼

Database health checks involve monitoring metrics and running maintenance commands to ensure operational efficiency. This skill provides administrative commands for health checks, maintenance, and monitoring to effectively maintain database health.

Can I use caching strategies to reduce database load?▼

Yes, caching strategies reduce database load by storing frequently accessed data in memory. This skill offers examples for implementing caching to reduce database load and significantly improve overall query performance.

Related Skills

Explore More Software Engineering Skills→
QcasaresQcasares

sql-toolkit

Execute SQL queries against SQLite, PostgreSQL, and MySQL databases.

Community
Intermediate
dotBeepsdotBeeps

database

Design relational database schemas and optimize queries across PostgreSQL, Prisma, SQLAlchemy, GORM, and Drizzle.

Community
Advanced
ryanmatryanmat

lm-apm

Investigate LogicMonitor APM trace data to diagnose service issues and correlate alerts.

Community
Advanced
AmidVoshakulAmidVoshakul

database-optimizer

Analyze execution plans and implement indexing strategies to optimize database performance.

Community
Advanced