Database & SQL · page 2

Creates queries that identify unmatched child records.

Generates created-at, updated-at, and actor column definitions.

Checks table and column names against a configurable convention.

Generates CHECK, UNIQUE, and NOT NULL constraint templates.

Flags UPDATE statements that may lack appropriate filters.

Creates backup command templates for supported database engines.

Replaces selected literal values with named or positional parameters.

Adds explanatory comments to a supplied SQL query.

Estimates table storage using row counts and approximate column sizes.

Splits a script at supported statement boundaries.

Compares two query-result tables using selected key columns.

Reviews supplied MySQL configuration values against workload requirements.

Organizes exported index definitions by database and table.

Creates backup schedules based on recovery requirements.

Reviews supplied PostgreSQL table and constraint definitions.

Organizes PostgreSQL index definitions from supplied catalog output.

Explains common fields in a pasted PostgreSQL execution plan.

Creates maintenance checklists based on supplied database statistics.

Summarizes supplied SQLite schema objects.

Checks supplied SQLite table definitions for relationship constraints.

Suggests index candidates from supplied queries and schema descriptions.

Organizes seed operations according to foreign-key dependencies.

Generates a checklist for safely renaming database columns.

Creates a review plan for renaming tables across application references.