design-data-layer

Design database architectures with connection pooling, migrations, and transaction management.

12|1|Updated Mar 23, 2026

Search Tags:#architecture #database design #transaction management #data layer #database selection

Ready to run

npx skills add https://github.com/wfukatsu/nexus-architect --skill design-data-layer

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: design-data-layer
Source: https://github.com/wfukatsu/nexus-architect/tree/main/skills/design-data-layer
Command: npx skills add https://github.com/wfukatsu/nexus-architect --skill design-data-layer

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill provides a structured approach to designing database architectures for projects not using ScalarDB, ensuring a robust, scalable, and efficient data layer.

Core Features & Use Cases

Database Selection: Offers guidance on choosing the right database system (RDB/NoSQL/hybrid) based on project requirements.
Connection Pool Design: Assists in designing a connection pool for efficient database connections.
Migration Strategy: Provides strategies for database migration and data integrity.
Transaction Management: Offers patterns for managing transactions to ensure data consistency.
ORM/DA Patterns: Recommends best practices for ORM (Object-Relational Mapping) and data access patterns.
Use Case: Ideal for system architects and developers who need to design a new data layer or refactor an existing one.

Quick Start

Run the /architect:design-data-layer command to begin the database design process.

Frequently Asked Questions about design-data-layer

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I design a robust database architecture for a new project?▼

Designing a robust database architecture involves selecting appropriate RDB or NoSQL systems, implementing connection pooling, defining migration strategies, and managing transactions to ensure a scalable data layer.

What's the best way to choose between RDB and NoSQL for my data layer?▼

Choosing between RDB and NoSQL requires evaluating project requirements such as data consistency, scalability, and structure. This Skill offers guidance on selecting the right database system, including hybrid approaches, based on those needs.

How do I manage database transactions to ensure data consistency?▼

Managing database transactions to ensure data consistency involves implementing specific transaction management patterns. This Skill provides recommended patterns to maintain robust data integrity across your non-ScalarDB projects.

Can I use this to design a connection pool for efficient database connections?▼

Yes, you can use this to design a connection pool. It assists in structuring efficient database connections and recommends best practices for Object-Relational Mapping and data access patterns.

What strategies should I use for database migration and data integrity?▼

Strategies for database migration and data integrity involve structured approaches to schema changes and data consistency. This Skill provides specific migration strategies to maintain a robust data layer during transitions.

Is this database architecture design approach suitable for refactoring an existing data layer?▼

Yes, this approach is suitable for refactoring an existing data layer. It is designed for system architects and developers who need to restructure database connections, migration strategies, and transaction management.