db

Identify database stacks and enforce domain constraints for backend projects.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/mrsknetwork/nemodev --skill db-mrsknetwork
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: db
Source: https://github.com/mrsknetwork/nemodev/tree/main/skills/domains/references/db
Command: npx skills add https://github.com/mrsknetwork/nemodev --skill db-mrsknetwork

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

The Database Domain Expert helps software teams select robust database stacks, enforce domain-specific constraints, and plan safe migrations to keep production data safe and accessible.

Core Features & Use Cases

  • Phase-driven guidance for stack selection, ORM delegation, and migration protocols across Python (SQLAlchemy 2.0) and Node.js (Prisma) ecosystems.
  • Ecosystem-aware hard constraints, including UUID primary keys, guarded operations, and migration-ready schemas.
  • N+1 query prevention and performance best practices, with explicit guidance on loading strategies and indexing.

Quick Start

Provide a database-domain plan for a new project, including stack choice, ORM usage, and migrations guidelines.

Frequently Asked Questions about db

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

FAQPage Schema
How do I plan safe database migrations for a production backend?

To plan safe database migrations, you must identify domain constraints and apply guardrails for data integrity. This involves mapping your backend ecosystem, enforcing constraints like UUID primary keys, and establishing a migration-ready schema protocol.

What is the best way to choose an ORM for Node.js or Python backend projects?

Choosing an ORM requires ecosystem mapping: Node.js or TypeScript projects map to Prisma, while Python projects map to SQLAlchemy 2.0. This ORM delegation ensures your schema design aligns with your backend stack for optimal performance and data integrity.

How do I prevent N+1 query issues when using Prisma or SQLAlchemy?

To prevent N+1 query issues in Prisma or SQLAlchemy, apply explicit loading strategies and indexing best practices. Performance guidance dictates how you structure relationships and queries to avoid unnecessary database calls during data retrieval.

Does this database migration approach work with both TypeScript and Python stacks?

Yes, this database migration approach works with both stacks through ecosystem-aware constraints. It provides phase-driven guidance specifically tailored for Node.js and TypeScript using Prisma, and Python using SQLAlchemy 2.0.

What constraints should I enforce to maintain data integrity during ORM schema migrations?

To maintain data integrity during ORM schema migrations, enforce hard constraints such as UUID primary keys and guarded operations. These rules ensure migrations remain safe and production data stays accessible without corruption or loss.