How do I customize foreign key names in Bknd?

By default, Bknd uses the target entity name (e.g., users_id), but you can use the 'mappedBy' option in your schema definition to specify a custom name like 'author_id'.

How do I load related data in a single query?

You can use the 'with' property in your data fetching logic (e.g., api.data.readMany('posts', { with: { users: true } })) to eager-load related records.

Does this skill support many-to-many relationships?

Yes, it provides patterns for many-to-many associations, including how to automatically generate junction tables or add extra fields like 'created_at' to the connection table.

Can I define relationships in the UI instead of code?

Yes, the skill includes a detailed UI approach for non-developers or quick prototyping using the Bknd local dashboard at localhost:1337.

What is the difference between relation() and .references()?

The relation() helper is more robust, supporting inverse navigation and many-to-many links, while .references() is a simpler shorthand for creating basic foreign keys on a number field.

Bknd Relationship Designer

Name: Bknd Relationship Designer
Author: cameronapak

bycameronapak

•

データベース管理

Defines and manages complex data relationships, foreign keys, and associations within the Bknd.io ecosystem.

This skill provides comprehensive guidance for modeling data associations in Bknd.io, covering everything from standard many-to-one links to complex many-to-many junction tables and self-referencing hierarchies. It streamlines the database design process by assisting developers in choosing between UI-based configuration and schema-as-code approaches, ensuring robust data integrity with features like custom field mapping, inverse navigation, and specialized query operators for related data.

主な機能

01Configurable foreign key naming using mappedBy and inversedBy options

02Automatic junction table generation with support for custom metadata fields

03Self-referencing relationship support for hierarchical data like categories or org charts

04Guidance on querying related data using 'with' and 'join' operators

05Support for Many-to-One, One-to-One, and Many-to-Many relationship types

061 GitHub stars

ユースケース

01Creating hierarchical category structures for e-commerce product catalogs

02Linking blog posts to authors and tags within a content management system

03Implementing many-to-many enrollments between users and courses with extra junction table data

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add cameronapak/bknd-skills bknd-define-relationship

For use in Claude.ai and ChatGPT

Download Skill