database-expert

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

Updated Apr 9, 2024

Search Tags:#performance #database #postgresql #orm #mongodb #schema-design #query-analysis

Ready to run

npx skills add https://github.com/nhonvo/Powershell --skill database-expert-nhonvo

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-expert
Source: https://github.com/nhonvo/Powershell/tree/main/antigrafity-config/.agent/skills/database-expert
Command: npx skills add https://github.com/nhonvo/Powershell --skill database-expert-nhonvo

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Managing multiple database systems (PostgreSQL, MySQL, MongoDB, SQLite) and their ORM integrations is complex, error-prone, and often leads to performance bottlenecks and data integrity issues.

Core Features & Use Cases

Performance optimization: analyze queries, design effective indexes, and tune configuration across different engines.
Schema design & migrations: normalization strategies, safe migrations, and ORM-friendly schemas that scale.
Use Case: A software team running a poly-database stack uses this skill to unify performance tuning, schema decisions, and connection management.

Quick Start

Analyze your current workload and outline an optimization plan for the given databases and ORMs.

Frequently Asked Questions about database-expert

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

FAQPage Schema

How do I design a scalable database schema for ORM integration?▼

Schema design for ORM integration involves normalization strategies and ORM-friendly structures that scale. It ensures safe migrations with robust validation and rollback plans, maintaining data integrity across PostgreSQL, MySQL, MongoDB, and SQLite.

Why does my ORM integration cause data integrity issues during migrations?▼

ORM integration causes data integrity issues during migrations when schemas are not properly normalized. Applying robust validation, rollback plans, and continuous monitoring ensures safe schema changes and maintains integrity across PostgreSQL and MongoDB.

Can I analyze query performance across a poly-database stack?▼

You can analyze query performance across a poly-database stack by evaluating queries, indexes, and connections. This identifies cross-database performance bottlenecks and applies configuration tuning across PostgreSQL, MySQL, MongoDB, and SQLite.

What are the limitations of tuning database connections without query analysis?▼

Tuning database connections without query analysis often misses underlying performance bottlenecks. Analyzing queries and indexes is essential to apply scalable schema designs and effective configuration tuning across PostgreSQL and MongoDB.