skills.rest
lengo0951
lengo0951COMMUNITY
Explore all skills by this author →
𝕏@quocngo04GitHub

ck:databases

Design schemas and write optimized queries for MongoDB and PostgreSQL.

Updated Apr 18, 2026
Search Tags:#schema design#database#postgresql#mongodb#query writing
One-click install
npx skills add https://github.com/lengo0951/pms --skill ck-databases-lengo0951
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: ck:databases
Source: https://github.com/lengo0951/pms/tree/main/.claude/skills/databases
Command: npx skills add https://github.com/lengo0951/pms --skill ck-databases-lengo0951

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines the creation and management of databases, enabling efficient query writing, optimization, and troubleshooting.

Core Features & Use Cases

  • Database Schema Design: Assist with creating optimized database schemas for OLTP and OLAP use cases.
  • Query Writing: Support for MongoDB and PostgreSQL query writing, including aggregation pipelines and complex joins.
  • Performance Optimization: Index management, performance analysis, and optimization recommendations.
  • Use Case: For instance, a developer could use this skill to optimize a database schema for an e-commerce application, design a MongoDB aggregation pipeline for inventory tracking, or troubleshoot slow PostgreSQL queries.

Quick Start

Use the databases skill to create a new schema for a new project named 'ecommerce_db'.

Frequently Asked Questions about ck:databases

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

FAQPage Schema
How do I design a database schema for an e-commerce application?▼

To design a database schema for an e-commerce application, you need optimized structures for OLTP and OLAP use cases. This skill provides guidelines for creating efficient schemas, ensuring reliability for transactional and analytical workloads.

How do I write a MongoDB aggregation pipeline for inventory tracking?▼

Writing a MongoDB aggregation pipeline for inventory tracking involves multi-stage data processing commands. This skill supports MongoDB query writing by providing structural guidelines for building aggregation pipelines to process and analyze inventory data efficiently.

What is the best way to troubleshoot slow PostgreSQL queries?▼

Troubleshooting slow PostgreSQL queries requires performance analysis and index management. This skill provides optimization recommendations to identify bottlenecks and improve query execution speed for complex joins.

Do I need to know both PostgreSQL and MongoDB query languages to use this for database migrations?▼

Yes, database migrations require familiarity with both database types and their respective query languages. This skill optimizes schema design and query performance but expects prerequisite knowledge of PostgreSQL and MongoDB.

Can I use psycopg2 and pymongo for complex joins and performance optimization?▼

Yes, using psycopg2 and pymongo facilitates complex joins and performance optimization. This skill leverages these dependencies to support query writing, index creation, and performance tuning for both PostgreSQL and MongoDB databases.

Related Skills

Explore More Software Engineering Skills→
hongbietcodehongbietcode
3

databases

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

Community
Advanced
sigmadigitalzasigmadigitalza
1

database-review

Review database schemas, migration files, and query performance.

Official
Advanced
karchthokarchtho

database-integration

Standardize PostgreSQL and MongoDB integration with connection pooling and parameterized queries.

Community
Advanced
jabrenajabrena
423

705-technologies-nosql-mongodb

Optimize MongoDB queries and design NoSQL schemas with JSON Schema validation.

Community
Advanced