skills.rest
auxi-wardrobe
auxi-wardrobeOFFICIAL
Explore all skills by this author →
GitHub

ck:databases

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

1|Updated May 4, 2026
Search Tags:#query optimization#schema design#database#postgresql#sql#mongodb
One-click install
npx skills add https://github.com/auxi-wardrobe/auxi-all-in --skill ck-databases-auxi-wardrobe
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: ck:databases
Source: https://github.com/auxi-wardrobe/auxi-all-in/tree/main/.agents/skills/databases
Command: npx skills add https://github.com/auxi-wardrobe/auxi-all-in --skill ck-databases-auxi-wardrobe

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill Unit provides comprehensive guidance and tools for designing, querying, and managing MongoDB and PostgreSQL databases, simplifying complex database operations and optimizing performance.

Core Features & Use Cases

  • Database Design: Offers best practices for database schema design, normalization, and indexing.
  • Query Writing: Provides resources for crafting SQL and NoSQL queries, including aggregation pipelines.
  • Performance Optimization: Delivers insights into query performance, indexing strategies, and system maintenance.
  • Use Case: Help a team member design a star schema for analytics or optimize their MongoDB queries for faster performance.

Quick Start

Use the 'ck:databases' skill to optimize your MongoDB query performance.

Frequently Asked Questions about ck:databases

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

FAQPage Schema
How do I optimize slow MongoDB queries and improve aggregation pipeline performance?▼

To optimize MongoDB query performance, you need effective indexing strategies and schema design. This Skill provides guides for query writing and performance tuning to accelerate your MongoDB aggregation pipelines and database operations.

What is the best way to design a PostgreSQL schema for analytics?▼

Designing a PostgreSQL schema for analytics requires proper normalization and indexing. This Skill offers best practices for database design, helping you build efficient star schemas and optimize your relational database structure.

Do I need Python scripting knowledge to use database design and optimization guides?▼

Yes, basic scripting abilities are required because this Skill uses Python dependencies like pymongo and psycopg2. These scripts facilitate database operations, schema optimization, and performance tuning for both PostgreSQL and MongoDB.

How does query performance tuning work for complex SQL and NoSQL databases?▼

Query performance tuning works by analyzing execution plans and applying indexing strategies. This Skill delivers insights into query performance optimization, helping you write efficient SQL and NoSQL queries while maintaining your database system.

Can I use pandas with psycopg2 and pymongo for database performance optimization?▼

Yes, this Skill integrates pandas with psycopg2 and pymongo to support database operations. You can use these dependencies to analyze query results, optimize schema design, and tune performance for PostgreSQL and MongoDB environments.

Related Skills

Explore More Software Engineering Skills→
VuNguyenVietTienVuNguyenVietTien

databases

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

Community
Intermediate
weirdgmeweirdgme
4

platform-engineering

Design and implement scalable platform engineering patterns for internal developer platforms.

Community
Advanced
rodmena-limitedrodmena-limited
3

moai-domain-database

Provide database schema design, query optimization, and indexing strategies.

Official
Advanced
kevinnguyen271090kevinnguyen271090
15

databases

Design and optimize MongoDB and PostgreSQL databases for schema, queries, and performance.

Community
Intermediate