drupal-database-api

What problem does it solve?

This Skill provides a robust and secure way to interact with your Drupal site's database, enabling custom table creation, complex query writing, and schema management.

Core Features & Use Cases

• Custom Table Management: Define and manage custom database tables using hook_schema() and update hooks.
• Secure Querying: Write dynamic and static SQL queries safely using Drupal's Database API, preventing SQL injection.
• Schema Evolution: Handle database schema changes gracefully with update hooks and batch processing.
• Use Case: You need to store custom log data for your module. This Skill helps you define a new table, insert log entries, and retrieve them efficiently.

Quick Start

Use the drupal-database-api skill to define a new table named 'my_log_table' with columns 'message' (text) and 'timestamp' (int) in your module's install file.