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

Database Management

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

About

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

0 GitHub stars
Unified support for MongoDB (BSON/Aggregation) and PostgreSQL (SQL/ACID)
Automated schema design and migration script generation for evolving applications
Performance optimization including index management and EXPLAIN query analysis
Operations management for replication, sharding, and robust backup strategies
Intelligent database selection guidance based on data consistency and scaling needs

Use Cases

Managing database migrations and schema changes with zero downtime or data loss
Optimizing slow-running complex queries and aggregation pipelines in production environments
Designing and implementing scalable data models for new microservices using SQL or NoSQL

About

Key Features

0 GitHub stars
Unified support for MongoDB (BSON/Aggregation) and PostgreSQL (SQL/ACID)
Automated schema design and migration script generation for evolving applications
Performance optimization including index management and EXPLAIN query analysis
Operations management for replication, sharding, and robust backup strategies
Intelligent database selection guidance based on data consistency and scaling needs

Use Cases

Managing database migrations and schema changes with zero downtime or data loss
Optimizing slow-running complex queries and aggregation pipelines in production environments
Designing and implementing scalable data models for new microservices using SQL or NoSQL