Dart Drift

The dart-drift skill enables AI agents to interact with Dart applications using Drift, a powerful relational database toolkit. It allows agents to define schemas, manage migrations, and execute complex SQL queries directly within the Dart ecosystem. This integration streamlines data persistence for Flutter apps and server-side Dart services without manual code intervention.

When to use it

• Automating database schema creation and version control updates in large-scale Dart projects.
• Executing ad-hoc analytical SQL queries against production data stored in Drift databases.
• Generating boilerplate code for entity classes and repositories based on defined table structures.
• Performing automated data migrations to ensure consistency across different deployment environments.

Key capabilities

• Schema Definition: Automatically generates Dart models and database tables from natural language descriptions.
• Migration Management: Creates and applies migration scripts to evolve the database structure over time.
• Query Execution: Runs complex SELECT, INSERT, UPDATE, and DELETE statements against Drift-managed databases.
• Entity Mapping: Maps relational database columns directly to Dart class properties with type safety.

Example prompts

• "Create a new Drift table for user profiles including fields for email, age, and registration date."
• "Write a migration script to add an 'isActive' boolean column to the existing users table."
• "Generate a query to find all users who signed up in the last 30 days and have not logged in."

Tips & gotchas

Ensure your Dart environment has the drift package installed before attempting database operations. Complex queries involving multiple joins may require specific syntax adjustments depending on the Drift version supported by the agent.