skills.rest
wfukatsu
wfukatsuCOMMUNITY
Explore all skills by this author →
GitHub

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
One-click install
npx skills add https://github.com/wfukatsu/nexus-architect --skill design-data-layer
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
HechaoYannetHechaoYannet

create-architecture

Generate a master architecture document from GDDs, ADRs, and governance constraints.

Community
Advanced
Globaly-IncGlobaly-Inc

gh-database-design

Design and optimize relational database schemas for high-scale SQL production environments.

Official
Advanced
CENKSSSCENKSSS

database-testing

Validate database schemas, data integrity, migrations, transactions, and query performance.

Community
Advanced
wfukatsuwfukatsu
8

design-scalardb

Design ScalarDB Cluster topology, storage mapping, and migration plans for microservices.

Community
Advanced