Directory of SQL tools and Utils

Open source SQL tools and utils

Open source SQL tools and utils

Poom Wettayakorn

Mar 15, 2024

Mar 15, 2024

directory

👋 Hi there, welcome to Datascale: SQL+Data modeling. We help create database diagrams and map out data models from existing schema and SQL queries 🌱. Find us on LinkedIn 🎉

SQL toolkit and utils

This is for data engineers / analytics engineers who want to level-up their data management by

  • ensuring team consistency in SQL queries -> linting problem.

  • extracting metadata from your SQL queries -> parsing problem.

  • mapping views/tables from source to its destination -> lineage problem.

  • modeling joint relationships from your tables -> data modeling problem.

Free Utils / Open source

  1. SQL Lint, formatter, fix anti-patterns:

  2. SQL parser, transpiler, optimizer

  3. Parsing Metadata

  4. Data lineage

Tools

  1. Database Diagrams:

  2. Data quality:

Comparisons

  1. DBT vs SQLMesh

  2. Datascale's SQL notes vs traditional saved queries or DBeaver's script management

// Last updated May 20, 2024

Related blogs

Contents

Section

Get a clear view of your SQL dependencies

Datascale helps reverse engineer data models from existing schema and SQL queries

Learn more

Where data gets modeled

Where data gets modeled

Where data gets modeled