skills.rest
docaohieu2808
docaohieu2808COMMUNITY
Explore all skills by this author →
WebsiteGitHub

databases

Design schemas, write queries, and optimize MongoDB and PostgreSQL databases.

1|Updated Mar 9, 2026
Search Tags:#query optimization#schema design#database#postgresql#sql#nosql#mongodb
One-click install
npx skills add https://github.com/docaohieu2808/claude-skills --skill databases-docaohieu2808
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databases
Source: https://github.com/docaohieu2808/claude-skills/tree/main/databases
Command: npx skills add https://github.com/docaohieu2808/claude-skills --skill databases-docaohieu2808

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines database management by providing unified guidance for designing schemas, writing queries, and optimizing performance across both MongoDB and PostgreSQL.

Core Features & Use Cases

  • Schema Design: Create optimal schemas for both relational (PostgreSQL) and document (MongoDB) databases.
  • Querying: Write efficient SQL and MongoDB queries, including aggregation pipelines.
  • Optimization: Improve performance with index recommendations and query analysis.
  • Use Case: Design a PostgreSQL schema for an e-commerce order system, then write a MongoDB aggregation pipeline to analyze user behavior from event logs.

Quick Start

Use the databases skill to design a PostgreSQL schema for a blog application.

Frequently Asked Questions about databases

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

FAQPage Schema
How do I design a database schema for both transactional and analytical workloads?▼

Database schema design for transactional (OLTP) and analytical (OLAP) workloads requires structuring relational or document models appropriately, including star schemas for analytics to ensure optimal query performance and data integrity.

What is the best way to write a MongoDB aggregation pipeline to analyze event logs?▼

Writing a MongoDB aggregation pipeline to analyze event logs involves constructing sequential stages to filter, group, and transform document data, enabling efficient behavioral analytics and complex NoSQL query processing.

How do I optimize slow PostgreSQL queries and get index recommendations?▼

PostgreSQL query optimization analyzes slow queries to identify performance bottlenecks, providing targeted index recommendations and execution plan insights to improve SQL retrieval speed and overall database efficiency.

Can I use Python utilities for database migrations and backups with PostgreSQL and MongoDB?▼

Python utilities for database migrations and backups support PostgreSQL and MongoDB environments, enabling scripted schema transitions and automated data safeguarding for relational and document databases.

When should I choose a document database schema over a relational schema?▼

Choosing a document database schema over a relational schema depends on workload requirements: document models suit flexible, hierarchical NoSQL data, while relational models enforce strict ACID compliance for structured SQL data.

Related Skills

Explore More Software Engineering Skills→
andrew-starosciakandrew-starosciak
2

postgres-patterns

Provide PostgreSQL patterns for query optimization, schema design, indexing, and security.

Community
Intermediate
quanganh208quanganh208

ck:databases

Design schemas and write optimized queries for MongoDB and PostgreSQL.

Community
Advanced
OneWave-AIOneWave-AI
245

database-schema-designer

Design optimized SQL and NoSQL database schemas with ERDs and migration scripts.

Official
Basic
HouseGarofaloHouseGarofalo
3

database-architect-agent

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

Official
Advanced