Does this skill support both SQL and NoSQL databases?

Yes, it provides comprehensive, unified support for PostgreSQL (relational SQL) and MongoDB (document-oriented NoSQL).

Is this skill compatible with cloud-based databases?

Yes, it includes specific guidance for MongoDB Atlas, PostgreSQL cloud instances, and general managed database configurations.

Can it help with database performance tuning?

Absolutely. It includes tools for index optimization, query analysis using EXPLAIN/ANALYZE, and identifying production bottlenecks.

How does it assist with database migrations?

The skill provides automated script generation and best practices for performing migrations while maintaining referential integrity and data consistency.

Database Architect & Manager

Name: Database Architect & Manager
Author: nordeim

bynordeim

0•

Database Management

Streamlines the design, management, and optimization of MongoDB and PostgreSQL databases through schema modeling, complex querying, and performance tuning.

The Databases skill provides a comprehensive toolkit for handling both document-oriented (MongoDB) and relational (PostgreSQL) data systems within Claude Code. It assists developers in selecting the appropriate database architecture, writing optimized SQL or MQL queries, building sophisticated aggregation pipelines, and managing production-level tasks like migrations, backups, and sharding. Whether you are building a rapid prototype with flexible schemas or a strictly consistent financial system, this skill offers the domain-specific guidance and best practices needed to maintain high-performance, scalable data layers.

Key Features

010 GitHub stars

02Unified support for MongoDB (BSON/Aggregation) and PostgreSQL (SQL/ACID)

03Automated schema design and migration script generation for evolving applications

04Performance optimization including index management and EXPLAIN query analysis

05Operations management for replication, sharding, and robust backup strategies

06Intelligent database selection guidance based on data consistency and scaling needs

Use Cases

01Managing database migrations and schema changes with zero downtime or data loss

02Optimizing slow-running complex queries and aggregation pipelines in production environments

03Designing and implementing scalable data models for new microservices using SQL or NoSQL

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add nordeim/prompt-engineering databases

For use in Claude.ai and ChatGPT

Download Skill