skills.rest
leafcoder
leafcoderCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

Backend Database Expert

Analyze SQL query execution plans and generate optimized index strategies.

2|Updated Jun 27, 2017
Search Tags:#performance#database#optimization#schema#migration#sql
One-click install
npx skills add https://github.com/leafcoder/litefs --skill backend-database-expert-leafcoder
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Backend Database Expert
Source: https://github.com/leafcoder/litefs/tree/main/.trae/skills/05_Backend_Database
Command: npx skills add https://github.com/leafcoder/litefs --skill backend-database-expert-leafcoder

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This skill addresses the complexities of database performance bottlenecks, inefficient schema design, and the risks associated with manual database migrations.

Core Features & Use Cases

  • SQL Optimization: Analyze query execution plans (EXPLAIN) to resolve slow queries and N+1 problems.
  • Database Migration: Manage schema changes and data transformations with zero-downtime strategies and rollback procedures.
  • Use Case: When a production application experiences latency, use this skill to identify missing indexes or inefficient JOINs and generate a safe migration script to apply the necessary schema improvements.

Quick Start

Use the Backend Database Expert skill to analyze the provided SQL query and suggest an optimized index strategy.

Frequently Asked Questions about Backend Database Expert

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

FAQPage Schema
How do I optimize slow SQL queries and resolve N+1 problems?▼

Zero-downtime database migration is achieved by managing schema changes and data transformations with rollback procedures, ensuring reliable schema evolution without taking the production application offline.

How do I execute zero-downtime database migrations with rollback procedures?▼

Zero-downtime database migration is executed by managing schema changes and data transformations with rollback procedures, ensuring reliable schema evolution without taking the production application offline.

What are the best indexing strategies for high-performance database schema design?▼

High-performance database schema design uses indexing strategies and schema design patterns to optimize data layer maintenance, identifying missing indexes to eliminate latency and satisfy performance requirements.

Does this database optimization approach work with various ORMs for schema migration?▼

This database optimization approach supports complex database migration workflows across various ORMs, enabling safe schema evolution and rollback procedures for different object-relational mapping environments.

When should I use schema design patterns to resolve database performance bottlenecks?▼

Schema design patterns are used to resolve database performance bottlenecks when a production application experiences latency, allowing you to apply necessary schema improvements through safe migration scripts.

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
shhubbhshhubbh
1

land-and-deploy

Merge PRs, wait for CI, deploy to production, and verify health via canary checks.

Community
Advanced
PlazaCCPlazaCC
2

db-migrate

Generate and apply Drizzle ORM migration scripts for Supabase Postgres.

Official
Intermediate
bipinksbipinks
3

performance-optimization

Identify bottlenecks in Laravel apps and provide profiling, optimization, and load testing steps.

Community
Advanced