All tools · page 11

Generates date-range conditions with configurable boundaries.

Demonstrates how NULL affects SQL comparisons and aggregates.

Tests COUNT, SUM, AVG, MIN, and MAX on sample records.

Generates starter queries for common window functions.

Creates common table expression templates for supplied queries.

Generates queries for identifying duplicate records.

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.