SQL & Database Lab
Build, normalize and inspect common SQL text locally in your browser. 25 tools are currently live in this section.
SQL Keyword Uppercaser
Uppercase common SQL keywords while leaving other text intact.
Open tool →SQL Keyword Lowercaser
Lowercase common SQL keywords while leaving other text intact.
Open tool →SQL Whitespace Normalizer
Collapse repeated SQL whitespace outside quoted strings.
Open tool →SQL Comment Remover
Remove common -- line comments and /* block comments */ from SQL text.
Open tool →SQL Statement Splitter
Split semicolon-delimited SQL statements while respecting quoted strings.
Open tool →SQL Relation Name Extractor
Extract simple table names following FROM, JOIN, UPDATE, INSERT INTO and DELETE FROM.
Open tool →SQL Alias Extractor
Extract common table aliases from FROM and JOIN clauses.
Open tool →SQL Named Parameter Extractor
List :named SQL parameters without duplicates.
Open tool →SQL Placeholder Counter
Count question-mark bind markers outside quoted strings.
Open tool →SQL IN List Builder
Convert one value per line into a safely quoted SQL IN (...) list.
Open tool →SQL INSERT Statement Builder
Build a simple parameterized INSERT statement from a table and comma-separated columns.
Open tool →SQL UPDATE Statement Builder
Build a simple parameterized UPDATE statement from columns and a WHERE clause.
Open tool →SQL DELETE Statement Builder
Build a DELETE statement with an explicit WHERE clause.
Open tool →SQL SELECT Statement Builder
Build a simple SELECT statement from table, columns and optional WHERE clause.
Open tool →SQL CREATE TABLE Builder
Build a basic CREATE TABLE statement from one column definition per line.
Open tool →SQL LIMIT/OFFSET Builder
Generate a LIMIT/OFFSET clause from numeric values.
Open tool →SQL ORDER BY Builder
Generate an ORDER BY clause from a column list and direction.
Open tool →SQL GROUP BY Builder
Generate a GROUP BY clause from comma-separated columns.
Open tool →SQL Equality WHERE Builder
Generate parameterized equality predicates from comma-separated column names.
Open tool →SQL Identifier Quoter
Quote dot-separated SQL identifiers with ANSI double quotes.
Open tool →SQL String Literal Escaper
Escape single quotes for a standard SQL string literal.
Open tool →SQL VALUES Tuple Builder
Convert CSV-like rows into SQL VALUES tuples with quoted string cells.
Open tool →SQL Duplicate Column Finder
Find duplicate names in a comma-separated SQL column list.
Open tool →SQL JOIN Clause Builder
Generate a JOIN clause from table, alias and ON expression.
Open tool →SQL Query Fingerprinter
Normalize common SQL literals and whitespace to compare query shapes.
Open tool →About SQL & Database Lab
Build, normalize and inspect common SQL text locally in your browser. MediaZuno groups closely related utilities together so you can move between tasks without hunting across different websites.