Design and optimize MongoDB and PostgreSQL schemas and queries.
npx skills add https://github.com/mafvietnam/mafapp --skill ck-databases-mafvietnam
Please help me install this Agent Skill. Skill: ck:databases Source: https://github.com/mafvietnam/mafapp/tree/main/.claude/skills/databases Command: npx skills add https://github.com/mafvietnam/mafapp --skill ck-databases-mafvietnam
This Skill helps engineers and data teams design robust database schemas and write efficient queries for both MongoDB (NoSQL) and PostgreSQL (SQL), reducing design ambiguity and speeding up implementation.
Describe your data domain and I will generate a starter schema and example queries for both MongoDB and PostgreSQL.
High-intent search queries and answers about installing and using this skill.
To design database schemas for MongoDB and PostgreSQL, you define your data domain to generate starter schemas, applying modeling best practices for transactional and analytical workloads. This ensures reliable, scalable data models across both SQL and NoSQL environments.
The best way to optimize slow MongoDB and PostgreSQL queries is to apply targeted index selection strategies and query performance tuning. You can analyze SQL and NoSQL querying patterns, including aggregations and joins, to resolve bottlenecks.
You write MongoDB aggregation pipelines for analytical workloads by applying NoSQL querying patterns and best practices provided for performance tuning. The Skill offers guidance on constructing these pipelines alongside SQL aggregations for OLAP use cases.
Yes, you get migration guidance for scaling PostgreSQL and MongoDB data models. The Skill covers migration patterns and replication strategies, providing real-world examples to ensure reliable schema transitions and scalable data modeling.
You choose between PostgreSQL indexes and MongoDB index strategies based on your specific OLTP or OLAP workload requirements. The Skill provides index selection guidance and querying patterns to determine the optimal approach for each database system.
Yes, you need to provide your data domain so the Skill can generate a starter schema and example queries for both MongoDB and PostgreSQL. This input drives the tailored schema design, SQL and NoSQL querying patterns, and index recommendations.
majiayu000Design PostgreSQL data models and Redis caching strategies.
melikhanmutluDesign database schemas with normalization, indexing, and migration planning.
nicholasgriffintnIdentify and fix performance bottlenecks across frontend, backend, and database layers.
thepradipOptimize SQL queries and schemas across PostgreSQL, MySQL, and SQLite.
