All about SQL

Content

PacketQ: Query PCAPs using SQL PostgreSQL's Explain Analyze made Readable Postgres Explain Visualizer Table Magic: Convert between table formats

PacketQ: Query PCAPs using SQL

https://github.com/DNS-OARC/PacketQ

DNS | SQL | Tool

packetq is a command line tool to run SQL queries directly on PCAP files, the results can be outputted as JSON (default), formatted/compact CSV and XML. It also contains a very simplistic web-server in order to inspect PCAP files remotely,

PostgreSQL's Explain Analyze made Readable

https://explain.depesz.com/s/w1Wko

SQL | Tool

The website takes a Postgres Explain output and displays it more readable and highlights the important parts.

Postgres Explain Visualizer

https://tatiyants.com/pev/#/plans/new

SQL | Tool

The website takes a Postgres Explain output and displays it as a more readable graph.

Table Magic: Convert between table formats

https://stevecat.net/table-magic/

HTML | Markdown | SQL | Tool

The website can convert between different table formats. It supports CSV, Markdown, SQL, HTML. It is useful when embedding CSV data into Markdown or similar.