skills.rest
nhonvo
nhonvoCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

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
One-click install
npx skills add https://github.com/nhonvo/Powershell --skill database-expert-nhonvo
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
Veloxia-agencyVeloxia-agency

database-designer

Design and optimize database schemas, indexes, and migrations.

Community
Advanced
AribSudiaAribSudia
2

arib-postgres

Optimize PostgreSQL performance with indexing, query plan analysis, and lock-aware migrations.

Community
Advanced
djankiesdjankies

configuring-connection-pools

Configure Prisma Client connection pools for PostgreSQL deployments.

Community
Advanced
CenredJunCenredJun

postgresql-optimization

Analyze EXPLAIN ANALYZE output to optimize PostgreSQL queries and configuration.

Community
Advanced