database-expert

Name: database-expert
Availability: InStock
Author: vanhpoker

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

Ready to run

npx skills add https://github.com/VanhPoker/VietNamLookmaxing --skill database-expert-vanhpoker

💬 Prompt for ChatGPT / Claude Chat▼

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.