Operaatiopöytä

Format SQL with indentation and consistent keyword casing in the browser.

Estimate savings from shutting down non-production resources outside business hours.

Rough monthly estimate for compute, storage, and network using editable unit rates.

Estimate data transfer (egress) costs across common cloud pricing bands.

Explain what a SQL query does in plain English. The result stays on this page.

Visualize INNER/LEFT/RIGHT/FULL joins with sample data. The result stays on this page.

Build SELECT queries from tables and columns visually. The result stays on this page.

Build ROW_NUMBER, RANK, LAG/LEAD, running totals. The result stays on this page.

Equivalent date functions across databases. The result stays on this page.

Generate queries to find/delete duplicate rows. The result stays on this page.

Generate INSERT ON CONFLICT / MERGE / ON DUPLICATE KEY. The result stays on this page.

Turn a column of values into a SQL IN list. The result stays on this page.

Suggests buffer pool and key settings from RAM and workload. The result stays on this page.

Suggests shared_buffers, work_mem etc. from hardware specs. The result stays on this page.

Recommends max server memory setting for SQL Server. The result stays on this page.

Recommend MAXDOP and cost threshold for parallelism. The result stays on this page.

InnoDB Buffer Pool Calculator. Size innodb_buffer_pool and instances. The result stays on this page.

Builds backup and restore commands with options. The result stays on this page.

Plan full/differential/log backups by RPO/RTO. The result stays on this page.

Generate backup/maintenance jobs (Ola Hallengren style). The result stays on this page.

Build GRANT/REVOKE statements per engine. The result stays on this page.

Generate PostgreSQL client authentication rules. The result stays on this page.

Converts CSV data into INSERT statements. The result stays on this page.

Convert JSON arrays into INSERT statements. The result stays on this page.