Database Test Helper

What it does

The database-test-helper skill assists in generating SQL queries for testing database interactions. It can create INSERT, UPDATE, and DELETE statements based on provided data or schema information. This simplifies the process of setting up test databases and verifying expected outcomes during development and QA.

When to use it

• Automated Testing: Generate SQL scripts to populate a test database with specific data for running automated tests.
• Data Migration Validation: Create queries to verify that data migrations are correctly transforming and loading data into the target database.
• Database Schema Exploration: Quickly generate sample data based on a given table schema to understand its structure and constraints.
• Debugging Data Issues: Construct SQL statements to manipulate test data for debugging purposes, such as reverting changes or inserting specific records.

Key capabilities

• Generates INSERT statements from provided data.
• Creates UPDATE statements based on specified conditions.
• Produces DELETE statements targeting specific rows in a table.
• Works with database schemas (table definitions).

Example prompts

• "Generate an INSERT statement for the 'users' table with name='Alice', email='[email protected]'."
• "Create an UPDATE statement to set the status of order ID 123 to 'shipped'."
• "Give me a DELETE statement to remove all records from the 'logs' table older than one week."

Tips & gotchas

The skill requires access to database schema information (table names, column definitions) for optimal results. Providing clear and specific instructions regarding data types and constraints will improve the accuracy of generated SQL queries.