Herramientas prácticas para administradores de sistemas, redes, seguridad y operaciones.

OPS

Escritorio de operaciones

El escritorio compartido: incidentes, configuración y el pegamento entre equipos. Para quienes se sientan entre títulos.

529–552 / 1864

Parameterized Query Converter

Activo

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

Abrir herramienta

Stored Procedure Template Generator

Activo

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

Abrir herramienta

Trigger Generator

Activo

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

Abrir herramienta

JSON Path Query Builder for SQL

Activo

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

Abrir herramienta

Recursive Hierarchy Query Generator

Activo

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

Abrir herramienta

ER Diagram from SQL DDL

Activo

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

Abrir herramienta

DDL Generator from ER Diagram

Activo

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

Abrir herramienta

CSV to CREATE TABLE Generator

Activo

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

Abrir herramienta

Primary Key Strategy Selector

Activo

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

Abrir herramienta

Schema Diff Tool

Activo

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

Abrir herramienta

DDL Converter Between Databases

Activo

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

Abrir herramienta

Multi-Tenant Schema Planner

Activo

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

Abrir herramienta

EXPLAIN Plan Visualizer

Activo

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

Abrir herramienta

PostgreSQL EXPLAIN ANALYZE Analyzer

Activo

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

Abrir herramienta

MySQL EXPLAIN Analyzer

Activo

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

Abrir herramienta

SQL Server Execution Plan Viewer

Activo

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

Abrir herramienta

Index Advisor from Query

Activo

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

Abrir herramienta

SQL Anti-Pattern Detector

Activo

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

Abrir herramienta

N+1 Query Detector from Logs

Activo

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

Abrir herramienta

MySQL Slow Query Log Analyzer

Activo

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

Abrir herramienta

SQL Server Wait Stats Analyzer

Activo

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

Abrir herramienta

Deadlock Graph Viewer

Activo

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

Abrir herramienta

SQL Server tempdb Files Calculator

Activo

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

Abrir herramienta

Oracle SGA/PGA Calculator

Activo

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

Abrir herramienta