skills.rest
duynhne
duynhneCOMMUNITY
Explore all skills by this author →
GitHub

database-expert

Optimize database performance across PostgreSQL, MySQL, MongoDB, and SQLite.

Updated Oct 17, 2025
Search Tags:#indexing#database#ORM#PostgreSQL#MySQL#MongoDB#optimize
One-click install
npx skills add https://github.com/duynhne/monitoring --skill database-expert-duynhne
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-expert
Source: https://github.com/duynhne/monitoring/tree/main/.agent/skills/database-expert
Command: npx skills add https://github.com/duynhne/monitoring --skill database-expert-duynhne

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps teams optimize database performance, design efficient schemas, analyze queries, and manage connections across PostgreSQL, MySQL, MongoDB, and SQLite, enabling reliable and scalable data access.

Core Features & Use Cases

  • Performance tuning: analyze query plans, optimize indexes, and tune configuration across multiple engines.
  • Schema design & migrations: apply normalization best practices, plan safe migrations, and integrate with ORMs.
  • Connection management: configure pooling, sizing, and transaction strategies for high-load services.
  • Use Case: A backend service experiencing high latency uses this skill to identify bottlenecks, implement indexing, and optimize connection pools.

Quick Start

Audit a database instance to identify bottlenecks and propose concrete optimizations.

Frequently Asked Questions about database-expert

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

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

Analyze query plans and apply index strategies across PostgreSQL, MySQL, MongoDB, and SQLite to optimize slow database queries. This identifies execution bottlenecks and reduces latency in data-intensive backend services.

What is the best way to plan safe database schema migrations?▼

Apply normalization best practices and plan safe database migrations to ensure reliable schema evolution. This integrates with ORMs and prevents data access disruption during backend service updates.

How do I configure connection pooling for high-load backend services?▼

Configure connection pooling by sizing pools and tuning transaction strategies for high-load backend services. This manages database connections efficiently, preventing pool exhaustion and ensuring reliable data access.

Can I use this database optimization approach with MongoDB and SQLite?▼

Yes, this cross-engine database optimization supports MongoDB and SQLite alongside PostgreSQL and MySQL. It provides engine-specific index strategies and query analysis to tune performance and reliability across all supported databases.

Why does my ORM experience high latency during data-intensive workloads?▼

ORM high latency in data-intensive workloads often stems from missing indexes or inefficient query plans. Analyze generated queries, implement indexing strategies, and optimize connection pools to resolve performance bottlenecks.

Related Skills

Explore More Software Engineering Skills→
GDSDNGDSDN
3

db-explain

Analyze PostgreSQL query plans with EXPLAIN ANALYZE to identify bottlenecks.

Community
Advanced
emiled16emiled16

postgres-patterns

Optimize PostgreSQL queries, schemas, and security configurations.

Community
Intermediate
ThejanaJayalathThejanaJayalath

kotlin-exposed-patterns

Standardize database access in Kotlin with Exposed ORM patterns.

Community
Advanced
zinohomezinohome
1

db-performance-watchlist

Monitor database performance with slow query detection and resource alerts.

Community
Advanced