Ferramentas práticas para administradores de sistemas, redes, segurança e operações.

OPS

Secretária de operações

A secretária partilhada: incidentes, configuração e a cola entre equipas. Para quem se senta entre títulos.

529–552 / 1864

Parameterized Query Converter

Ativo

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

Abrir ferramenta

Stored Procedure Template Generator

Ativo

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

Abrir ferramenta

Trigger Generator

Ativo

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

Abrir ferramenta

JSON Path Query Builder for SQL

Ativo

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

Abrir ferramenta

Recursive Hierarchy Query Generator

Ativo

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

Abrir ferramenta

ER Diagram from SQL DDL

Ativo

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

Abrir ferramenta

DDL Generator from ER Diagram

Ativo

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

Abrir ferramenta

CSV to CREATE TABLE Generator

Ativo

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

Abrir ferramenta

Primary Key Strategy Selector

Ativo

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

Abrir ferramenta

Schema Diff Tool

Ativo

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

Abrir ferramenta

DDL Converter Between Databases

Ativo

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

Abrir ferramenta

Multi-Tenant Schema Planner

Ativo

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

Abrir ferramenta

EXPLAIN Plan Visualizer

Ativo

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

Abrir ferramenta

PostgreSQL EXPLAIN ANALYZE Analyzer

Ativo

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

Abrir ferramenta

MySQL EXPLAIN Analyzer

Ativo

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

Abrir ferramenta

SQL Server Execution Plan Viewer

Ativo

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

Abrir ferramenta

Index Advisor from Query

Ativo

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

Abrir ferramenta

SQL Anti-Pattern Detector

Ativo

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

Abrir ferramenta

N+1 Query Detector from Logs

Ativo

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

Abrir ferramenta

MySQL Slow Query Log Analyzer

Ativo

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

Abrir ferramenta

SQL Server Wait Stats Analyzer

Ativo

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

Abrir ferramenta

Deadlock Graph Viewer

Ativo

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

Abrir ferramenta

SQL Server tempdb Files Calculator

Ativo

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

Abrir ferramenta

Oracle SGA/PGA Calculator

Ativo

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

Abrir ferramenta