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

Ready to run

npx skills add https://github.com/auxi-wardrobe/auxi-all-in --skill ck-databases-auxi-wardrobe

💬 Prompt for ChatGPT / Claude Chat▼

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.