Operaatiopöytä

Convert inline values into parameterized queries. The result stays on this page.

Generate procedure skeletons with error handling. The result stays on this page.

Generate audit/timestamp triggers per dialect. The result stays on this page.

Build JSON_VALUE/->>/JSON_EXTRACT expressions. The result stays on this page.

Recursive Hierarchy Query Generator. Generate parent/child tree queries. The result stays on this page.

Renders an entity-relationship diagram from CREATE TABLE statements. The result stays on this page.

Draw tables and generate CREATE TABLE scripts. The result stays on this page.

CSV to CREATE TABLE Generator. Infer columns and types from CSV. The result stays on this page.

Primary Key Strategy Selector. Compare INT, BIGINT, UUID, ULID keys. The result stays on this page.

Compare two schemas and generate ALTER scripts. The result stays on this page.

DDL Converter Between Databases. Convert CREATE TABLE across engines. The result stays on this page.

Compare shared, schema-per-tenant, DB-per-tenant. The result stays on this page.

Visualizes PostgreSQL/MySQL EXPLAIN output as a tree. The result stays on this page.

PostgreSQL EXPLAIN ANALYZE Analyzer. Find the slow node and explain why. The result stays on this page.

Interpret MySQL EXPLAIN and FORMAT=JSON output. The result stays on this page.

Open .sqlplan XML and highlight costly operators. The result stays on this page.

Suggest indexes for a given query and schema. The result stays on this page.

Find SELECT *, implicit conversions, OR traps. The result stays on this page.

Detect N+1 query patterns in query logs. The result stays on this page.

Summarize slow log like pt-query-digest. The result stays on this page.

SQL Server Wait Stats Analyzer. Interpret wait statistics output. The result stays on this page.

Deadlock Graph Viewer. Visualize SQL Server deadlock XML. The result stays on this page.

SQL Server tempdb Files Calculator. Number and size of tempdb data files. The result stays on this page.

Oracle SGA/PGA Calculator. Size SGA and PGA targets from RAM. The result stays on this page.