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

Ready to run

npx skills add https://github.com/botPhU/project-An-English-speaking-practice-platform-supported-by-AI --skill database-expert-botphu

💬 Prompt for ChatGPT / Claude Chat▼

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.