Ecto Thinking

What it does

The ecto-thinking skill allows AI agents to reason about and generate Ecto queries, a popular Elixir library for database interaction. It can translate natural language descriptions into functional Ecto code, helping developers build data access layers more efficiently. This includes generating migrations, schemas, and queries based on provided requirements.

When to use it

• Generating Ecto Schemas: You need to quickly define a new Elixir application's database schema from a textual description of the entities involved.
• Creating Database Migrations: You want to automate the creation of migration files for evolving your database structure.
• Building Complex Queries: You have a complex data retrieval requirement and prefer to express it in natural language rather than writing raw Ecto code.
• Rapid Prototyping: Quickly generate basic database interaction logic during initial development phases.

Key capabilities

• Ecto schema generation
• Database migration creation
• Query generation from natural language descriptions
• Functional Ecto code translation

Example prompts

• "Create an Ecto schema for a 'product' with fields: id, name, price, and description."
• "Generate a database migration to add an index on the 'email' field of the 'users' table."
• “Write an Ecto query to find all products with a price greater than 50.”

Tips & gotchas

The skill is most effective when provided with clear and concise descriptions. A basic understanding of Elixir and Ecto concepts will help you interpret the generated code and adapt it as needed.