skills.rest
Thanh-apero
Thanh-aperoCOMMUNITY
Explore all skills by this author →
GitHub

databases

Guide MongoDB and PostgreSQL schema design, query optimization, and performance tuning.

1|1|Updated Jan 15, 2026
Search Tags:#database design#SQL#PostgreSQL#MongoDB#schema creation
One-click install
npx skills add https://github.com/Thanh-apero/apero-kit-cli --skill databases-thanh-apero
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databases
Source: https://github.com/Thanh-apero/apero-kit-cli/tree/main/templates/skills/databases
Command: npx skills add https://github.com/Thanh-apero/apero-kit-cli --skill databases-thanh-apero

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pymongo, psycopg2, dbmigrate, dbbackup, dbperformancecheck, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill addresses the challenges of database design, schema creation, and management for MongoDB and PostgreSQL. It provides a unified guide for database operations, ensuring efficient data storage, retrieval, and maintenance.

Core Features & Use Cases

  • Database Design: Offers guidelines for designing schemas that adhere to best practices for both relational (PostgreSQL) and NoSQL (MongoDB) databases.
  • Schema Creation: Provides a framework for creating and extending database schemas with proper normalization and indexing.
  • Querying: Walks through the process of writing efficient SQL and MongoDB queries, including JOINs, subqueries, and aggregation.
  • Performance Optimization: Offers strategies for optimizing indexes and query performance, including slow query analysis and optimization techniques.
  • Use Case: Imagine you need to design a new schema for a customer relationship management (CRM) system. This Skill will guide you through the process, including schema design, indexing strategies, and performance optimization.

Quick Start

Generate a MongoDB schema for a simple e-commerce site by running the script in the scripts/ directory.

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 a CRM using PostgreSQL and MongoDB?▼

To design a CRM database schema, you need structured guidelines for normalization, indexing strategies, and performance optimization. This Skill helps you create schemas for both PostgreSQL relational models and MongoDB document structures efficiently.

What's the best way to optimize slow SQL and MongoDB queries?▼

Optimizing slow SQL and MongoDB queries requires index tuning and execution plan analysis. This Skill provides performance optimization strategies, including slow query analysis and indexing techniques to resolve database bottlenecks.

Do I need SQL and MongoDB query language experience to use this database management Skill?▼

Yes, SQL and MongoDB query language experience is required. This Skill focuses on database administration and performance monitoring, requiring prerequisite knowledge of writing efficient queries, JOINs, subqueries, and aggregation frameworks.

How does schema creation differ between PostgreSQL and MongoDB?▼

PostgreSQL schema creation focuses on relational normalization and strict structure, while MongoDB schema design optimizes document-oriented data storage. This Skill guides you through creating and extending schemas with proper indexing for both database types.

Can I generate a MongoDB schema for an e-commerce site using this Skill?▼

Yes, you can generate a MongoDB schema for an e-commerce site. The Skill includes scripts in its scripts directory that walk you through schema creation and indexing strategies for specific application use cases.

Related Skills

Explore More Software Engineering Skills→
hongbietcodehongbietcode
3

databases

Design, query, migrate, backup, and administer MongoDB and PostgreSQL databases.

Community
Advanced
DengNaichenDengNaichen
34

axiom-data

Manage data persistence, schema migrations, and serialization across SwiftData, Core Data, and GRDB.

Community
Advanced
tankpkgtankpkg
1

@tank/relational-db-mastery

Optimize PostgreSQL and MySQL query performance with indexing and tuning strategies.

Official
Advanced
ps-carvalhops-carvalho

database-design

Generate normalized database schemas with indexing and migration strategies.

Community
Advanced