Design database schemas and queries for MongoDB and PostgreSQL.
npx skills add https://github.com/jangtrinh/demo-Lam --skill ck-databases-jangtrinh
Please help me install this Agent Skill. Skill: ck:databases Source: https://github.com/jangtrinh/demo-Lam/tree/main/.claude/skills/databases Command: npx skills add https://github.com/jangtrinh/demo-Lam --skill ck-databases-jangtrinh
This Skill reduces the time and guesswork of designing database schemas and writing correct queries across MongoDB and PostgreSQL by providing a structured workflow, naming conventions, and domain-specific reference material.
Use the ck:databases skill to design a transactional schema for an app, by asking: "Design the database schema for a 'blog' app with users, posts, and comments, including indexes and migrations strategy for PostgreSQL and MongoDB."
High-intent search queries and answers about installing and using this skill.
To design database schemas across PostgreSQL and MongoDB, you must follow a strict requirements-gathering flow that produces maintainable table structures with consistent naming, keys, and index strategies for OLTP and OLAP models.
Writing safe SQL queries with complex joins, CTEs, and window functions requires proposing query logic with clear reasoning and including safety guardrails like pausing before execution to ensure correctness and optimal performance.
Building a MongoDB aggregation pipeline requires selecting appropriate indexes and constraints for your access patterns, proposing pipeline logic with reasoning, and applying safety guardrails before execution to ensure performance and correctness.
Yes, incremental ETL design supports watermarks and job logs to manage data extraction efficiently. It addresses operational readiness including performance tuning, backups, and replication for your database administration needs.
Yes, database schema design applies to both OLTP and OLAP modeling. It ensures correctness and performance by tailoring table structures, constraints, and indexes to your specific transactional or analytical access patterns.
Nickalus12Identify performance hotspots and regressions in Loom-style codebases.
quanganh208Design schemas and write optimized queries for MongoDB and PostgreSQL.
nateaAutomate database validation for schemas, constraints, migrations, and performance.
vix-4800Review database schemas, migrations, and ORM query strategies for safe data evolution.
