What is the recommended migration strategy?

The skill advocates for direct SQL migrations stored in version control rather than ORM-style migrations to maintain full control over the database schema.

Does this skill support other databases besides MySQL?

While Nette Database supports multiple backends, this specific skill is optimized for MySQL 8.4+ conventions and specific encodings like utf8mb4_0900_ai_ci.

How does it handle entity naming?

It follows a snake_case to PascalCase conversion with a mandatory 'Row' suffix, such as mapping the 'order_item' table to the 'OrderItemRow' entity.

How does it manage database relationships?

It utilizes Nette's colon notation for efficient deep joins and provides documentation patterns for both forward and reverse relationships in phpDoc.

Can I use raw SQL with this skill?

Yes, the skill provides specific guidance on when to use the Selection API versus raw SQL, specifically recommending raw SQL for complex analytics, recursive queries, and performance-critical operations.

Nette Database & Explorer

Name: Nette Database & Explorer
Author: nette

bynette

•

Gestión de Bases de Datos

Optimizes Claude's ability to write Nette Database queries, design typed entities, and manage schemas using MySQL 8.4+.

Acerca de

The Nette Database skill empowers Claude to architect and implement robust database layers following Nette's best practices. It provides structured guidance on using the Explorer API for zero-configuration entity mapping, designing flat entity structures with the 'Row' suffix, and utilizing the Selection API for efficient query building. Whether you are navigating complex relationships with colon notation or implementing raw SQL for performance-critical analytics, this skill ensures your database interactions are type-safe, maintainable, and idiomatic to the Nette ecosystem.

Características Principales

Optimized query building using Nette Selection API and colon notation for joins
Decision logic for choosing between Explorer API and raw SQL for complex analytics
Automated entity mapping and ActiveRow documentation patterns for IDE support
Schema management strategies using direct SQL migrations and database constraints
Standardized database conventions including singular naming and specific MySQL encodings
29 GitHub stars

Casos de Uso

Generating typed entity classes from database schemas with proper phpDoc relationships
Constructing complex filtered queries using progressive refinement and reusable base methods
Implementing service-level error handling to transform database constraints into business exceptions

Acerca de

Características Principales

Optimized query building using Nette Selection API and colon notation for joins
Decision logic for choosing between Explorer API and raw SQL for complex analytics
Automated entity mapping and ActiveRow documentation patterns for IDE support
Schema management strategies using direct SQL migrations and database constraints
Standardized database conventions including singular naming and specific MySQL encodings
29 GitHub stars

Casos de Uso

Generating typed entity classes from database schemas with proper phpDoc relationships
Constructing complex filtered queries using progressive refinement and reusable base methods
Implementing service-level error handling to transform database constraints into business exceptions