skills.rest
botPhU
botPhUCOMMUNITY
Explore all skills by this author →
GitHub

database-expert

Analyze SQL and NoSQL workloads and produce prioritized database optimization plans.

Updated Dec 5, 2025
Search Tags:#ORM#PostgreSQL#MySQL#MongoDB#analyze#schema-design#database-performance
One-click install
npx skills add https://github.com/botPhU/project-An-English-speaking-practice-platform-supported-by-AI --skill database-expert-botphu
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-expert
Source: https://github.com/botPhU/project-An-English-speaking-practice-platform-supported-by-AI/tree/main/.agent/skills/database-expert
Command: npx skills add https://github.com/botPhU/project-An-English-speaking-practice-platform-supported-by-AI --skill database-expert-botphu

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

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

Core Features & Use Cases

  • Performance optimization and query analysis across major databases.
  • Schema design, normalization, and migration planning for scalable apps.
  • ORM optimization to prevent N+1 queries and improve data access (e.g., Prisma, TypeORM).

Quick Start

Analyze a workload and produce a prioritized optimization plan. For example, run EXPLAIN ANALYZE on slow queries, propose indexing strategies, and outline a minimal, safe migration plan.

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?▼

Database performance optimization identifies slow queries using EXPLAIN ANALYZE and proposes targeted indexing strategies. This generates a prioritized plan to improve PostgreSQL and MySQL query execution.

How do I fix N+1 query problems when using Prisma or TypeORM?▼

Fixing N+1 query problems involves ORM optimization to improve data access patterns. The process analyzes ORM integration scenarios and provides concrete steps to prevent inefficient queries in frameworks like Prisma and TypeORM.

What's the best way to design a scalable database schema for SQL and NoSQL systems?▼

Schema design for scalable apps involves normalization and migration planning across PostgreSQL, MySQL, MongoDB, and SQLite. This ensures structured data access and compatibility with your application's ORM integration.

Does this database optimization approach work with MongoDB and SQLite?▼

Yes, the optimization approach works with MongoDB and SQLite environments. It identifies and resolves database performance issues across both SQL and NoSQL systems, including query tuning and connection management.

How do I plan safe database migrations without breaking existing ORM integrations?▼

Planning safe database migrations requires outlining a minimal, safe migration strategy that ensures ORM compatibility. This includes targeted improvements to schema design and indexing while maintaining connection management across your database.

Related Skills

Explore More Software Engineering Skills→
dieu-donneedieu-donnee

database-optimizer

Identify slow queries and validate index strategies with EXPLAIN ANALYZE across PostgreSQL and MySQL.

Community
Advanced
duynhneduynhne

database-expert

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

Community
Basic
yuhle-qugyuhle-qug

database-expert

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

Community
Advanced
nhonvonhonvo

database-expert

Analyze queries, indexes, and connections to optimize cross-database performance.

Community
Advanced