What is the difference between 'with' and 'join' in this skill?

The 'with' clause performs separate queries to load related data as nested objects, whereas 'join' uses a single SQL JOIN to allow filtering or sorting by related fields.

Does this skill support pagination for large datasets?

Yes, it provides standard limit and offset patterns, along with a reusable pagination helper function to manage total counts and page calculations.

How does the skill handle complex filtering?

It supports a wide range of operators including equality, numeric comparisons ($gt, $lt), string matching ($like, $ilike), and logical grouping ($or, $and).

Can I use this skill with React applications?

Absolutely. The skill includes specific integration patterns for standard React state, SWR for data fetching, and debounced search implementation.

Bknd CRUD Read & Querying

Name: Bknd CRUD Read & Querying
Author: cameronapak

bycameronapak

•

Database Management

Retrieves and queries data from Bknd database entities using the SDK or REST API with advanced filtering and relation support.

About

This skill empowers developers to perform complex data retrieval operations within a Bknd project environment. It provides comprehensive patterns for querying single or multiple records, applying sophisticated filters using logical, numeric, and string operators, and managing efficient pagination. By standardizing how Claude handles relational data through 'with' and 'join' clauses, the skill ensures performant data fetching for applications, ranging from simple record lookups to complex, nested data requirements in React frontends.

Key Features

1 GitHub stars
Built-in pagination and sorting mechanisms for large datasets
Comprehensive query methods including readOne, readMany, and readOneBy
Optimized field selection to reduce payload size and improve API performance
Advanced filtering with comparison, string, array, and logical operators
Relational data management using nested 'with' loading and SQL-style 'join' clauses

Use Cases

Developing detail pages that require loading complex, nested relational data
Building dynamic, data-driven dashboards and tables in React applications
Implementing advanced search and filter functionality for backend integrations

About

Key Features

1 GitHub stars
Built-in pagination and sorting mechanisms for large datasets
Comprehensive query methods including readOne, readMany, and readOneBy
Optimized field selection to reduce payload size and improve API performance
Advanced filtering with comparison, string, array, and logical operators
Relational data management using nested 'with' loading and SQL-style 'join' clauses

Use Cases

Developing detail pages that require loading complex, nested relational data
Building dynamic, data-driven dashboards and tables in React applications
Implementing advanced search and filter functionality for backend integrations