Free tools

43 in-browser utilities, plus converters and an interview sandbox. Nothing is uploaded.

47 tools

Hubs Excel → T-SQL VLOOKUP, IF, COUNTIF, SUMPRODUCT. One page per function. Hubs Pandas → T-SQL merge, groupby, fillna, drop_duplicates, loc. Hubs SQL dialect translator MySQL, Postgres, Oracle, Snowflake → SQL Server. Hubs Interview sandbox Top N per group, running totals, anti-joins. Draft and reveal. Everyday T-SQL formatter Paste a one-liner. Get keywords in uppercase and clauses on their own lines. Everyday DATEADD / DATEDIFF Pick the unit and the dates. Copy the exact SQL Server syntax. Everyday Mock INSERT builder Column names in. Dummy rows out. Nothing hits a real database. Everyday Regex → LIKE Turn a simple regex into LIKE or PATINDEX. Full regex is not SQL. Everyday Window preview Five rows. Click ROW_NUMBER, RANK or a running SUM and watch the numbers move. Architecture Schema → diagram Paste CREATE TABLE. Get a live table diagram and Mermaid you can export. Architecture Data type picker Answer a few questions. Get INT, DECIMAL, NVARCHAR or the rest. Architecture Schema diff → ALTER Paste two CREATE TABLE scripts. See added, dropped, changed columns and the ALTER. Architecture Key evaluator Describe the columns. Get a recommendation: identity, composite, or uniqueidentifier. Architecture Name sanitizer Messy labels in. PascalCase, snake_case or [Bracketed] out. Aggregation CASE WHEN builder Type if/then rules. Copy a nested CASE block. Aggregation Cohort buckets Column + weekly / monthly / quarter. Copy the DATEPART grain. Aggregation Fiscal year Year starts in October? Pick the month. Get FY and FQ. Aggregation Concat wizard SQL Server CONCAT / +, or || for others. NULL-safe. Aggregation PIVOT blueprint Row header, pivot column, value. A template you can finish. Cleaning CSV → INSERT Paste a sheet. Get INSERT INTO … VALUES rows. Cleaning JSON → OPENJSON Paste a JSON object. Get OPENJSON … WITH types. Cleaning NULL vs blank filter Pick how “missing” was stored. Copy the WHERE. Cleaning Duplicate finder Table + unique columns. Copy the hunt query. Cleaning CONVERT styles Click 103, 120, 23. Copy CONVERT(varchar, GETDATE(), n). Speed JOIN Venn Click inner, left, right, full, cross. See the rows and the SQL. Speed Index advisor Paste the filters. Get a starting CREATE INDEX. Speed SARGable rewrite Paste a WHERE. We flag YEAR(column) and rewrite the range. Speed LIKE performance Prefix % vs suffix %. What the index can use. Speed CTE vs #temp Four questions. WITH or #temp. Security Data masking Email, card, default. Copy ALTER TABLE … ADD MASKED. Security Anonymize PII Columns in. SHA2-256 updates out. For a test copy, not production login. Security Row-level security Tenant column in. Predicate function and policy out. Security Audit trigger Table + watched columns. A log-table trigger draft. Security Injection checker Paste app code that builds SQL. We flag string concatenation and show parameters. Quality of life Excel → SQL VLOOKUP, IF, CONCATENATE → JOIN, CASE, CONCAT. Quality of life Calendar / tally CTE From / to dates. A calendar table query. Quality of life Connection string Server, database, auth, port. .NET, Python, Node, SSMS. Quality of life Script batcher Long INSERT list. Split every N rows or inject GO. Quality of life List → IN () Paste a column of ids or emails. Get IN ('a', 'b'). Architecture Row size calculator INT, VARCHAR, DATETIME in. Bytes per row and a million-row estimate out. Cleaning Date format matrix Pick in and out. Get CONVERT, TRY_PARSE, or FORMAT. Quality of life Mock data factory Names, UK postcodes, amounts. A tally CTE, no API. Speed Index rebuild script Reorg > 10%, rebuild > 30%. Uses sys.dm_db_index_physical_stats. Security GDPR / PII wizard Hash, scramble, or MASKED WITH. For a test copy, not a login store. Security Schema auditor Table + events. A log table and the trigger. Cleaning CSV → MERGE Match on a key. Update the rest. Insert the new ones. Cleaning Text sanitizer Spaces, country codes, nested REPLACE / PATINDEX.