Bureau exploitation, page 23

Parameterized Query Converter

Actif

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

Ouvrir l'outil

Stored Procedure Template Generator

Actif

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

Ouvrir l'outil

Trigger Generator

Actif

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

Ouvrir l'outil

JSON Path Query Builder for SQL

Actif

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

Ouvrir l'outil

Recursive Hierarchy Query Generator

Actif

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

Ouvrir l'outil

ER Diagram from SQL DDL

Actif

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

Ouvrir l'outil

DDL Generator from ER Diagram

Actif

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

Ouvrir l'outil

CSV to CREATE TABLE Generator

Actif

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

Ouvrir l'outil

Primary Key Strategy Selector

Actif

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

Ouvrir l'outil

Schema Diff Tool

Actif

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

Ouvrir l'outil

DDL Converter Between Databases

Actif

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

Ouvrir l'outil

Multi-Tenant Schema Planner

Actif

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

Ouvrir l'outil

EXPLAIN Plan Visualizer

Actif

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

Ouvrir l'outil

PostgreSQL EXPLAIN ANALYZE Analyzer

Actif

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

Ouvrir l'outil

MySQL EXPLAIN Analyzer

Actif

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

Ouvrir l'outil

SQL Server Execution Plan Viewer

Actif

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

Ouvrir l'outil

Index Advisor from Query

Actif

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

Ouvrir l'outil

SQL Anti-Pattern Detector

Actif

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

Ouvrir l'outil

N+1 Query Detector from Logs

Actif

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

Ouvrir l'outil

MySQL Slow Query Log Analyzer

Actif

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

Ouvrir l'outil

SQL Server Wait Stats Analyzer

Actif

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

Ouvrir l'outil

Deadlock Graph Viewer

Actif

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

Ouvrir l'outil

SQL Server tempdb Files Calculator

Actif

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

Ouvrir l'outil

Oracle SGA/PGA Calculator

Actif

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

Ouvrir l'outil