skills.rest
martiirivass
martiirivassCOMMUNITY
Explore all skills by this author →
GitHub

database-expert

Guide PostgreSQL, MongoDB, and Redis schema creation and query optimization.

Updated Apr 29, 2026
Search Tags:#performance#query optimization#schema design#database#PostgreSQL#administration
One-click install
npx skills add https://github.com/martiirivass/parcialGestionRobledo --skill database-expert-martiirivass
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-expert
Source: https://github.com/martiirivass/parcialGestionRobledo/tree/main/.agents/skills/database-expert
Command: npx skills add https://github.com/martiirivass/parcialGestionRobledo --skill database-expert-martiirivass

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill enables users to understand and implement advanced database schemas, query optimization techniques, and management practices, facilitating efficient data handling.

Core Features & Use Cases

  • Database Schema Design: Guides the creation of relational and NoSQL databases with constraints and indexes. For example, designing a scalable user management system with proper constraints.
  • Query Optimization: Provides strategies for analyzing and enhancing query performance, such as indexing and explain analysis for slow queries.
  • Administration and Maintenance: Covers best practices in managing database health, including VACUUM, ANALYZE, and index management, applicable in production environments.

Quick Start

Use this Skill to design a normalized PostgreSQL schema for e-commerce data and optimize the slow query to retrieve top-selling products efficiently.

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 PostgreSQL queries for an e-commerce database?▼

To optimize slow PostgreSQL queries, you apply indexing strategies and execute explain analysis to evaluate query plans. This process identifies performance bottlenecks and enhances data retrieval efficiency for high-volume e-commerce systems.

What is the best way to design a scalable database schema for enterprise applications?▼

Designing a scalable database schema involves creating normalized structures with proper constraints and indexes. This approach ensures efficient data handling and maintainable architectures suitable for enterprise-level relational and NoSQL environments.

How does VACUUM and ANALYZE administration work in PostgreSQL?▼

VACUUM and ANALYZE administration works by reclaiming storage and updating statistics for the query planner. Running these commands maintains database health and ensures accurate execution plans in production environments.

Can I use the same database design principles for PostgreSQL, MongoDB, and Redis?▼

You can apply foundational database design principles across PostgreSQL, MongoDB, and Redis, but implementation differs. Guidelines cover schema creation and system management tailored to the specific constraints of relational and NoSQL data architectures.

Why does query performance degrade without proper index management?▼

Query performance degrades without proper index management because the database executes full table scans instead of targeted lookups. Implementing VACUUM, ANALYZE, and strategic indexing prevents this degradation and maintains system health.

Related Skills

Explore More Data & Analytics Skills→
CoriatelCoriatel

Hostinger VPS Operations

Harden and maintain Hostinger VPS instances via SSH and package management.

Community
Intermediate
coreymaypraycoreymaypray
1

data-engineer

Turn raw Supabase application events into query-optimized analytics with materialized views.

Community
Advanced
gemini-cli-extensionsgemini-cli-extensions
42

cloud-sql-postgres-health

Audit Cloud SQL for PostgreSQL instance health and performance bottlenecks.

Official
Intermediate
HouseGarofaloHouseGarofalo
3

database-architect-agent

Guide database architecture, data modeling, schema optimization, and query performance tuning.

Official
Advanced