skills.rest
boshi-xixixi
boshi-xixixiCOMMUNITY
Explore all skills by this author →
GitHub

Backend Database Expert

Analyze SQL queries with EXPLAIN plans and indexing strategies.

6|1|Updated Jan 23, 2026
Search Tags:#performance#schema design#database#optimization#migration#sql
One-click install
npx skills add https://github.com/boshi-xixixi/agenticflow-skills --skill backend-database-expert
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Backend Database Expert
Source: https://github.com/boshi-xixixi/agenticflow-skills/tree/main/skills/05_Backend_Database
Command: npx skills add https://github.com/boshi-xixixi/agenticflow-skills --skill backend-database-expert

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) and assets (resource) components.

What problem does it solve?

This Skill addresses challenges in database design, SQL query performance, and safe data migration, ensuring your data layer is efficient and reliable.

Core Features & Use Cases

  • SQL Optimization: Analyze and improve slow queries using EXPLAIN plans and indexing strategies.
  • Database Migration: Safely manage schema changes and data transformations with rollback capabilities.
  • Use Case: Optimize a slow-performing API endpoint by identifying and fixing inefficient SQL queries, or safely update your database schema during a production deployment without downtime.

Quick Start

Use the SQL optimization skill to analyze the performance of the provided SQL query.

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 using EXPLAIN analysis?▼

Analyze EXPLAIN plans to identify execution bottlenecks and apply indexing strategies to optimize slow SQL queries. This reduces query latency by ensuring the database engine retrieves data using the most efficient access paths.

What is the best way to handle database schema migration without downtime?▼

Implement zero-downtime schema migration techniques with rollback capabilities to safely evolve database structures. This ensures continuous system availability and maintains data integrity during production deployments.

How does indexing improve database performance for backend systems?▼

Indexing improves database performance by creating efficient data retrieval structures that reduce disk I/O and query execution time. Proper index design prevents full table scans and accelerates data access for backend applications.

Can I transform data across different ORMs during database migration?▼

Yes, you can transform data across different ORMs and platforms during database migration. The skill manages data transformation to ensure compatibility and integrity when moving between different object-relational mapping frameworks.

What are common pitfalls in database management and schema design?▼

Common pitfalls in database management include inefficient schema design, missing indexes, and unsafe schema changes. Addressing these through performance tuning and zero-downtime migration techniques prevents data corruption and maintains system reliability.

Related Skills

Explore More Software Engineering Skills→
DexploarerDexploarer
6

database-query-optimizer

Analyze EXPLAIN plans and recommend indexes for PostgreSQL, MySQL, and MongoDB.

Community
Advanced
sigmadigitalzasigmadigitalza
1

database-review

Review database schemas, migration files, and query performance.

Official
Advanced
KILWA73KILWA73

sql-injection-guard

Detect non-parameterized SQL and rewrite queries with bound parameters.

Community
Advanced
RightNow-AIRightNow-AI
18.1k

postgres-expert

Analyze PostgreSQL query plans and recommend indexing strategies.

Official
Advanced