Rails Active Record

What it does

This skill enables AI agents to interact with and manipulate data within a Ruby on Rails application using Active Record, the ORM. It allows for querying databases, creating new records, updating existing ones, and deleting data based on user instructions. The agent can perform these actions efficiently without needing direct SQL knowledge.

When to use it

• Data Entry Automation: Automatically create customer records in a Rails application from external sources like spreadsheets or APIs.
• Content Updates: Modify product descriptions or blog post content within the Rails database based on user requests.
• Report Generation: Query and extract specific data sets for generating reports, such as sales figures or inventory levels.
• Database Cleanup: Delete old or irrelevant records from the database according to defined criteria.

Key capabilities

• Querying databases using Active Record syntax.
• Creating new database records.
• Updating existing database records.
• Deleting database records.

Example prompts

• "Create a new user with email '[email protected]' and password 'password'."
• "Find all products with a price greater than $50."
• "Update the status of order #123 to 'shipped'."
• "Delete all blog posts older than one year."

Tips & gotchas

• Requires familiarity with Rails data models and Active Record conventions.
• Be specific with record attributes and conditions to avoid unintended consequences.