database-development

Standardize database layers with entities, migrations, repositories, and Kysely types.

Updated Aug 27, 2026
One-click install
npx skills add https://github.com/lyraarteltda/MEGA-BRAIN-JARVIS-v2 --skill database-development-lyraarteltda
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: database-development
Source: https://github.com/lyraarteltda/MEGA-BRAIN-JARVIS-v2/tree/main/.fnd/skills/database-development
Command: npx skills add https://github.com/lyraarteltda/MEGA-BRAIN-JARVIS-v2 --skill database-development-lyraarteltda

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill streamlines the creation and maintenance of the database layer within the project, ensuring consistency and adherence to established patterns for entities, migrations, repositories, and type definitions.

Core Features & Use Cases

  • Entity Definition: Define data models as interfaces for type safety.
  • Database Migrations: Manage schema changes with versioned SQL scripts.
  • Repository Pattern: Implement data access logic with clear interfaces and concrete implementations.
  • Type Safety: Generate Kysely types for robust database interactions.
  • JSONB Handling: Efficiently manage JSONB data types in PostgreSQL.

Quick Start

Use the database-development skill to create a new entity interface for a 'Product' and its corresponding repository implementation.

Frequently Asked Questions about database-development

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

FAQPage Schema
How do I create a new entity interface and repository implementation for a database model?

Creating a new entity interface and repository implementation involves defining the data model as a TypeScript interface and generating the corresponding concrete repository class with clear data access logic.

How do I standardize a TypeScript database layer with Kysely and the repository pattern?

To standardize a TypeScript database layer with Kysely, this Skill generates entities, migrations, repositories, and type definitions following project-specific patterns to ensure consistent data access implementation.

How do I enforce multi-tenancy in database queries using account_id filtering?

Enforcing multi-tenancy in database queries is achieved by mandating account_id filtering across all repository implementations, ensuring every database interaction remains securely scoped to the correct tenant.

What is the best way to manage PostgreSQL JSONB data and date handling in TypeScript migrations?

Managing PostgreSQL JSONB data and date handling in TypeScript migrations is standardized through specific guidelines that define how JSONB fields are structured and how date values are processed consistently.

Does this database development skill support generating Kysely types for type-safe queries?

Yes, this database development skill supports generating Kysely types, providing robust type safety for database interactions by defining data models as TypeScript interfaces and enforcing strict schema definitions.

How do I create a new entity interface and repository implementation for a database model?

Creating a new entity interface and repository implementation involves defining the data model as a TypeScript interface and generating the corresponding concrete repository class with clear data access logic.