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+.

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

01Optimized query building using Nette Selection API and colon notation for joins

02Decision logic for choosing between Explorer API and raw SQL for complex analytics

03Automated entity mapping and ActiveRow documentation patterns for IDE support

04Schema management strategies using direct SQL migrations and database constraints

05Standardized database conventions including singular naming and specific MySQL encodings

0629 GitHub stars

Casos de Uso

01Generating typed entity classes from database schemas with proper phpDoc relationships

02Constructing complex filtered queries using progressive refinement and reusable base methods

03Implementing service-level error handling to transform database constraints into business exceptions

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add nette/claude-code nette-database

For use in Claude.ai and ChatGPT

Download Skill