OPS
Operations desk
The overlapping desk: incidents, configuration, and the glue between teams. Built for the people who sit between titles.
529–552 / 1864
Parameterized Query Converter
LiveConvert inline values into parameterized queries. The result stays on this page.
Open toolStored Procedure Template Generator
LiveGenerate procedure skeletons with error handling. The result stays on this page.
Open toolTrigger Generator
LiveGenerate audit/timestamp triggers per dialect. The result stays on this page.
Open toolJSON Path Query Builder for SQL
LiveBuild JSON_VALUE/->>/JSON_EXTRACT expressions. The result stays on this page.
Open toolRecursive Hierarchy Query Generator
LiveRecursive Hierarchy Query Generator. Generate parent/child tree queries. The result stays on this page.
Open toolER Diagram from SQL DDL
LiveRenders an entity-relationship diagram from CREATE TABLE statements. The result stays on this page.
Open toolDDL Generator from ER Diagram
LiveDraw tables and generate CREATE TABLE scripts. The result stays on this page.
Open toolCSV to CREATE TABLE Generator
LiveCSV to CREATE TABLE Generator. Infer columns and types from CSV. The result stays on this page.
Open toolPrimary Key Strategy Selector
LivePrimary Key Strategy Selector. Compare INT, BIGINT, UUID, ULID keys. The result stays on this page.
Open toolSchema Diff Tool
LiveCompare two schemas and generate ALTER scripts. The result stays on this page.
Open toolDDL Converter Between Databases
LiveDDL Converter Between Databases. Convert CREATE TABLE across engines. The result stays on this page.
Open toolMulti-Tenant Schema Planner
LiveCompare shared, schema-per-tenant, DB-per-tenant. The result stays on this page.
Open toolEXPLAIN Plan Visualizer
LiveVisualizes PostgreSQL/MySQL EXPLAIN output as a tree. The result stays on this page.
Open toolPostgreSQL EXPLAIN ANALYZE Analyzer
LivePostgreSQL EXPLAIN ANALYZE Analyzer. Find the slow node and explain why. The result stays on this page.
Open toolMySQL EXPLAIN Analyzer
LiveInterpret MySQL EXPLAIN and FORMAT=JSON output. The result stays on this page.
Open toolSQL Server Execution Plan Viewer
LiveOpen .sqlplan XML and highlight costly operators. The result stays on this page.
Open toolIndex Advisor from Query
LiveSuggest indexes for a given query and schema. The result stays on this page.
Open toolSQL Anti-Pattern Detector
LiveFind SELECT *, implicit conversions, OR traps. The result stays on this page.
Open toolN+1 Query Detector from Logs
LiveDetect N+1 query patterns in query logs. The result stays on this page.
Open toolMySQL Slow Query Log Analyzer
LiveSummarize slow log like pt-query-digest. The result stays on this page.
Open toolSQL Server Wait Stats Analyzer
LiveSQL Server Wait Stats Analyzer. Interpret wait statistics output. The result stays on this page.
Open toolDeadlock Graph Viewer
LiveDeadlock Graph Viewer. Visualize SQL Server deadlock XML. The result stays on this page.
Open toolSQL Server tempdb Files Calculator
LiveSQL Server tempdb Files Calculator. Number and size of tempdb data files. The result stays on this page.
Open toolOracle SGA/PGA Calculator
LiveOracle SGA/PGA Calculator. Size SGA and PGA targets from RAM. The result stays on this page.
Open tool