Guides
Practical write-ups on the problems SQL Toolkit's tools are built to solve — safe migrations, converting data between formats, and keeping documentation from going stale.
How to Add a NOT NULL Column Without Locking Your Postgres Table
A backfill-then-validate migration pattern that avoids holding a table-wide lock for the duration of a full table scan.
DROP COLUMN in Production: What Actually Breaks (and How to Check First)
The database operation is usually fine — it’s old deploys, cached queries, and background jobs still expecting the column that break.
How to Convert a CSV File to SQL INSERT Statements
Quoting, type inference, NULL vs empty string, and the escaping bug that causes most hand-rolled CSV import scripts to break.
Importing JSON API Responses into a SQL Database
Flattening nested fields, handling inconsistent keys across items, and picking a sane primary key before you convert.
Excel to SQL: Turning a Spreadsheet into a Real Database Table
Header cleanup, merged cells, and the Excel date-formatting quirk that silently turns dates into meaningless numbers.
How to Auto-Generate Documentation from a CREATE TABLE Statement
Why hand-maintained schema wikis always drift from reality, and what to include when you generate docs straight from the SQL.