skills.rest
VanhPoker
VanhPokerCOMMUNITY
Explore all skills by this author →
GitHub

database-expert

Optimize database performance, schema design, and queries across PostgreSQL, MySQL, MongoDB, and SQLite.

Updated Jan 17, 2026
Search Tags:#performance#database#postgresql#optimization#orm#mongodb#schema-design
One-click install
npx skills add https://github.com/VanhPoker/VietNamLookmaxing --skill database-expert-vanhpoker
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-expert
Source: https://github.com/VanhPoker/VietNamLookmaxing/tree/main/.agent/skills/database-expert
Command: npx skills add https://github.com/VanhPoker/VietNamLookmaxing --skill database-expert-vanhpoker

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Optimizes database performance, schema design, query analysis, and connection management across PostgreSQL, MySQL, MongoDB, and SQLite, enabling teams to deliver faster, more reliable data-driven apps.

Core Features & Use Cases

  • Performance profiling and tuning across relational and NoSQL engines
  • Schema design, normalization patterns, and migration guidance
  • Query analysis, indexing strategies, and ORM integration
  • Cross-DB consistency checks and safe deployment practices

Quick Start

Profile the application's database workload and implement targeted optimizations based on the findings.

Frequently Asked Questions about database-expert

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

FAQPage Schema
How do I optimize PostgreSQL query performance and indexing strategies?▼

Optimize PostgreSQL query performance by profiling database workloads, analyzing query execution plans, and implementing targeted indexing strategies to resolve bottlenecks. This approach ensures faster data retrieval and improved application reliability across production systems.

What is the best way to design database schemas and ensure safe migrations?▼

Database schema design involves applying normalization patterns and executing safe migration practices with validation checks. This prevents data loss and maintains cross-database consistency across PostgreSQL, MySQL, MongoDB, and SQLite during deployment.

Does this database optimization approach work with MongoDB and ORM integration?▼

Yes, database optimization supports MongoDB performance tuning and ORM integration guidance. It applies cross-database consistency checks and optimization patterns across both relational and NoSQL engines to ensure reliable data-driven applications.

How do I manage database connections and improve reliability in production systems?▼

Database connection management improves production reliability by profiling application workloads and implementing targeted optimizations. This process identifies connection bottlenecks and applies cross-database consistency checks to prevent data loss.

Why does my database query analysis show slow performance across different engines?▼

Slow database query performance often stems from unoptimized schemas or missing indexing strategies. Query analysis identifies these bottlenecks across PostgreSQL, MySQL, MongoDB, and SQLite, enabling targeted tuning and normalization pattern adjustments.

Related Skills

Explore More Software Engineering Skills→
TheBushidoCollectiveTheBushidoCollective
187

performance-optimization

Profile bottlenecks and apply validated optimizations with repeatable metrics.

Official
Advanced
JeremyDev87JeremyDev87
31

database-migration

Plan and execute database migrations with a six-phase rollback-backed workflow.

Community
Advanced
mahamaneharouna9-cpumahamaneharouna9-cpu

database-expert

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

Community
Advanced
Thanh-aperoThanh-apero
1

databases

Guide MongoDB and PostgreSQL schema design, query optimization, and performance tuning.

Community
Advanced