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

ck:databases

Design, query, and optimize MongoDB and PostgreSQL databases.

1|1|Updated Jan 15, 2026
Search Tags:#performance#database design#query optimization#postgresql#mongodb
One-click install
npx skills add https://github.com/Thanh-apero/apero-kit-cli --skill ck-databases-thanh-apero
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: ck:databases
Source: https://github.com/Thanh-apero/apero-kit-cli/tree/main/.claude/skills/databases
Command: npx skills add https://github.com/Thanh-apero/apero-kit-cli --skill ck-databases-thanh-apero

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill unit empowers users to design, query, and optimize MongoDB and PostgreSQL databases efficiently, solving the challenge of managing complex data structures and performance issues.

Core Features & Use Cases

  • Database Design: Provides guidelines for schema design, normalization, and indexing for both MongoDB and PostgreSQL.
  • Query Writing: Offers references for MongoDB CRUD operations, aggregation pipeline, and PostgreSQL queries, including JOINs and subqueries.
  • Performance Optimization: Includes best practices for indexing, query optimization, and database maintenance.
  • Use Case: Imagine you need to optimize a complex PostgreSQL query for performance. Use this Skill to review and adjust your query for better performance.

Quick Start

To begin, run the db-design skill to design your database schema.

Frequently Asked Questions about ck:databases

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

FAQPage Schema
How do I optimize a slow PostgreSQL query?▼

Optimize a slow PostgreSQL query by reviewing indexing strategies and query structure. This Skill provides best practices for query optimization, including JOINs and subqueries, to improve database performance.

What's the best way to design a schema for MongoDB?▼

Design a MongoDB schema using guidelines for normalization and indexing. This Skill provides comprehensive references for document-oriented database design and CRUD operations.

How do I use the MongoDB aggregation pipeline?▼

Use the MongoDB aggregation pipeline by following the query writing references in this Skill. It provides detailed examples for CRUD operations and complex data aggregations.

Does this database optimization Skill require specific dependencies?▼

Yes, the database optimization Skill requires pymongo and psycopg2 dependencies to connect and interact with MongoDB and PostgreSQL databases.

Can I manage indexing and performance for both PostgreSQL and MongoDB here?▼

Yes, you can manage indexing and performance for both PostgreSQL and MongoDB. This Skill offers best practices for schema design and database maintenance across both relational and document-oriented databases.

Related Skills

Explore More Software Engineering Skills→
VuNguyenVietTienVuNguyenVietTien

databases

Design database schemas, optimize queries, and plan migrations for MongoDB and PostgreSQL.

Community
Intermediate
Khoatran1999Khoatran1999

databases

Design schemas, optimize queries, and manage maintenance for MongoDB and PostgreSQL.

Community
Advanced
snake-dev-teamsnake-dev-team

ck:databases

Designs schemas and writes queries for MongoDB and PostgreSQL databases.

Official
Advanced
voidrotvoidrot

postgres-patterns

Analyze and optimize PostgreSQL queries using EXPLAIN ANALYZE and indexing strategies.

Community
Advanced