skills.rest
yuhle-qug
yuhle-qugCOMMUNITY
Explore all skills by this author →
GitHub

database-expert

Analyze and optimize database performance across PostgreSQL, MySQL, MongoDB, and SQLite.

Updated Jan 2, 2026
Search Tags:#performance#indexing#database#ORM#migration#analyze#schema-design
One-click install
npx skills add https://github.com/yuhle-qug/Parking_Management_System --skill database-expert-yuhle-qug
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-expert
Source: https://github.com/yuhle-qug/Parking_Management_System/tree/main/.agent/skills/database-expert
Command: npx skills add https://github.com/yuhle-qug/Parking_Management_System --skill database-expert-yuhle-qug

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps software teams optimize database performance, design scalable schemas, analyze slow queries, and manage connections across PostgreSQL, MySQL, MongoDB, and SQLite with ORM integration.

Core Features & Use Cases

  • Performance Analysis: Identify slow queries, inefficient indexes, and misconfigured connections.
  • Schema & ORM Design: Propose normalized or denormalized schemas and ORM mappings for different databases.
  • Cross-DB Best Practices: Provide guidelines for indexing, transactions, pooling, and migration strategies.
  • Use Case: For a high-traffic application, review the database setup and suggest indexing and ORM strategies to improve read throughput and write performance.

Quick Start

Use the skill to analyze a PostgreSQL schema and recommend indexing and ORM mappings to improve read throughput.

Frequently Asked Questions about database-expert

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

FAQPage Schema
How do I analyze and optimize slow database queries in PostgreSQL?▼

To optimize slow database queries, you analyze execution plans to identify bottlenecks and apply targeted indexing strategies. This highlights inefficient indexes and recommends schema adjustments to improve database read throughput.

What is the best way to design scalable database schemas for high-traffic applications?▼

Designing scalable database schemas involves proposing normalized or denormalized structures based on traffic patterns. This balances read and write performance by aligning ORM mappings and indexing strategies with your application load.

How do I fix ORM inefficiencies affecting database performance?▼

To fix ORM inefficiencies, you analyze ORM integration patterns to detect misconfigured connections and suboptimal queries. This provides optimized ORM mappings and transaction handling guidelines to reduce database overhead.

Does this approach work for both SQL and NoSQL databases like MongoDB?▼

Yes, this approach works for both SQL and NoSQL databases. You can apply cross-database best practices to manage connections, transactions, and indexing strategies across PostgreSQL, MySQL, MongoDB, and SQLite.

When do I need to plan a database migration for performance optimization?▼

You need to plan a database migration when schema changes are required to resolve performance bottlenecks. This evaluates indexing strategies and connection pooling configurations to ensure throughput during deployment.

Related Skills

Explore More Software Engineering Skills→
rabbicserabbicse

database-optimizer

Optimize slow PostgreSQL and MySQL queries with EXPLAIN ANALYZE validation.

Community
Advanced
JesusFigueroa25JesusFigueroa25

Database Optimizer

Optimize PostgreSQL and MySQL database performance through schema, query, and indexing analysis.

Community
Advanced
EIS-ITSEIS-ITS

Backend Queries

Generate secure, optimized database queries with parameterized statements, eager loading, indexing, and transactions.

Official
Intermediate
AndyAnh174AndyAnh174

database-optimizer

Optimize relational and cloud database performance through index tuning and query rewriting.

Community
Advanced