How does this skill improve Ecto security?

It ensures that programmatic fields like user IDs are never included in 'cast' calls, preventing mass-assignment vulnerabilities by explicitly setting them via put_assoc or direct struct manipulation.

How does it handle migration file generation?

It guides Claude to use the standard 'mix ecto.gen.migration' command with underscore naming conventions to maintain proper timestamping and database consistency.

Can it help with N+1 query issues?

Yes, it enforces the requirement to preload Ecto associations in queries whenever they are accessed in templates, ensuring efficient data fetching.

What is the recommended way to access changeset fields?

The skill mandates using Ecto.Changeset.get_field/2 instead of map access syntax to ensure you are correctly retrieving data from the changeset's changes or data source.

Phoenix Ecto Best Practices

Name: Phoenix Ecto Best Practices
Author: code0100fun

bycode0100fun

0•

Database Management

Implements industry-standard patterns for Ecto schemas, changesets, and database migrations in Elixir applications.

This skill provides a comprehensive set of rules and patterns for working with Ecto in Elixir and Phoenix projects. It guides Claude through critical tasks such as handling preloads for templates to prevent N+1 queries, ensuring secure field manipulation by avoiding programmatic fields in 'cast' calls, and maintaining strict changeset validation protocols. By enforcing these conventions, the skill helps developers avoid security vulnerabilities in data persistence and ensures robust, maintainable database interactions through proper field access and migration naming.

Key Features

01Secure programmatic field handling for changesets

02Standardized Ecto association preloading patterns

03Strict changeset field access using get_field

040 GitHub stars

05Migration generation and naming conventions

06Correct field type mapping for Ecto schemas

Use Cases

01Designing secure database schemas and changesets

02Optimizing query performance with proper association preloading

03Generating database migrations following Elixir conventions

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add code0100fun/botfiles ecto-guidelines

For use in Claude.ai and ChatGPT

Download Skill