Using Drizzle Queries

What it does

This skill enables AI agents to execute type-safe database queries using Drizzle ORM, a modern JavaScript ORM for relational databases. It allows for performing common database operations like selecting data (with filtering and ordering), inserting new records, updating existing records, deleting records, and constructing relational queries involving multiple tables. The skill facilitates defining and managing database schemas as well.

When to use it

• When you need an AI agent to retrieve specific data from a structured database based on certain criteria.
• To automate the insertion of new data into your database.
• For updating existing records in your database programmatically.
• To delete unwanted or obsolete data from your database.
• When defining and managing the structure (schema) of tables within your database.

Key capabilities

• Type-safe queries: Generates queries with type safety using Drizzle ORM.
• Select Queries: Retrieves data based on various filters, ordering options (ascending/descending), and limits.
• Insert Operations: Inserts single or multiple records into database tables.
• Update Operations: Modifies existing records in a table based on specified criteria.
• Delete Operations: Removes records from a table based on specific conditions.
• Relational Queries: Constructs queries that join data from related tables.
• Schema Management: Defines and manages database table schemas, including specifying column types and constraints.

Example prompts

• "Retrieve all chats ordered by creation date in descending order."
• "Insert a new chat with userId '123' and title 'Meeting Notes'."
• "Update the title of chat with ID 'abc-123' to 'Revised Meeting Notes'."
• "Delete the chat with ID 'xyz-789'."

Tips & gotchas

• Requires a Drizzle ORM database setup, including a connection established via db.select().
• The skill relies on pre-defined schemas (e.g., "chats", "messages", "items") which must exist in the database.
• Ensure that the AI agent has access to and understands the structure of your database schema for accurate query generation.