This gives you MongoDB and PostgreSQL coverage in one place, which is honestly pretty practical since most projects end up touching both at some point. It includes the usual CRUD operations, indexing strategies, and aggregation pipelines for Mongo, plus SQL queries, psql commands, and performance tuning for Postgres. The selection guide up front is helpful for choosing between document and relational models. It also throws in Python scripts for migrations, backups, and performance checks. The side-by-side examples make it easy to translate concepts between the two systems when you're context switching.

skills.sh installs
441
GitHub stars
2.2K
last updated
Aug 21, 2026

Install

$ npx -y skills add mrgoonie/claudekit-skills --skill databases --agent claude-code

Installs into .claude/skills of the current project.

Files

Databases Skill

Unified guide for working with MongoDB (document-oriented) and PostgreSQL (relational) databases. Choose the right database for your use case and master both systems.

When to Use This Skill

Use when:

  • Designing database schemas and data models
  • Writing queries (SQL or MongoDB query language)
  • Building aggregation pipelines or complex joins
  • Optimizing indexes and query performance
  • Implementing database migrations
  • Setting up replication, sharding, or clustering
  • Configuring backups and disaster recovery
  • Managing database users and permissions
  • Analyzing slow queries and performance issues
  • Administering production database deployments

Database Selection Guide

Choose MongoDB When:

  • Schema flexibility: frequent structure changes, heterogeneous data
  • Document-centric: natural JSON/BSON data model
  • Horizontal scaling: need to shard across multiple servers
  • High write throughput: IoT, logging, real-time analytics
  • Nested/hierarchical data: embedded documents preferred
  • Rapid prototyping: schema evolution without migrations

Best for: Content management, catalogs, IoT time series, real-time analytics, mobile apps, user profiles

Sponsors

Details

Repository
github.com/mrgoonie/claudekit-skills
Categories
Backend & APIs, Documentation, Debugging, Cloud & Infrastructure, CLI & Terminal, Databases
First seen
Jun 3, 2026

More from mrgoonie/claudekit-skills

All 28
1gocallum avatarclerk-nextjs-skillsgocallum/nextjs16-agent-skillsClerk authentication for Next.js 16 (App Router only) with proxy.ts setup, migration from middleware.ts, environment configuration, and MCP server integration.438skills.sh installs
2bobmatnyc avatarwordpress-plugin-fundamentalsbobmatnyc/claude-mpm-skillsModern WordPress plugin development with PHP 8.3+, OOP architecture, hooks system, database interactions, and Settings API434skills.sh installs
3depot avatardepot-generaldepot/skillsHandles Depot CLI installation, authentication, login, project setup, organization management, and API access. Use when installing the Depot CLI, logging in wit429skills.sh installs
4tigerfintech avatartigeropentigerfintech/tigeropen-skillTiger Brokers OpenAPI Python SDK — complete skills for AI coding tools. Covers SDK setup, market data queries, stock/futures/options trading, real-time push sub429skills.sh installs
5secondsky avatarsession-managementsecondsky/claude-skillsImplements secure session management with JWT tokens, Redis storage, refresh flows, and proper cookie configuration. Use when building authentication systems, m427skills.sh installs
6secondsky avataroauth-implementationsecondsky/claude-skillsOAuth 2.0 and OpenID Connect authentication with secure flows. Use for third-party integrations, SSO systems, token-based API access, or encountering authorizat422skills.sh installs