Firestore Index Creator

What it does

This skill allows you to create Firestore indexes directly from prompts. It automates the process of defining index fields and ordering, ensuring your queries perform efficiently. The skill generates the necessary JSON configuration for creating these indexes within your Firebase project.

When to use it

• You need to optimize query performance in a Firestore database that's experiencing slow response times.
• A developer requests you to create an index for a specific query pattern.
• You are setting up a new Firestore database and want to proactively define indexes for anticipated queries.
• You’re refactoring existing queries and need to generate the corresponding index definitions.

Key capabilities

• Generates Firestore index JSON configuration from natural language prompts.
• Automates index creation based on query requirements.
• Supports defining fields and ordering within the generated indexes.

Example prompts

• "Create an index for products ordered by price descending, with a filter on category."
• "Generate a Firestore index to efficiently query users by email."
• “I need an index for messages sorted by timestamp ascending.”

Tips & gotchas

• The skill requires familiarity with Firestore indexing concepts and query patterns. Clearly defining the desired fields and ordering in your prompts will yield better results.