database-expert

Name: database-expert
Availability: InStock
Author: yuhle-qug

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

Ready to run

npx skills add https://github.com/yuhle-qug/Parking_Management_System --skill database-expert-yuhle-qug

💬 Prompt for ChatGPT / Claude Chat▼

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.